Returns the health indicator definitions.
The schema is SYSPROC.
EXECUTE privilege on the HEALTH_GET_IND_DEFINITION table function.
SELECT TYPE, SHORT_DESCRIPTION
FROM TABLE(SYSPROC.HEALTH_GET_IND_DEFINITION('fr_FR'))
AS IND_DEFINITION WHERE NAME = 'db.db_op_status'
TYPE SHORT_DESCRIPTION
---------------- ----------------------------------------...---------
STATE Etat opérationnel de la base de données
1 record(s) selected.
SELECT SHORT_DESCRIPTION FROM TABLE(SYSPROC.HEALTH_GET_IND_DEFINITION('en_US')
AS IND_DEFINITION WHERE ID = 1001
SHORT_DESCRIPTION
-----------------------------...-------------
Database Operational State
SELECT ID, NAME FROM TABLE(HEALTH_GET_IND_DEFINITION('')) AS T
ID NAME
-------------------- ----------------------------
1 db2.db2_op_status
2 db2.sort_privmem_util
4 db2.mon_heap_util
1001 db.db_op_status
1002 db.sort_shrmem_util
...
2001 ts.ts_op_status
2002 ts.ts_util
...
3002 tsc.tscont_util
1015 db.tb_reorg_req
...
Column name | Data type | Description |
---|---|---|
ID | BIGINT | Health indicator ID. |
NAME | VARCHAR(128) | Health indicator name. |
SHORT_DESCRIPTION | VARCHAR(1024) | Health indicator short description. |
LONG_DESCRIPTION | VARCHAR(32672) | Health indicator long description. |
TYPE | VARCHAR(16) | Health indicator type. Possible values are:
|
UNIT | VARCHAR(1024) | Unit of the health indicator values and thresholds or Null if not applicable. |
CATEGORY | VARCHAR(1024) | Health indicator category. |
FORMULA | VARCHAR(512) | Health indicator formula. |
REFRESH_INTERVAL | BIGINT | Health indicator evaluation interval in seconds. |