ADSM-L

DB2 Different retention policies for different backups.

2003-05-02 06:45:24
Subject: DB2 Different retention policies for different backups.
From: "Tudor,Troy,VEVEY,GL-IS/IT" <Troy.Tudor AT NESTLE DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 2 May 2003 12:44:52 +0200
Hi TMSers

We want to implement a backup policy like:

DB2 weekly online backup retained 8 weeks
DB2 daily online backup retained 1 week
All database logs retained 8 weeks

This of course allows us to perform a point in time recovery to any time in
the last eight weeks, however recoveries more than one week old will require
more effort.

We would assume use different management classes to separate out weekly from
daily backups.
However tool db2adutl does not allow specification of different management
classes when marking backups inactive.

Any insight on how different sites manage such a policy would be welcome

Thanks
Troy Tudor

<Prev in Thread] Current Thread [Next in Thread>