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 <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> 01/02/2007 02:14 PM Please respond to "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> To ADSM-L@VM.MARIST.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@VM.MARIST.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.
