The HEALTH_DB_HIC function returns collection health indicator 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 table function.
SELECT * FROM TABLE(HEALTH_DB_HIC('',-1)) AS T
SNAPSHOT_TIMESTAMP HI_ID DB_NAME ...
-------------------------- -----...- -------...- ...
2006-02-13-12.30.33.870959 1015 SAMPLE ...
2006-02-13-12.30.33.870959 1022 SAMPLE ...
2 record(s) selected.
... HI_OBJ_NAME HI_OBJ_DETAIL ...
... ---------------------------------...-- -------------...- ...
... "JESSICAE"."EMPLOYEE" REORG TABLE ...
... "SYSIBM"."SYSDATAPARTITIONEXPRESSION" RUNSTATS ...
... HI_OBJ_STATE HI_OBJ_STATE_DETAIL HI_TIMESTAMP
... ------------ -------------------- --------------------------
... 2 Attention 2006-02-13-12.24.27.000000
... 2 Attention 2006-02-13-12.29.26.000000
Column name | Data type | Description or corresponding monitor element |
---|---|---|
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_DETAIL | VARCHAR(512) | Text that describes why the object was added to 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. |