1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This message will disappear after you have made at least 12 posts. Thank you for your cooperation.

How to? Two TSM nodes for one instance

Discussion in 'DB2' started by umur, Mar 16, 2010.

  1. umur

    umur New Member

    Joined:
    Sep 17, 2007
    Messages:
    334
    Likes Received:
    3
    Occupation:
    Backup and Recovery Team Leader
    Location:
    Istanbul
    Hello,

    I have a db2 instance on an AIX server. This instance is the only one on that server and it is backed up 6 days online and Saturdays offline. I am supposed to retain Saturday's offline backup for 52 weeks.

    The offline backup is a db2 offline backup, initiated with "db2 backup db use tsm" command. An offline file backup with db2stop and dsmc incremental is not the direction we want to go.

    At the moment I am not using passwordaccess generate to reach TSM, but values on db2 configuration, such as TSM_MGMTCLASS, TSM_NODENAME, TSM_OWNER, TSM_PASSWORD.

    The question is how do I set up TSM so that I retain daily backups 30 days and weekly backups 52 weeks?

    Using:
    db2 v8
    tsm v5.5.4.1 Server
    tsm v5.5.2.2 Client

    Thanks!
     
  2.  
  3. madferret2277

    madferret2277 New Member

    Joined:
    Oct 1, 2008
    Messages:
    28
    Likes Received:
    3
    It has been a while since I've done this so it may not be exactly correct, but should lead you down the right path.

    Create a node_name on the TSM Server for the "Weekly" backups (ie db2node_weekly. Then, create a 2nd dsm.opt file that matches this server_name as well as a stanza in the dsm.sys that is configured to match. You can then setup DSMI env variables via either script or profile that references this 2nd dsm.opt file, which will then reference the weekly stanza in the dsm.sys

    You should be able then invoke this profile and run a db2 backup to against this weekly node name.
     
    umur likes this.
  4. umur

    umur New Member

    Joined:
    Sep 17, 2007
    Messages:
    334
    Likes Received:
    3
    Occupation:
    Backup and Recovery Team Leader
    Location:
    Istanbul
    Ok, so I should make a script that says

    export DSMI_DIR=/usr/tivoli....
    export DSMI_CONFIG=/usr/tivoli/.../dsm_weekly.opt
    export DSMI_LOG=/usr/tivoli/.../dsmerror_weekly.log
    db2 backup db dbname use tsm

    But don't I need a db2 stop start in order to make those environment variables recognized by db2?
     
: db2, tsm

Share This Page