The HEALTH_DBM_HI table function returns health indicator information from a health snapshot of the DB2® database manager.
If the null value is specified, -1 is set implicitly.
EXECUTE privilege on the HEALTH_DBM_HI table function.
SELECT * FROM TABLE(HEALTH_DBM_HI(-1)) AS T
SNAPSHOT_TIMESTAMP HI_ID SERVER_INSTANCE_NAME ...
-------------------------- -----...- --------------------...- ...
2006-02-13-12.30.19.773632 1 DB2 ...
2006-02-13-12.30.19.773632 4 DB2 ...
2 record(s) selected.
... HI_VALUE HI_TIMESTAMP HI_ALERT_STATE HI_ALERT_STATE_DETAIL ...
... -------- -------------------------- -------------- --------------------- ...
... 0 2006-02-13-12.26.26.158000 1 Normal ...
... 100 2006-02-13-12.26.26.158000 4 Alarm ...
... HI_FORMULA HI_ADDITIONAL_INFO
... ---------------------...- ------------------
... 0 -
... ((327680 / 327680) * 100) -
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. |
SERVER_INSTANCE_NAME | VARCHAR(128) | server_instance_name - Server instance name |
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. |