Db2 pureScale instance information routines and views

In a Db2 pureScale environment, certain routines provide information about the state of the Db2 pureScale instance and its members.

DB_MEMBERS table function
The DB_MEMBERS table function returns basic member information about a Db2 pureScale instance.
DB2_CLUSTER_HOST_STATE administrative view and DB2_GET_CLUSTER_HOST_STATE table function - get information about hosts
The DB2_CLUSTER_HOST_STATE administrative view and DB2_GET_CLUSTER_HOST_STATE table function retrieve information about the hosts that are part of a Db2 pureScale instance.
DB2_INSTANCE_ALERTS view - get information about alerts
The DB2_INSTANCE_ALERTS administrative view provides information about alerts in the Db2 pureScale instance.
DB2_MEMBER and DB2_CF administrative views and DB2_GET_INSTANCE_INFO table function
The DB2_MEMBER and DB2_CF administrative views and DB2_GET_INSTANCE_INFO table function return information about database members of single and multi-partitioned instances and the members and CFs of a Db2 pureScale instance, including state information where applicable.

Parent topic: Supported built-in SQL routines and views