Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Thanked 0 Times in 0 Posts

    Default Automatic Backup two Intances of DB 9.2


    I need Help of my problem:

    I Have a two instances of db2 9.5 on same windows machine, with diferente instance logon
    In the System variable have a DSMI_CONFIG, DSMI_DIR and DSMI_LOG define for one instances.

    For baclup, have a defined two scripts, on for instance, two automatic service of windows start with instance user admin (db2bd0 and db2bq0)

    On the automatic backup the tso services is Ok, but the backup only save the principal instance of DB2 (db2bd0). The second instance never backuped with schedule.

    its possible two instances bacup on same machine ?
    if yes, qhat the procedures for sucess backup of separated instances ?

    Thns for attention.

    Luiz Carlos.

  2. #2
    Moderator moon-buddy's Avatar
    Join Date
    Aug 2005
    Somewhere in the US
    Thanked 234 Times in 229 Posts


    Yes, you can have two backup instances.

    All you need it to is create two TSM backup schedulers pointing to different OPT files.
    Last edited by moon-buddy; 09-26-2009 at 11:09 PM.

  3. #3
    Join Date
    May 2004
    Thanked 0 Times in 0 Posts

    Default Backup two DB instance

    Tanks for reply.

    I have two scheduler with two dsm.opt with same TSM nodename, but the backup DB ("db2 backup database BD0 use TSM") with user DB2BD0 starting service schedule in windows execute backup Ok (Database BD0 in instance DB2BD0), but the schedule started with user DB2BQ0 (Other instance) execute backup of BD0 database instead BQ0 database. The schedule is full functional, but the backup db2 command not Ok.
    The DB2 execute two backup of same instance, and not execute backup o f Other Instance.
    The DSMI_CONFIG is configured in the SYSTEM VARIABLE Windows.
    and only one occurency is permited. The DB2 Engine is part of SAP Instance.

    Any suggestion.....

Similar Threads

  1. automatic schedule
    By khn0664 in forum Backup / Archive Discussion
    Replies: 0
    Last Post: 04-16-2008, 02:50 AM
  2. Automatic Warning
    By phbs82 in forum TSM Server
    Replies: 4
    Last Post: 01-30-2008, 12:59 PM
  3. Automatic Backup Discrepancies
    By OKTSMGURU21 in forum Backup / Archive Discussion
    Replies: 2
    Last Post: 04-06-2006, 07:49 AM
  4. Can TSM automatic send email when backup job has finished ?
    By Pannikin in forum Backup / Archive Discussion
    Replies: 0
    Last Post: 09-30-2005, 05:55 AM
  5. Automatic Ejection
    By fbenhamou in forum Tape / Media Library
    Replies: 1
    Last Post: 03-27-2003, 07:15 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