ADSM-L

DB2 to ADSM

1999-07-01 00:41:12
Subject: DB2 to ADSM
From: Andrew Miller <andrew.miller AT ASPECT.COM DOT AU>
Date: Thu, 1 Jul 1999 14:41:12 +1000
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
<Prev in Thread] Current Thread [Next in Thread>
  • DB2 to ADSM, Andrew Miller <=