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 ?

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 ?

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?

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.