ADSM-L

Re: TSM DB2 API Backup Question

2007-01-04 10:32:12
Subject: Re: TSM DB2 API Backup Question
From: Del Hoobler <hoobler AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 4 Jan 2007 10:31:58 -0500
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 AT VM.MARIST DOT 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

<Prev in Thread] Current Thread [Next in Thread>