ADSM-L

delete DB2 backups and logs

2003-05-16 05:19:40
Subject: delete DB2 backups and logs
From: "kurt.beyers AT pandora DOT be" <kurt.beyers AT PANDORA DOT BE>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 16 May 2003 11:19:17 +0200
Hello again,

I'm getting confused how the DB2 backups (DB2 7.1 on AIX 5.1 32bit) must be 
deleted in TSM (TSM server 5.1.6.3 also in AIX 5.1 32bit).

Will the following command:

'$db2adutl delete older than 14 days'

delete only the full/incremental/delta backups older than 14 days or are the 
logs that have been backed up older than 14 days also deleted?

or do you have to delete the logs with the command:

'$db2adutl delete logs between Sxxxxxx and Syyyyyy'

and in that case, does somebody already have a script to determine the Sxxxxx 
log file and Syyyyy log file. It shouldnt be too difficult but what if the log 
numbering returns from S9999999 to S0000000.

A lot of theoretical questions again, but I don't have a test DB2 server at the 
moment where I can verify it. Thanks for any help.

Kurt

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