Charles,
A DB2 backup is done by using the command:
'db2 backup db <db-alias> online use tsm include logs'
It is the 'include logs' that will add the DB2 log files to the backup you are
referring too. But it is not true that all of the DB2 log files must be
validated first, this information is already stored in the TSM database.
The DB2 log files are archived to the archive copy pool in the management class
you are using for the DB2 backup. The database backup itself end up in the
backup copy pool of the same management class.
It might be more convenient to archive the DB2 log files to a disk storage pool
and migrate them only later on to a tape if you can't size a disk storage pool
for all of the DB2 log files. The latter case is the best solution since a
restore of the DB2 log files will go fast. Of course a backup of the disk
storage pool must be taken to a copy storage pool on tape and should be shipped
offsite. And the MediaW will disappear when the DB2 log files go to disk.
best regards,
Kurt
________________________________
Van: ADSM: Dist Stor Manager namens Charles A Hart
Verzonden: di 2/01/2007 16:56
Aan: ADSM-L AT VM.MARIST DOT EDU
Onderwerp: [ADSM-L] TSM DB2 API Backup Question
One of our TSM environments that is Backing up Unix and DB2 data is a bit
overrun at this point (lots of MediaW'). I was talking to our DB2 DBA and
he states that the final step to a On-line DB2 backup is to include the
transaction logs that occurred since the backup began. The DB2 log files
are archived to tape from the TSM DB2 API, so the full backup now requires
a tape mount to validate those logs files are complete. unfortunately
these DB2 Full backups sit and wait for tape....
Our question is there anyway to cfg these DB2 On-line Full Backups to just
"Query" TSM to validate the log files recvd? Or does it always have to
mount a tape. I was looking in the TSM DB2 manual but really haven't
found such an option.
Thanks Again for any help!!!!!!
Charles Hart
This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.
*** Disclaimer ***
Vlaamse Radio- en Televisieomroep
Auguste Reyerslaan 52, 1043 Brussel
nv van publiek recht
BTW BE 0244.142.664
RPR Brussel
http://www.vrt.be/disclaimer
|
