Re: TSM DB2 API Backup Question
Charles, DB2 backup to TSM is owned by the DB2 product team. I did pass this question on to them, this was the response: There is a potential for a hang if the online backup had to retrieve a log file from the TSM tape pool, but backup is using all of the tape drives. IBM DB2 is currently trying to decide how to handle this case, but do not have a good solution yet. This does not occur very often but is a pain when it does. Some recommendations to avoid this problem include: 1) Archive log files to a TSM Disk Pool (this is a best practice that all customers should be following) 2) Increase the LOGPRIMARY parameter on the DB so that all of the log files required by the backup remain on disk. Thanks, Del ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 01/02/2007 10:56:00 AM: 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
Re: TSM DB2 API Backup Question
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.
Re: 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
