Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2013
    Posts
    1

    Unanswered: after issuing "by force"cmd,Get confused about HADR

    hi!

    Imagine such a scenario:
    1.My hadr primary server is down and unrecoverable.
    2.I issue the "db2 takeover hadr on db sample by force" on the standby server. Now, the standby DB works correctly.
    3.I stop the DB on the standby server.

    here is the problem, when I try to start the DB again:

    [db2inst1@host03 ~]$ db2start
    01/20/2013 20:33:28 0 0 SQL1063N DB2START processing was successful.
    SQL1063N DB2START processing was successful.
    [db2inst1@host03 ~]$ db2 activate db sample
    DB20000I The ACTIVATE DATABASE command completed successfully.
    [db2inst1@host03 ~]$ db2 start hadr on db sample as primary
    SQL1767N Start HADR cannot complete. Reason code = "2". START HADR AS PRIMARY cannot be issued on an HADR standby database.
    [db2inst1@host03 ~]$ db2 start hadr on db sample as primary by force
    SQL1767N Start HADR cannot complete. Reason code = "2".
    [db2inst1@host03 ~]$ db2 takeover hadr on db sample by force
    SQL1770N Takeover HADR cannot complete. Reason code = "5". Activate the standby database, then issue the takeover command.
    [db2inst1@host03 ~]$ db2 activate db sample
    DB20000I The ACTIVATE DATABASE command completed successfully.
    [db2inst1@host03 ~]$ db2 takeover hadr on db sample by force
    SQL1770N Takeover HADR cannot complete. Reason code = "5".


    How can I get my DB back??

    thanks in advance!

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    conflict between start hadr and hadr status
    execute db2pd -db sample -hadr to check the status of db on both servers
    start hadr standby first than start hadr primary on correct server
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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