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.
The DB2_CLUSTER_HOST_STATE administrative view returns the hosts that are part of a DB2 pureScale instance. You can obtain a list of unique hosts plus their associated state information for the instance.
The schema is SYSIBMADM.
Refer to the Information returned for DB2_CLUSTER_HOST_STATE administrative view and DB2_GET_CLUSTER_HOST_STATE table for a complete list of information that can be returned.
SELECT * FROM SYSIBMADM.DB2_CLUSTER_HOST_STATE
HOSTNAME STATE INSTANCE_STOPPED ALERT
-------- ------------------------------- ---------------- --------
so1 ACTIVE NO NO
so2 ACTIVE NO NO
so3 ACTIVE NO NO
so4 ACTIVE NO NO
so5 ACTIVE NO NO
so6 ACTIVE NO NO
6 record(s) selected.
The DB2_GET_CLUSTER_HOST_STATE table function returns the same information as the DB2_CLUSTER_HOST_STATE administrative view, but allows you to specify a host name.
Refer to the Information returned for DB2_CLUSTER_HOST_STATE administrative view and DB2_GET_CLUSTER_HOST_STATE table for a complete list of information that can be returned.
None
SELECT * FROM TABLE(DB2_GET_CLUSTER_HOST_STATE('so3')) as T
HOSTNAME STATE INSTANCE_STOPPED ALERT
-------- ------------------------------- ---------------- --------
so3 ACTIVE NO NO
1 record(s) selected.
Column name | Data type | Description |
---|---|---|
HOSTNAME | VARCHAR(255) | hostname - Host name monitor element |
STATE | VARCHAR(32) | The hosts state information:
|
INSTANCE_STOPPED | VARCHAR(8) | Whether the instance is stopped or not on the hosts:
|
ALERT | VARCHAR(8) | Information about alerts on the hosts:
|