Hi Joni, I think you should take advantage of the different types of DB backups that Tivoli is offering : Dbbackups and Dbsnapshots. You could use tape based devclass for dbbackups and disk based devclass for dbbsnapshots, thus using different retention values for each of them. Do not forget that you are able to define the retention delay for DB backups/snapshots while using the "del volhist" command, specifiying "todate=today-x" and "type=dbbackup" or "type=dbsnapshot". Use this in a script, that should be ran once a day !
In such a case do not forget to set "DB Backup Series Expiration Days" to something longer that the maximal retention of the dbbackups you would like to keep, or it will take precedence over your "del volhist" command ... Hope this helped ... Arnaud ************************************************************************ ****** Panalpina Management Ltd., Basle, Switzerland, CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01 Direct: +41 (61) 226 19 78 e-mail: [EMAIL PROTECTED] ************************************************************************ ****** -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: Thursday, 25 January, 2007 14:18 To: ADSM-L@VM.MARIST.EDU Subject: Help! Need Advice on DBB Hello Everyone, I currently have a TSM server 5.2.7.1 on AIX 5.3 and I use DRM. I have the following set up and I take a full dbb once a day which goes to LTO2 tape. Recovery Plan Prefix: /t01/dr/recoveryplans/ Plan Instructions Prefix: /t01/dr/instructions/ Replacement Volume Postfix: @ Primary Storage Pools: AIX LINUX NETWARE NOTES ORACLE ORACLE-LOGS SOLARIS WINDOWS TAPE_AIX TAPE_LINUX TAPE_NETWARE TAPE_NOTES TAPE_ORACLE TAPE_ORACLE-LOGS TAPE_SOLARIS TAPE_WINDOWS Copy Storage Pools: COPY* Not Mountable Location Name: NOTMOUNTABLE Courier Name: Vital Records Inc. Vault Site Name: Vital Records Inc. DB Backup Series Expiration Days: 8 Day(s) Recovery Plan File Expiration Days: 8 Day(s) Check Label?: Yes Process FILE Device Type?: Yes Command File Name: /t01/dr/exec.cmds Since I have the DB Backup Series Expiration Days set to 8 how is it possible that I can see 13 DBB in the volhistory? I would now like to run a second dbb that will go to disk which is then replicated to our disaster recovery site. And create a 2nd DRM plan after this dbb is run as well. My dilemma is that I'm not quite sure how to set up such an environment. To set up a dbb to go to disk I know that I'll need a device class of file which will point to the directory where I want the dbb to be created. How do I know how much space I will need? 01/24/07 10:29:42 ANR4550I Full database backup (process 7496) complete, 31252557 pages copied. (SESSION: 750659, PROCESS: 7496) 01/24/07 10:29:42 ANR0985I Process 7496 for DATABASE BACKUP running in the BACKGROUND completed with completion state SUCCESS at 10:29:42. (SESSION: 750659, PROCESS: 7496) Will I need 31252557 * 4096KB = 128010473472 KB = 128 GB? Also, how will it be possible for me to create both each day and use each for my DRM plan? And how will I continue to keep 8 tape dbb versions and only keep 1 disk dbb version? Is what I am trying to do impossible? Any advice/suggestions are appreciated! Thanks in advance! ******************************** Joni Moyer Highmark Storage Systems, Senior Systems Programmer Phone Number: (717)302-9966 Fax: (717) 302-9826 [EMAIL PROTECTED] ********************************