Returns collection health indicator history information from a health snapshot of a database.
If the null value is specified, -1 is set implicitly.
EXECUTE privilege on the HEALTH_DB_HIC_HIS table function.
SELECT * FROM TABLE(HEALTH_DB_HIC_HIS('',-1)) AS T
HI_HIS_ENTRY_NUM SNAPSHOT_TIMESTAMP HI_ID ...
---------------- -------------------------- -------------------- ...
1 2006-02-13-12.30.34.496720 1015 ...
2 2006-02-13-12.30.34.496720 1022 ...
3 2006-02-13-12.30.34.496720 1022 ...
4 2006-02-13-12.30.34.496720 1022 ...
5 2006-02-13-12.30.34.496720 1022 ...
6 2006-02-13-12.30.34.496720 1022 ...
7 2006-02-13-12.30.34.496720 1022 ...
8 2006-02-13-12.30.34.496720 1022 ...
9 2006-02-13-12.30.34.496720 1022 ...
10 2006-02-13-12.30.34.496720 1022 ...
10 record(s) selected.
... DB_NAME HI_OBJ_NAME HI_OBJ_STATE ...
... -------...- ----------------------------------...- ------------ ...
... SAMPLE "JESSICAE"."EMPLOYEE" 2 ...
... SAMPLE "SYSIBM"."SYSDATAPARTITIONEXPRESSION" 2 ...
... SAMPLE "SYSIBM"."SYSDATAPARTITIONEXPRESSION" 2 ...
... SAMPLE "SYSIBM"."SYSDATAPARTITIONEXPRESSION" 2 ...
... SAMPLE "SYSIBM"."SYSDATAPARTITIONEXPRESSION" 1 ...
... SAMPLE "SYSIBM"."SYSDATAPARTITIONEXPRESSION" 1 ...
... SAMPLE "SYSIBM"."SYSDATAPARTITIONEXPRESSION" 1 ...
... SAMPLE "SYSIBM"."SYSDATAPARTITIONEXPRESSION" 1 ...
... SAMPLE "SYSIBM"."SYSDATAPARTITIONEXPRESSION" 1 ...
... SAMPLE "SYSIBM"."SYSDATAPARTITIONEXPRESSION" 1 ...
... HI_OBJ_STATE_DETAIL HI_TIMESTAMP
... -------------------- --------------------------
... Attention 2006-02-10-09.04.57.000000
... Attention 2006-02-13-12.27.56.000000
... Attention 2006-02-13-12.26.27.000000
... Attention 2006-02-13-12.24.56.000000
... Normal 2006-02-13-12.23.28.000000
... Normal 2006-02-13-12.21.56.000000
... Normal 2006-02-13-12.20.26.000000
... Normal 2006-02-13-12.18.57.000000
... Normal 2006-02-13-12.17.27.000000
... Normal 2006-02-13-12.15.56.000000
Column name | Data type | Description or corresponding monitor element |
---|---|---|
HI_HIS_ENTRY_NUM | SMALLINT | A number that uniquely identifies the history entry. |
SNAPSHOT_TIMESTAMP | TIMESTAMP | snapshot_timestamp - Snapshot timestamp |
HI_ID | BIGINT | A number that uniquely identifies the health indicator in the snapshot data stream. |
DB_NAME | VARCHAR(128) | db_name - Database name |
HI_OBJ_NAME | VARCHAR(512) | A name that uniquely identifies an object in the collection. |
HI_OBJ_STATE | SMALLINT | The state of the object. Valid states (defined in sqlmon.h) include:
|
HI_OBJ_STATE_DETAIL | VARCHAR(20) | A translated string version of the value in the HI_OBJ_STATE column. |
HI_TIMESTAMP | TIMESTAMP | The date and time that the alert was generated. |