By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,756 Members | 1,745 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,756 IT Pros & Developers. It's quick & easy.

Removing unneeded logs

P: n/a
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/
Dec 17 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Dec 18 '07 #2

P: n/a
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/
Dec 18 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.