And if you keep a backup of DB2 for 10 years, how will you be able to read it 10 years from now? If you have the same version of DB2, the same OS and the same hardware, maybe. If not, no.
Perhaps an export to CSV or some other reasonably portable format instead... Just a thought. Kelly Lipp CTO STORServer, Inc. 485-B Elkton Drive Colorado Springs, CO 80907 719-266-8777 www.storserver.com -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Wanda Prather Sent: Thursday, June 26, 2008 10:45 AM To: [email protected] Subject: Re: [ADSM-L] Different db2 retention periods Use multiple nodenames, e.g: DB2client DB2client-monthly DB2client-yearly Then they can use different management classes with different retention values. On 6/26/08, Herrmann, Boris <[EMAIL PROTECTED]> wrote: > > Hello all > I've a question regarding db2 backups and different retention periods. > Until now we've backed up db2 via api interface to tsm and delete > backups older than 14 days (via db2adutl delete backup older than 14 > days). > > But the new request is: > -make daily db2 backups and hold them for 2 weeks (the same request > until today) > in addtion > -monthly backups (one backup per month - I think on the last day of a > month) should be hold for 12 month > -yearly backups should be hold for 10 years > > But how can I do this with tsm and db2adutl. > > with kind regards, > Boris >
