Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004
    Posts
    67

    Unanswered: HADR: SQL1770N with reason code 9

    DB2 WSE 9.7.6 on Windows Server 2012

    This is a test environment with ASYNC mode.

    We are testing what happens if the primary server is disconnected from network and how to get the standby server to take over the primary role.
    It works well if there isn't database activity which occurs seldom.

    If there is database activity and we issue the command
    Code:
    db2 takeover hadr on db db_name by force
    error message SQL1770N with reason code 3 appears.

    Then we write
    Code:
    db2 takeover hadr on db db_name by force peer window only
    and receive error message SQL1770N with reason code 9.

    What is the best solution?

  2. #2
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    110
    Provided Answers: 13
    Hi,

    Peer window is not applicable to async mode.
    http://www.ibm.com/support/knowledge.../r0011553.html

    Rc 3 looks strange. Do you really get rc 3 on takeover by force?
    http://www.ibm.com/support/knowledge...sql01770n.html
    If yes, did you try to allow the standby to reach the end of backup point in time before running the takeover command?
    What's the state of the standby when you get rc 3?
    Regards,
    Mark.

  3. #3
    Join Date
    Nov 2004
    Posts
    67
    Error message SQL1770N with reason code 9 appeared only once or twice. Later tests worked fine without this kind of messages.

Posting Permissions

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