Can anyone assist with this situation ?
I have a requirement to keep DB2 daily backups for 30 days, month end for 14
months and year end for 7 years on an S70 running AIX 4.3.1, ADSM server
3.1.2.0, client 3.1.0.3 and DB2/UDB 5.2.
Daily backups are being done using the following command "db2 backup db <DB
NAME> use adsm", these are then kept for 30 days. In order to deletes backup
images older than 30 days the following command is used "db2adutl delete full
taken at <TIME STAMP> db <DB NAME> without prompting". That is OK for daily
backups.
Month end and year end backups are treated differently, first a daily backup is
taken then another backup to disk. The disk image is then archived to ADSM using
a management class that will keep the image for the correct number of days.
This was OK wile backing up a 4GB database, but a 40GB database is about to be
added onto this system and there is not enough disk space to do a DB2 to disk
backup then archive.
If anyone has come across this situation, how did you create and manage month
end and year end archives.
Andrew Miller
|