Going Beyond 2 Servers – HADR as a High Availability/Disaster Recovery option.

You may also like...

5 Responses

  1. Abhik Roy says:

    Excellent content!

  2. Sumalatha Raj says:

    Hi ,

    This excellent. However, I have question.. There is already a 3 Node HADR Setup Primary, Principal Standby – configured with TSA. Aux 1 standby configured for ROS. This setup is already up and working fine. Now that there is a requirement of DR Setup, I have configured the new standby instance with the latest online back up of the Primary server, and updated all the configuration parameters. But the HADR handshake fails on the new standby.

    2017-12-19-18.20.50.122786+330 I573420E656 LEVEL: Error
    PID : 4397 TID : 140184830076672 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : STERCLD
    HOSTNAME:
    EDUID : 1243 EDUNAME: db2hadrs.0.0 (STERCLD) 0
    FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrHandleHsErrors, probe:30540
    MESSAGE : ZRC=0x87800140=-2021654208=HDR_ZRC_CONFIGURATION_ERROR
    “One or both databases of the HADR pair is configured incorrectly”
    DATA #1 :
    HADR handshake with Titan-OMS-PreProd-DB2.aws-tx37.com:55001 (10.120.212.172:55001) failed.

    2017-12-19-18.20.50.123073+330 I574077E539 LEVEL: Error
    PID : 4397 TID : 140184830076672 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : STERCLD
    HOSTNAME: titan-dr-oms-db2.aws-tx37.com
    EDUID : 1243 EDUNAME: db2hadrs.0.0 (STERCLD) 0
    FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduAcceptEvent, probe:20285
    MESSAGE : ZRC=0x87800140=-2021654208=HDR_ZRC_CONFIGURATION_ERROR
    “One or both databases of the HADR pair is configured incorrectly”

    No errors observed on the Primary DB instance.

    • Ember Crooks says:

      Have you gone over your settings with a fine tooth comb? have you ensured the changes to HADR_TARGET_LIST have taken effect on all servers?

      • Sumalatha Raj says:

        Hi ,
        I was able to figure out the issue. I would need to restart Hadr on the primary instance for the hard_target_list to be effective.
        Thanks a lot.
        With Regards,
        Sumalatha Raj

Leave a Reply

Your email address will not be published. Required fields are marked *