Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2010

    Unanswered: Load on HADR System

    Hello there,

    I have a running HADR on DB2 Version 9.5 Fixpack 7.

    Now I got to know that HADR could get some problems in case of the clients send some to loads to the Primary System.

    We are using TSM for archiving our logs and Backups from Primary.

    The IBM Information Center reports about the VENDOROPT Option but I am not really sure how to use it. Is there anybody here who can support me with this?

    Thanks in advance.


  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    LOAD operations are not logged, therefore they cannot be propagated to the standby database, unless you specify COPY YES as an option. In that case you must ensure that the COPY YES location is accessible from both the primary and standby databases.

    More information can be found here: Database configuration for high availability disaster recovery (HADR) - IBM DB2 9.7 for Linux, UNIX, and Windows

Posting Permissions

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