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

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
    ACCEPTED ANSWER

    Re: DB2 9.7 HADR Problem

    ‏2012-12-14T12:11:51Z  in response to SystemAdmin
    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
      ACCEPTED ANSWER

      Re: DB2 9.7 HADR Problem

      ‏2012-12-14T13:05:11Z  in response to mwandishi
      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
        ACCEPTED ANSWER

        Re: DB2 9.7 HADR Problem

        ‏2012-12-14T13:11:24Z  in response to SystemAdmin
        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
          ACCEPTED ANSWER

          Re: DB2 9.7 HADR Problem

          ‏2012-12-14T13:19:56Z  in response to SystemAdmin
          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
            ACCEPTED ANSWER

            Re: DB2 9.7 HADR Problem

            ‏2012-12-14T14:08:49Z  in response to mwandishi
            Thank you! I tried to use controle center, not command line.
  • SystemAdmin
    SystemAdmin
    17917 Posts
    ACCEPTED ANSWER

    Re: DB2 9.7 HADR Problem

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

    Re: DB2 9.7 HADR Problem

    ‏2012-12-14T14:09:22Z  in response to SystemAdmin
    use command line instead of control centre
    • mwandishi
      mwandishi
      47 Posts
      ACCEPTED ANSWER

      Re: DB2 9.7 HADR Problem

      ‏2012-12-14T14:15:55Z  in response to SystemAdmin
      Hi,

      So the takeover worked, is that correct?

      Best regards,
      Stephen
      • SystemAdmin
        SystemAdmin
        17917 Posts
        ACCEPTED ANSWER

        Re: DB2 9.7 HADR Problem

        ‏2012-12-14T18:42:53Z  in response to mwandishi
        Yes)
        • Taml
          Taml
          5 Posts
          ACCEPTED ANSWER

          Re: DB2 9.7 HADR Problem

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

          http://youtu.be/P4JCd2a4uWk

          Thanks & Regards
          Tamil