The HEALTH_DBM_INFO function returns information from a health snapshot of the DB2® database manager.
If the null value is specified, -1 is set implicitly.
EXECUTE privilege on the HEALTH_DBM_INFO table function.
SELECT * FROM TABLE(HEALTH_DBM_INFO(-1)) AS T
SNAPSHOT_TIMESTAMP SERVER_INSTANCE_NAME ROLLED_UP_ALERT_STATE ...
-------------------------- --------------------...--- --------------------- ...
2006-02-13-12.30.19.663924 DB2 4 ...
1 record(s) selected.
... ROLLED_UP_ALERT_STATE_DETAIL DB2START_TIME ...
... ---------------------------- -------------------------- ...
... Alarm 2006-02-09-10.56.18.126182 ...
... LAST_RESET NUM_NODES_IN_DB2_INSTANCE
... -----------...--- -------------------------
... - 1
Column name | Data type | Description or corresponding monitor element |
---|---|---|
SNAPSHOT_TIMESTAMP | TIMESTAMP | snapshot_timestamp - Snapshot timestamp |
SERVER_INSTANCE_NAME | VARCHAR(128) | server_instance_name - Server instance name |
ROLLED_UP_ALERT_STATE | BIGINT | The most severe alert state captured by this snapshot. |
ROLLED_UP_ALERT_ |
VARCHAR(20) | The text description of the ROLLED_UP_ALERT_STATE column. |
DB2START_TIME | TIMESTAMP | db2start_time - Start database manager timestamp |
LAST_RESET | TIMESTAMP | last_reset - Last reset timestamp |
NUM_NODES_IN_DB2_ |
INTEGER | num_nodes_in_db2_instance - Number of nodes in database partition |