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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Wanda Prather
Sent: Thursday, June 26, 2008 10:45 AM
To: ADSM-L AT VM.MARIST DOT EDU
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 <Boris.Herrmann AT arag DOT de> 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
>