Results 1 to 5 of 5
  1. #1
    Join Date
    May 2016
    Posts
    9

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

    I am getting error "SQL1770N Takeover HADR cannot complete. Reason code = "10"." on secondary server ..
    We don't have any cluster configuration at our location how ever the cluster manager shows as TSA on secondary and none on the primary..
    Can you guys please help me to resolve this....

    --secondary server
    --db2 v10.5.0.4

    $ db2 takeover hadr on database samplesecondary by force
    SQL1770N Takeover HADR cannot complete. Reason code = "10".
    $ db2 get dbm cfg | grep -i cluster
    Cluster manager = TSA

    db2diag.log has the following info :

    FUNCTION: DB2 UDB, high avail services, sqlhaLockHADRResource, probe:180
    RETCODE : ECF=0x9000052E=-1879046866=ECF_SQLHA_FAILED
    SQLHA API call error
    FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrTakeoverHdrRouteIn, probe:55610
    RETCODE : ZRC=0x827300AA=-2106392406=HA_ZRC_FAILED "SQLHA API call error"

    --primary server
    $ db2 get dbm cfg | grep -i cluster
    Cluster manager =


    Thanks a lot

  2. Best Answer
    Posted by mark.b

    "Sorry: db2instanceinfo.reg instead of db2ha.sys in 10.5"


  3. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Try to run on standby the following command if you really don't have any TSA cluster:
    db2haicu -delete
    Rename the file ~${DB2INSTANCE}/sqllib/cfg/db2ha.sys if you still have it and restart the instance.
    "Cluster manager" parameter should be clear after this.
    Regards,
    Mark.

  4. #3
    Join Date
    May 2016
    Posts
    9
    Quote Originally Posted by mark.b View Post
    Try to run on standby the following command if you really don't have any TSA cluster:
    db2haicu -delete
    Rename the file ~${DB2INSTANCE}/sqllib/cfg/db2ha.sys if you still have it and restart the instance.
    "Cluster manager" parameter should be clear after this.
    Thanks for the reply ..

    I checked and i don't have db2ha.sys file either on secondary nor primary..

  5. #4
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Sorry: db2instanceinfo.reg instead of db2ha.sys in 10.5
    Regards,
    Mark.

  6. #5
    Join Date
    May 2016
    Posts
    9

    Thumbs up

    Thanks Mark..

    That worked like a charm

Tags for this Thread

Posting Permissions

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