Redhat Linux: DB2 V 8.2

Is there an option on the DB2 maintenance wizard (I have not seen it) to keep certain day worth of database backup files or I have to create a script to delete files older than some days ? What is the best approach ? Is there any script to delete file out there ?

Thanks.

We use a cron script to delete them. We have been doing this way for years and it works fine.

Andy

Can you post a sample script ?

Thanks.

The crontab for the instance owner looks like this:

# DB2's Crontab
################################################## ##################
#M H Day M Day
#I R of T of Command
#N S Mth H Week
################################################## ##################
#Backup of the LCAD_ATL Database
00 22 * * * /scripts/backup_LCAD_ATL.sh


The script the crontab shows looks like:

. /lcad_logs/db2inst1/sqllib/db2profile
db2 -tvf /lcad/onlinebu_LCAD_ATL.ddl


The file: /lcad/onlinebu_LCAD_ATL.ddl contains an online backup command for the database. Yours may vary.

Andy

Thanks.................