Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2011
    Posts
    5

    Unanswered: HADR is in Disconnected peer state

    hi all
    I am new in db2.

    The hadr used Nearsync..

    we were applying fix pack on hadr based databases. first we had to apply fix pack on the standby database(node) and make standby node as a primary node by issuing takeover command. then after that we applied fix pack on primary node which is now standby every thing went through and we were successful in installing fix pack on both the node.

    but the problem was hadr was in disconnected peer state.

    my question is how can we bring hadr to peer state from disconnected peer state?
    what are the commands we have to issue

    i also know we should check db2diag.log and find out the errors why hadr could not go in peer state.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    the only I could recommend - stop hadr on bot nodes and start hard again /standby/primary
    and takeover where needed..
    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

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

Posting Permissions

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