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:[EMAIL PROTECTED] Professional Association of Contract Employees (P.A.C.E. -- www.pacepros.com) -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Tony Morgan Sent: Friday, August 16, 2002 8:21 AM To: [EMAIL PROTECTED] 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:[EMAIL PROTECTED]] Sent: 16 August 2002 15:48 To: [EMAIL PROTECTED] 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.
