Results 1 to 3 of 3
  1. #1
    Member umur's Avatar
    Join Date
    Sep 2007
    Location
    Istanbul
    Posts
    332
    Thanks
    0
    Thanked 1 Time in 1 Post

    Default How to? Two TSM nodes for one instance

    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. #2
    Member
    Join Date
    Oct 2008
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    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.

  3. #3
    Member umur's Avatar
    Join Date
    Sep 2007
    Location
    Istanbul
    Posts
    332
    Thanks
    0
    Thanked 1 Time in 1 Post

    Default

    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?

Similar Threads

  1. Shutting down a TSM-Instance
    By adsmsuser in forum TSM Server
    Replies: 2
    Last Post: 03-15-2010, 05:28 AM
  2. Second instance db tsm
    By diegoach81 in forum TSM Server
    Replies: 2
    Last Post: 11-03-2008, 05:24 PM
  3. Replies: 1
    Last Post: 11-10-2007, 01:08 AM
  4. Create 2 nd TSM instance to backup 1 st instance
    By kabousv in forum TSM Server
    Replies: 2
    Last Post: 02-09-2007, 06:10 AM
  5. Secondary TSM instance
    By ja954 in forum TSM Server
    Replies: 1
    Last Post: 06-28-2005, 11:09 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •