ADSM-L

[ADSM-L] Including logs in DB2 backups

2011-02-23 14:17:09
Subject: [ADSM-L] Including logs in DB2 backups
From: Thomas Denier <Thomas.Denier AT JEFFERSONHOSPITAL DOT ORG>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 23 Feb 2011 14:16:04 -0500
Some months ago I reported that some of the DB2 servers at our site were 
retrieving
archived files during database backups. The TSM server ended up cancelling at 
least
one and sometimes more than one of our offsite tape reclamation processes to 
make
tape drives available for the retrieve operations. I got a response from Michael
Garnebode explaining that the fix was to put "exclude logs" in the configuration
files for DB2 backups. When I asked our DBAs to do this I found out that 
including
the logs in DB2 backups was a deliberate choice which they were very reluctant 
to
give up. At the time I was willing to settle for a compromise: keep including 
the
logs but reschedule some DB2 backups so that there was never more than one 
concurrent
retrieve, and never more than one reclamation process cancelled. The TSM 
workload
has increased since then, and I would rather not have any reclamation processes
cancelled on a routine basis. My impression is that the "include logs" option is
completely pointless in a TSM environment. Is this correct? 
<Prev in Thread] Current Thread [Next in Thread>