Returns health alert configuration settings for various object types (database manager, database, table space, table space container) and for various configuration levels (install default, global, and object).
>>-HEALTH_GET_ALERT_CFG--(--objecttype--,--cfg_level--,---------> >--dbname--,--objectname--)------------------------------------><
The schema is SYSPROC.
EXECUTE privilege on the HEALTH_GET_ALERT_CFG table function.
SELECT * FROM TABLE(SYSPROC.HEALTH_GET_ALERT_CFG('DB','O','SAMPLE',''))
AS ALERT_CFG
OBJECTTYPE CFG_LEVEL DBNAME OBJECTNAME ...
---------- --------- --------...----- -------------...------ ...
DB O SAMPLE ...
DB O SAMPLE ...
DB O SAMPLE ...
DB O SAMPLE ...
DB O SAMPLE ...
DB O SAMPLE ...
DB O SAMPLE ...
DB O SAMPLE ...
DB O SAMPLE ...
DB O SAMPLE ...
DB O SAMPLE ...
DB O SAMPLE ...
DB O SAMPLE ...
DB O SAMPLE ...
... ...
... ID IS_DEFAULT WARNING_THRESHOLD ...
... -------------------- ---------- -------------------- ...
... 1001 0 0 ...
... 1018 0 0 ...
... 1015 0 0 ...
... 1022 0 0 ...
... 1002 1 95 ...
... 1003 1 30 ...
... 1004 1 60 ...
... 1005 1 75 ...
... 1006 1 75 ...
... 1007 1 5 ...
... 1008 1 75 ...
... 1009 1 5 ...
... 1010 1 50 ...
... 1011 1 80 ...
... ALARM_THRESHOLD SENSITIVITY EVALUATE ACTION_ENABLED
... -------------------- -------------------- -------- --------------
... 0 0 0 0
... 0 0 1 0
... 0 0 1 0
... 0 0 1 0
... 100 0 0 0
... 50 0 1 0
... 30 0 1 0
... 85 0 1 0
... 85 0 1 0
... 10 0 1 0
... 85 0 1 0
... 10 0 1 0
... 70 0 1 0
... 70 0 0 0
SELECT WARNING_THRESHOLD, ALARM_THRESHOLD
FROM TABLE(SYSPROC.HEALTH_GET_ALERT_CFG('TS','O','SAMPLE','USERSPACE1'))
AS T WHERE ID = 2002
WARNING_THRESHOLD ALARM_THRESHOLD
-------------------- --------------------
80 90
SQL22004N Cannot find the requested configuration for the given object.
Returning default configuration for "tablespaces".
1 record(s) selected with 1 warning messages printed.
The HEALTH_GET_IND_DEFINITION table function can be used to map health indicator IDs to the health indicator names.
WITH HINAME(ID) AS (SELECT ID FROM TABLE(SYSPROC.HEALTH_GET_IND_DEFINITION('')) AS W
WHERE NAME = 'ts.ts_util')
SELECT WARNING_THRESHOLD, ALARM_THRESHOLD
FROM TABLE(SYSPROC.HEALTH_GET_ALERT_CFG('TS','O','SAMPLE','USERSPACE1')) AS T,
HINAME AS H
WHERE T.ID = H.ID
WARNING_THRESHOLD ALARM_THRESHOLD
-------------------- --------------------
80 90
SQL22004N Cannot find the requested configuration for the given object.
Returning default configuration for "tablespaces".
1 record(s) selected with 1 warning messages printed.
Column name | Data type | Description |
---|---|---|
OBJECTTYPE | VARCHAR(3) | Object type. |
CFG_LEVEL | CHAR(1) | Configuration level. |
DBNAME | VARCHAR(128) | Database name. |
OBJECTNAME | VARCHAR(512) | Object name. |
ID | BIGINT | Health indicator ID. |
IS_DEFAULT | SMALLINT | Whether the settings is the default: 1 if it is the default, 0 if it is not the default or Null if not applicable. |
WARNING_THRESHOLD | BIGINT | Warning threshold. Null if not applicable. |
ALARM_THRESHOLD | BIGINT | Alarm threshold. Null if not applicable. |
SENSITIVITY | BIGINT | Health indicator sensitivity. |
EVALUATE | SMALLINT | 1 if this health indicator is being evaluated or 0 if it is not being evaluated. |
ACTION_ENABLED | SMALLINT | 1 if an action is enabled to run upon an alert occurrence or 0 if no action is enabled to run upon an alert occurrence. |