Returns health indicator history information for containers from a health snapshot of a database.
EXECUTE privilege on the HEALTH_CONT_HI_HIS table function.
SELECT * FROM TABLE(HEALTH_CONT_HI_HIS('',-1)) AS T
SNAPSHOT_TIMESTAMP CONTAINER_NAME ...
-------------------------- ----------------------------------------...- ...
2006-02-13-12.30.41.915646 D:\DB2\NODE0000\SAMPLE\T0000000\C0000000.CAT ...
2006-02-13-12.30.41.915646 D:\DB2\NODE0000\SAMPLE\T0000000\C0000000.CAT ...
2006-02-13-12.30.41.915646 D:\DB2\NODE0000\SAMPLE\T0000003\C0000000.LRG ...
2006-02-13-12.30.41.915646 D:\DB2\NODE0000\SAMPLE\T0000003\C0000000.LRG ...
2006-02-13-12.30.41.915646 D:\DB2\NODE0000\SAMPLE\T0000004\C0000000.UTM ...
2006-02-13-12.30.41.915646 D:\DB2\NODE0000\SAMPLE\T0000004\C0000000.UTM ...
2006-02-13-12.30.41.915646 D:\DB2\NODE0000\SAMPLE\T0000001\C0000000.TMP ...
2006-02-13-12.30.41.915646 D:\DB2\NODE0000\SAMPLE\T0000001\C0000000.TMP ...
2006-02-13-12.30.41.915646 D:\DB2\NODE0000\SAMPLE\T0000002\C0000000.LRG ...
2006-02-13-12.30.41.915646 D:\DB2\NODE0000\SAMPLE\T0000002\C0000000.LRG ...
10 record(s) selected.
... NODE_NUMBER HI_ID HI_TIMESTAMP HI_VALUE HI_ALERT_STATE ...
... ----------- -----...- -------------------------- -------- -------------- ...
... - 3001 2006-02-13-12.16.25.911000 1 1 ...
... - 3001 2006-02-13-12.06.26.168000 1 1 ...
... - 3001 2006-02-13-12.16.25.911000 1 1 ...
... - 3001 2006-02-13-12.06.26.168000 1 1 ...
... - 3001 2006-02-13-12.16.25.911000 1 1 ...
... - 3001 2006-02-13-12.06.26.168000 1 1 ...
... - 3001 2006-02-13-12.16.25.911000 1 1 ...
... - 3001 2006-02-13-12.06.26.168000 1 1 ...
... - 3001 2006-02-13-12.16.25.911000 1 1 ...
... - 3001 2006-02-13-12.06.26.168000 1 1 ...
... HI_ALERT_STATE_DETAIL HI_FORMULA HI_ADDITIONAL_INFO
... --------------------- -----------...- ------------------
... Normal 1 -
... Normal 1 -
... Normal 1 -
... Normal 1 -
... Normal 1 -
... Normal 1 -
... Normal 1 -
... Normal 1 -
... Normal 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_TIMESTAMP | TIMESTAMP | The date and time that the alert was generated. |
HI_VALUE | SMALLINT | The value of the health indicator. |
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. |