The HEALTH_CONT_HI table function returns health indicator information for table space containers from a health snapshot of table spaces in a database.
EXECUTE privilege on the HEALTH_CONT_HI table function.
SELECT * FROM TABLE(HEALTH_CONT_HI('',-1)) AS T
SNAPSHOT_TIMESTAMP CONTAINER_NAME ...
-------------------------- -------------------------------------------...- ...
2006-02-13-12.30.40.759542 D:\DB2\NODE0000\SAMPLE\T0000000\C0000000.CAT ...
2006-02-13-12.30.40.759542 D:\DB2\NODE0000\SAMPLE\T0000003\C0000000.LRG ...
2006-02-13-12.30.40.759542 D:\DB2\NODE0000\SAMPLE\T0000004\C0000000.UTM ...
2006-02-13-12.30.40.759542 D:\DB2\NODE0000\SAMPLE\T0000001\C0000000.TMP ...
2006-02-13-12.30.40.759542 D:\DB2\NODE0000\SAMPLE\T0000002\C0000000.LRG ...
5 record(s) selected.
... NODE_NUMBER HI_ID HI_VALUE HI_TIMESTAMP ...
... ----------- -------------------- -------- -------------------------- ...
... - 3001 1 2006-02-13-12.26.26.158000 ...
... - 3001 1 2006-02-13-12.26.26.158000 ...
... - 3001 1 2006-02-13-12.26.26.158000 ...
... - 3001 1 2006-02-13-12.26.26.158000 ...
... - 3001 1 2006-02-13-12.26.26.158000 ...
... HI_ALERT_STATE HI_ALERT_STATE_DETAIL HI_FORMULA HI_ADDITIONAL_INFO
... -------------------- --------------------- -----------...- ------------------
... 1 Normal 1 -
... 1 Normal 1 -
... 1 Normal 1 -
... 1 Normal 1 -
... 1 Normal 1 -
Column name | Data type | Description or corresponding monitor element |
---|---|---|
SNAPSHOT_TIMESTAMP | TIMESTAMP | snapshot_timestamp - Snapshot timestamp |
CONTAINER_NAME | VARCHAR(256) | container_name - Container name |
NODE_NUMBER | INTEGER | node_number - Node number |
HI_ID | BIGINT | A number that uniquely identifies the health indicator in the snapshot data stream. |
HI_VALUE | SMALLINT | The value of the health indicator. |
HI_TIMESTAMP | TIMESTAMP | The date and time that the alert was generated. |
HI_ALERT_STATE | BIGINT | The severity of the alert. |
HI_ALERT_STATE_DETAIL | VARCHAR(20) | The text description of the HI_ALERT_STATE column. |
HI_FORMULA | VARCHAR(2048) | The formula used to calculate the health indicator. |
HI_ADDITIONAL_INFO | VARCHAR(4096) | Additional information about the health indicator. |