ADSM-L

Re: DB2 Different retention policies for different backups.

2003-05-02 07:17:46
Subject: Re: DB2 Different retention policies for different backups.
From: Manuel J Morais <manuel.j.morais AT PT.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 2 May 2003 12:16:11 +0100
>From our IBM support:

1) Each object can have only ONE policy active
     If you change thst policy, at next backup it will take effect to the
objects beeing backed and for all previous versions.

2) Work arround
     Define your client with several aliases, based in your retension
needs.
     For each alias you can define a specific policy.
     For instance, hostname myserver_weekly will run weekly backups, and
myserver_daily will run daily backups.
     As far as TSM knows they are different servers.
     To change from one to another you just need to change the variables
DSM_DIR and DSM_CONFIG.
     Problem: this will increase the number of licenses !!


Cumprimentos / Saludos / Saluti / Best Regards,

Manuel Morais
------------------------------------------------------------------------
Sistemas Abertos / Midrange Systems
Tel:  +351 214236365
Fax: +351 214236917
E-mail: manuel.j.morais AT pt.ibm DOT com
------------------------------------------------------------------------
DCSI --- IBM Global Services
Urbanização Taguspark, lote 35, T1P1
2784-549 Porto Salvo
------------------------------------------------------------------------


                                                                                
                                                       
                      "Tudor,Troy,VEVEY                                         
                                                       
                      ,GL-IS/IT"               To:       ADSM-L AT VM.MARIST 
DOT EDU                                                          
                      <Troy.Tudor@NESTL        cc:                              
                                                       
                      E.COM>                   Subject:  DB2 Different 
retention policies for different backups.                       
                      Sent by: "ADSM:                                           
                                                       
                      Dist Stor                                                 
                                                       
                      Manager"                                                  
                                                       
                      <[email protected]                                         
                                                       
                      .EDU>                                                     
                                                       
                                                                                
                                                       
                                                                                
                                                       
                      02/05/2003 11:44                                          
                                                       
                      Please respond to                                         
                                                       
                      "ADSM: Dist Stor                                          
                                                       
                      Manager"                                                  
                                                       
                                                                                
                                                       
                                                                                
                                                       



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>