Re: Database backup retentions question

Beware there are several other considerations to be made...
1.  If using copy pools, and/or offsite storage, you will want to ensure
your re-use delay matches the db retention (else you may have one without
the other, which could make the whole of DR recovery impossible);

2.  DRM has several parameters;  if using DRM, it (MOVE DRM) does the
expiration of db backup tapes -- and RPfiles retention becomes an added
retention parm, with this feature.

Typically, you'd want to keep DB backups long enough to get thru a
long-weekend (4 to 14 seems to be the range most folks settle on);  hence,
you'd want to keep all the other data/media that the oldest DB backup
references -- so they still work!


Don France
Technical Architect -- Tivoli Certified Consultant
Tivoli Storage Manager, WinNT/2K, AIX/Unix, OS/390
San Jose, Ca
(408) 257-3037
mailto:don_france AT att DOT net

Professional Association of Contract Employees
(P.A.C.E. -- www.pacepros.com)



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Tony Morgan
Sent: Friday, August 16, 2002 8:21 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Database backup retentions question


Mark,

The backups are normally deleted by a scheduled task.  eg.

Administrative command schedules : DELETEDBBACKUP

        Schedule Name DELETEDBBACKUP
        Description Delete old database backups
        Command delete volhist type=dbb todate=today-3
        Priority 5
        Start date 2000-12-14
        Start time 15:00:00
        Duration 1
        Duration units HOURS
        Period 1
        Period units DAYS
        Day of Week ANY
        Expiration -
        Active? YES
        Last Update Date/Time 2001-05-29 09:24:28.000000

Type "help delete volhist" for further details.

Rgds
Tony

-----Original Message-----
From: Mark Bertrand [mailto:Mark.Bertrand AT USUNWIRED DOT COM]
Sent: 16 August 2002 15:48
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Database backup retentions question


We are backing up our database with the following command setup in an admin
script.
backup db devclass=ltoclass type=full
Is there a setting that tells how many copies of the database to keep?

My goal is to free or reclaim some tape volumes.

============================================================

This e-mail and any files transmitted with it, are confidential and
intended solely for the use of the addressee. The content of this
e-mail may have been changed without the consent of the originator.
The information supplied must be viewed in this context. If you have
received this e-mail in error please notify our Helpdesk by
telephone on +44 (0) 20-7444-8444. Any use, dissemination,
forwarding, printing, or copying of this e-mail or its attachments is
strictly prohibited.