How to check which Db2 Big SQL head node is the 'Current Primary Head Node'

When high availability is enabled for Db2® Big SQL, there are two Db2 Big SQL head nodes: the primary head node, and the standby secondary head node.

Procedure

To determine the current role of each head node, query the database configuration file from each node, as shown in the following example:

[bigsql@headnode1 ~]$ db2 get db cfg for bigsql | grep 'HADR database role'
 HADR database role                                      = PRIMARY

[bigsql@headnode2 ~]$ db2 get db cfg for bigsql | grep 'HADR database role'
 HADR database role                                      = STANDBY