Results 1 to 13 of 13
  1. #1
    Join Date
    Jun 2011
    Location
    Toronto
    Posts
    13

    Answered: SQL1770N Takeover HADR cannot complete. Reason code = "5"

    I'm trying to rollback from DB2 10.5 FP 7 to DB2 10.5 FP3 in an automated HADR environment. Rolled back to FP3 on Standby first and now when I try to take over hadr, gives me the following error. Could someone please help ?

    SQL1770N Takeover HADR cannot complete. Reason code = "5"

    Regards,
    Vino

  2. Best Answer
    Posted by mark.b

    "I'm afraid, that yes, it's not possible to do it without downtime with HADR."


  3. #2
    Join Date
    May 2016
    Location
    Wellington
    Posts
    22
    Provided Answers: 1
    See the documentation for this SQL code.
    SQL1770N Reason 5 - The command was issued against an inactive standby database.

    Solution - Activate the standby database, then issue the takeover command.

  4. #3
    Join Date
    Jun 2011
    Location
    Toronto
    Posts
    13
    Sorry. I've forgotten to add more information.

    I've tried to activate the database and getting the error message. The ACTIVATE DATABASE output says the database has been activated, however when I try to issue TAKEOVER HADR, I'm getting the SQL1770N Reason Code : 5 error.

    As it is an automated HADR environment, is there something I'm missing ?

  5. #4
    Join Date
    May 2016
    Location
    Wellington
    Posts
    22
    Provided Answers: 1
    Is your HADR up and in Peer State?

  6. #5
    Join Date
    Jun 2011
    Location
    Toronto
    Posts
    13
    No. HADR is in Disconnected State

  7. #6
    Join Date
    May 2016
    Location
    Wellington
    Posts
    22
    Provided Answers: 1
    You cannot takeover HADR when its not in Peer State. Verify that the fix pack is applied and HADR is in peer state again. Check this link for help.

    https://www.ibm.com/support/knowledg.../t0056202.html

  8. #7
    Join Date
    Jun 2011
    Location
    Toronto
    Posts
    13
    The steps explained in the link you provided is what I've been following. For some weird reasons the standby server is throwing the error. Any insights would be much appreciated. Thank you

  9. #8
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Show us the db2diad.log entries appeared on both sides after the 'activate db' command.
    Regards,
    Mark.

  10. #9
    Join Date
    Jun 2011
    Location
    Toronto
    Posts
    13
    Hello Mark,

    Please find attached the diaglogs in two different files. One file consists of log entries captured during the fixpack application. The other file consists of entries captured after the fixpack and during the activate db. Thanks a lot for your help on this. Both the diaglogs were captured on the standby server. I'll attach one more diaglog entry file from the primary server shortly. In the interim if you could take a look at these files, it would be great.

    Update : Attached the log file from both the servers.

    Regards,
    Vino
    Attached Files Attached Files
    Last edited by vinonline; 07-05-16 at 11:47.

  11. #10
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Code:
    2016-07-05-09.16.35.755872-300 I213652425A497       LEVEL: Warning
    PID     : 18940074             TID : 9707           PROC : db2sysc 0
    INSTANCE: db2inst1             NODE : 000           DB   : DBONE
    HOSTNAME: server2
    EDUID   : 9707                 EDUNAME: db2hadrs.0.0 (DBONE) 0
    FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrGetTcpMessage, probe:37170
    DATA #1 : <preformatted>
    Warning: two systems are on different message versions. Local version: 4114, Remote version: 4115
    
    2016-07-05-09.16.35.756347-300 I213652923A493       LEVEL: Info
    PID     : 18940074             TID : 9707           PROC : db2sysc 0
    INSTANCE: db2inst1             NODE : 000           DB   : DBONE  
    HOSTNAME: server2
    EDUID   : 9707                 EDUNAME: db2hadrs.0.0 (DBONE) 0
    FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrHandleHsAck, probe:43900
    DATA #1 : <preformatted>
    Handshake HDR_MSG_HDRREJECT message is received from lcshrdbd3:db2inst1_HA_8 (10.33.113.131:50318)
    
    2016-07-05-09.16.35.756742-300 I213653417A611       LEVEL: Error
    PID     : 18940074             TID : 9707           PROC : db2sysc 0
    INSTANCE: db2inst1             NODE : 000           DB   : DBONE  
    HOSTNAME: server2
    EDUID   : 9707                 EDUNAME: db2hadrs.0.0 (DBONE) 0
    FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrHandleHsAck, probe:43901
    MESSAGE : ZRC=0x87800140=-2021654208=HDR_ZRC_CONFIGURATION_ERROR
              "One or both databases of the HADR pair is configured incorrectly"
    DATA #1 : <preformatted>
    HADR handshake with lcshrdbd3:db2inst1_HA_8 (10.33.113.131:50318) failed.
    
    ...
    
    2016-07-05-09.16.35.759135-300 I213656623A398       LEVEL: Info
    PID     : 18940074             TID : 9707           PROC : db2sysc 0
    INSTANCE: db2inst1             NODE : 000           DB   : DBONE  
    HOSTNAME: server2
    EDUID   : 9707                 EDUNAME: db2hadrs.0.0 (DBONE) 0
    FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEdu::hdrEduS, probe:21900
    MESSAGE : Standby Finished.
    Standby's FP level must be higher than primary's.
    If you want to downgrade, try to downgrade the primary first.
    But I'm not sure if this approach can help you...
    Regards,
    Mark.

  12. #11
    Join Date
    Jun 2011
    Location
    Toronto
    Posts
    13
    Thank you Mark. That makes sense. So does it mean it is not possible in a HADR environment to rollback to a previous version of fixpack without downtime ? Or do you have any idea how to perform fixpack downgrade in a HADR setup without any disruption ?

  13. #12
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    I'm afraid, that yes, it's not possible to do it without downtime with HADR.
    Regards,
    Mark.

  14. #13
    Join Date
    Jun 2011
    Location
    Toronto
    Posts
    13
    Thank you Mark and Abhivelu !!

Posting Permissions

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