Topic
  • 10 replies
  • Latest Post - ‏2012-12-17T05:05:23Z by Taml
SystemAdmin
SystemAdmin
17917 Posts

Pinned topic DB2 9.7 HADR Problem

‏2012-12-14T12:00:09Z |
I tried to make hadr with DB2 9.7 and latest fixpack. Everyting seems to be ok, but when I press TAKEOVER button it shows error SQL1770N Takeover HADR cannot complete. Reason code = "4" Does anybody know how to solve this problem?
Updated on 2012-12-17T05:05:23Z at 2012-12-17T05:05:23Z by Taml
  • mwandishi
    mwandishi
    47 Posts

    Re: DB2 9.7 HADR Problem

    ‏2012-12-14T12:11:51Z  
    Hi,

    Have you looked at the help for the error?

    The explanation corresponding to the reason code is:
    4

    The command was issued against a standard or HADR primary
    database.

    User response:
    4

    This command is not supported on a standard or HADR primary
    database. Issue the command on an HADR standby database only.

    You need to run takeover on the sby

    Regards,
    Stephen
  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: DB2 9.7 HADR Problem

    ‏2012-12-14T13:05:11Z  
    • mwandishi
    • ‏2012-12-14T12:11:51Z
    Hi,

    Have you looked at the help for the error?

    The explanation corresponding to the reason code is:
    4

    The command was issued against a standard or HADR primary
    database.

    User response:
    4

    This command is not supported on a standard or HADR primary
    database. Issue the command on an HADR standby database only.

    You need to run takeover on the sby

    Regards,
    Stephen
    But if I try to connect to standby it show me error that it can't be connected to database in hadr state.
  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: DB2 9.7 HADR Problem

    ‏2012-12-14T13:11:24Z  
    But if I try to connect to standby it show me error that it can't be connected to database in hadr state.
    When I try connect to standby database it shows this error SQL 1776N The command is not supported on an HADR standby database Reason code = 1
  • mwandishi
    mwandishi
    47 Posts

    Re: DB2 9.7 HADR Problem

    ‏2012-12-14T13:19:56Z  
    When I try connect to standby database it shows this error SQL 1776N The command is not supported on an HADR standby database Reason code = 1
    Hi,

    Yes that is also correct, unless you are using ROS ( Read On Sby ). Just run this in the sby side: db2 takeover hadr on db xxx
    Where xxx is the db name. You don't need to make an explicit connection prior to running takeover

    Best regards,
    Stephen
  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: DB2 9.7 HADR Problem

    ‏2012-12-14T14:08:49Z  
    • mwandishi
    • ‏2012-12-14T13:19:56Z
    Hi,

    Yes that is also correct, unless you are using ROS ( Read On Sby ). Just run this in the sby side: db2 takeover hadr on db xxx
    Where xxx is the db name. You don't need to make an explicit connection prior to running takeover

    Best regards,
    Stephen
    Thank you! I tried to use controle center, not command line.
  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: DB2 9.7 HADR Problem

    ‏2012-12-14T14:09:13Z  
    use command line instead of controle centre
  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: DB2 9.7 HADR Problem

    ‏2012-12-14T14:09:22Z  
    use command line instead of control centre
  • mwandishi
    mwandishi
    47 Posts

    Re: DB2 9.7 HADR Problem

    ‏2012-12-14T14:15:55Z  
    use command line instead of control centre
    Hi,

    So the takeover worked, is that correct?

    Best regards,
    Stephen
  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: DB2 9.7 HADR Problem

    ‏2012-12-14T18:42:53Z  
    • mwandishi
    • ‏2012-12-14T14:15:55Z
    Hi,

    So the takeover worked, is that correct?

    Best regards,
    Stephen
    Yes)
  • Taml
    Taml
    5 Posts

    Re: DB2 9.7 HADR Problem

    ‏2012-12-17T05:05:23Z  
    Yes)
    You may also want to check this latest video on HADR to understand the concept & setup.

    http://youtu.be/P4JCd2a4uWk

    Thanks & Regards
    Tamil