Removing unneeded logs

[Troels Arvin]

Hello,

Is there a good way to delete all archive log files which aren't being
referenced by any backups any longer? I use TSM for the archive log files.

- I'm about to write a script for the task, probably by parsing
db2adutl's output. But I'm thinking that this task must be a general
theme at many places, and that some scripts/software for this already
exists?

--
Regards,
Troels Arvin <tr****@arvin.dk>
http://troels.arvin.dk/

[jmueller]

Troels,

if you can wait for DB2 9.5 you can use the new parameter called
AUTO_DEL_OBJ.
This parameter and NUM_DB_BACKUPS and REC_HIS_RETENTN will
do all the work for you.

Best reagrds
Joachim Müller

[Troels Arvin]

Hello,

On Tue, 18 Dec 2007 10:43:28 +0000, jmueller wrote:

if you can wait for DB2 9.5 you can use the new parameter called
AUTO_DEL_OBJ.
This parameter and NUM_DB_BACKUPS and REC_HIS_RETENTN will do all the
work for you.

Thanks, but I can't jump to v. 9.5 in the foreseeable future.

What do other people do?

By the way, this task is part of a larger task to implement the following
backup strategy (it turns out that is really a "purge-strategy", as the
clean-up part is the tricky one):

We want to be able to...

- return to a given point in time during the last 7 days

- beyond 7 days, we want to be able to restore from a daily (
mostly incremental) backup

- beyond 30 days, we want to be able to restore from a weekly,
non-incremental backup

- beyond 100 days, we don't want to keep backup data
(except occasional dumps to tapes which are transported to
another location)

--
Regards,
Troels Arvin <tr****@arvin.dk>
http://troels.arvin.dk/