Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2010
    Posts
    6

    Question Unanswered: Is there any way to switch Active DB2 nodein DB2 HA

    Hi All,

    I successfully configured DB2 HA between 2 DB2 nodes using db2haicu feature.
    Version of DB2 used is 9.7
    Failover policy used is Active/Passive.
    I defined for ex: node1 as active and node2 as passive node.
    Can anyone please tell if there is any way to switch the Active node ?
    So that, active node is node2 and passive node is node2.

    Please help me .. Is there any command for switching active node ?

  2. #2
    Join Date
    Jan 2010
    Posts
    335
    Hi,

    just "db2 takeover hadr on db <database name> " on the Standby node.

    TAKEOVER HADR

  3. #3
    Join Date
    Mar 2010
    Posts
    6

    Red face

    Quote Originally Posted by nvk@vhv View Post
    Hi,

    just "db2 takeover hadr on db <database name> " on the Standby node.

    TAKEOVER HADR
    Thanks for the reply.

    But I have not configured HADR.
    I have configured HA only that too using db2haicu command utility.

    Currently when I try executing the command on passive node,
    node2# db2 takeover hadr on db TAKEOVERDB
    (here, TAKEOVER DB is a database locally available on node2 and not configred as HA DB)

    I get the following output:
    SQL1770N Takeover HADR cannot complete. Reason code = "4".

    Any input please ?

  4. #4
    Join Date
    Jan 2010
    Posts
    335
    To be honest the configuration sounds weird.
    What happens if the primary node fails? Or what should happen?

    What do you want achieve with this set up?

  5. #5
    Join Date
    Mar 2010
    Location
    uk
    Posts
    4

    Wink DB2 HADR Process

    well you have to actually login to the original primary node1 (now the standby), and connect to the instance, THEN do the HADR take-over from there.

Posting Permissions

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