[Veritas-bu] NetBackup for DB2
2005-04-24 18:05:23
Hi Eric
Still a little confused,
We have a DB2 agent for NetBackup installed on the Window2003 server hosting
DB2.
The admin guide says edit the db2.conf file to include the policy and
schedule.
In order to backup to a new tape each day I need five policies, as each one
references a different volume pool each day. A tpl (template file is used
the backup selection list for the policy.
How can reference 5 policies one for each day, do I need 5 db2.conf files
each calling a different policy
Regards,
Imran
-----Original Message-----
From: Eric Ljungblad [mailto:Eric.Ljungblad AT CopleyPress DOT com]
Sent: 24 April 2005 11:51
To: 'Khan Imran A '; 'veritas-bu AT mailman.eng.auburn DOT edu '
Subject: RE: [Veritas-bu] NetBackup for DB2
The db1 and db2 / lawson should be on different tapes for speedy recovery.
lawson and db1 on the same tape is ok becuase db2 is double the
size. You must need redo02 as well? I perform these backups daily for HP
administrators and they have been happy for years including Disaster recover
at Sungaurd NY / Chicago sites.
1. First we use user initiated backups from HP but if you do not thats OK
but the database should be shut down 1st.
Example:
2. Policy called DB file list include db1 / db2 / redo02 / lawson
schedule is DB multiplexing = 1 media pool = DB - include
4 tapes in the media pool - move db1 to the top of the file list and
db2 to the bottom of the list, move lawson up under db1 and redo02
just above db2.
3. Then set policy attributes to allow multiple data streams -
This should work? I suggest Multiplexing set to 2 for this ? Incase a
tape runs out of space?
Thanks
-----Original Message-----
From: Khan Imran A
To: veritas-bu AT mailman.eng.auburn DOT edu
Sent: 4/23/2005 8:26 AM
Subject: [Veritas-bu] NetBackup for DB2
Hi
Can anyone help?
We have a NetBackup 5.1 solution which involves a Master Server (SCSI
attached library) and a number of clients two of which are DB2 on
windows 2003. One of the requirements is to have backups written to a
different tape each day, which is easily accommodated for in most
policies by having multiple schedules each using a different volume
pool. However, in database specific policies such as SQL and DB2 one
would need to have multiple policies to be able to write to a different
tape for each day of the week. In a SQL policy it is straight forward
have 5 policies writing to 5 different volume pools each with same .bch
file. I understand in DB2 it's a little different where there is *.conf
file which holds details on a policy, schedule and instance. The DB2
policy references a tpl (template file) or shell script. Do we need
multiple *.conf files or can multiple policies be referenced in the
*.conf file. What is the relationship between *.conf and template files.
I am new to DB2 can anyone help
Kind Regards,
Imran Khan
|
|
|