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