Thanks for the info... I'll have to increase that Diskpool so they don't
spool to tape first. I was just hoping that the dbs api could just do a
query and not have to mount the tape
Charles Hart
UHT - Data Protection
(763)744-2263
Sharepoint:
http://unitedteams.uhc.com/uht/EnterpriseStorage/DataProtection/default.aspx
BEYERS Kurt <Kurt.BEYERS AT VRT DOT BE>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
01/02/2007 02:14 PM
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To
ADSM-L AT VM.MARIST DOT EDU
cc
Subject
Re: [ADSM-L] TSM DB2 API Backup Question
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
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.
|
