Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2012

    Question Unanswered: TSM COPY with HADR


    I've configured a DB2 HADR database and users are currently using the LOAD operation with COPY YES USE TSM options. The load is performed on the primary database, cross-node access via TSM is enabled but the standby database tables are going into no access mode due to the LOAD COPY files not being able to be accessed and applied to the standby database.

    I have used db2adutl command to grand node access and checked on the standby server to see if he can see the files backed up by the server. This was confirmed. Is there anything I am missing?

    There is only on TSM server in this case. Also, the main idea is to have DB2 perform the LOAD operation without any administration. Wondering if this is possible so I wouldn't have to download the database onto the standby server.

    Last edited by manawa; 01-27-14 at 22:00.

  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    there is a redbook describing these scenarios and grant/commands needed
    IBM Redbooks | Backing Up DB2 Using IBM Tivoli Storage Management
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

  3. #3
    Join Date
    Oct 2012
    No need. Its appears the dsm.opt file on the standby database server was missing. DB2 is now automatically applying loaded data on the standby database.


Posting Permissions

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