The HEALTH_CONT_INFO table function returns container information from a health snapshot of a database.
EXECUTE privilege on the HEALTH_CONT_INFO table function.
SELECT * FROM TABLE(HEALTH_CONT_INFO('',-1)) AS T
SNAPSHOT_TIMESTAMP CONTAINER_NAME ...
-------------------------- -----------------------------------------...- ...
2006-02-13-12.30.40.541209 D:\DB2\NODE0000\SAMPLE\T0000000\C0000000.CAT ...
2006-02-13-12.30.40.541209 D:\DB2\NODE0000\SAMPLE\T0000003\C0000000.LRG ...
2006-02-13-12.30.40.541209 D:\DB2\NODE0000\SAMPLE\T0000004\C0000000.UTM ...
2006-02-13-12.30.40.541209 D:\DB2\NODE0000\SAMPLE\T0000001\C0000000.TMP ...
2006-02-13-12.30.40.541209 D:\DB2\NODE0000\SAMPLE\T0000002\C0000000.LRG ...
5 record(s) selected.
... TABLESPACE_NAME NODE_NUMBER ...
... ---------------...- ----------- ...
... SYSCATSPACE - ...
... SYSTOOLSPACE - ...
... SYSTOOLSTMPSPACE - ...
... TEMPSPACE1 - ...
... USERSPACE1 - ...
... ROLLED_UP_ALERT_STATE ROLLED_UP_ALERT_STATE_DETAIL
... --------------------- ----------------------------
... 1 Normal
... 1 Normal
... 1 Normal
... 1 Normal
... 1 Normal
Column name | Data type | Description or corresponding monitor element |
---|---|---|
SNAPSHOT_TIMESTAMP | TIMESTAMP | snapshot_timestamp - Snapshot timestamp |
CONTAINER_NAME | VARCHAR(256) | container_name - Container name |
TABLESPACE_NAME | VARCHAR(128) | tablespace_name - Table space name |
NODE_NUMBER | INTEGER | node_number - Node number |
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. |