DB2 10.5 for Linux, UNIX, and Windows

Viewing health alert summaries

The HEALTH_OVERVIEW function returns information from the Health Alert Summary VSAM KSDS data set as a DB2® table. This data set is created by the DSNTIJHM installation job.

About this task

The Health Alert Summary data set contains information about the state of the DB2 health monitor and alert summary statistics for every DB2 subsystem previously or currently monitored by the health monitor on that MVS™ system or Parallel Sysplex®. These information are returned to the client with a row for each DB2 subsystem and alert recommendation.

The result of the function is a DB2 table with the following columns:

ip-addr

The IP address of the DB2 server. This is a column of type VARCHAR(40).

db2-ssid

The subsystem identifier of the DB2 subsystem. This is a column of type VARCHAR(4).

health-ind

The type of alert. Possible values are:

RS - Restricted State
EX - Extents Exceeded
RR - REORG Required
CR - COPY Required
RT - RUNSTATS Required
SS - STOSPACE Required
PO - Failed Policy Evaluation
HM - Health Monitor State

health-ind is a column of type VARCHAR(4).

host-name

The fully qualified domain name of the DB2 server. This is a column of type VARCHAR(255).

summary-stats

The state of the DB2 health monitor if health-ind is 'HM'. Possible values are:

0 Health monitor is not started
1 Health monitor is started
-1 Health monitor state is unknown

Otherwise, the total number of alert objects with the alert type specified in health-ind. This is a column of type INTEGER.

alert-state

The state of the alert specified in health-ind. Possible values are:

5 - Alarm
4 - Attention
3 - Warning
0 - Normal

alert-state is always 0 when health-ind is 'HM'. This is a column of type INTEGER.

The external program name for the function is HEALTH_OVERVIEW, and the specific name is DSNACC.DSNACCHO. This function is created by the DSNTIJCC installation job.

Example

Find the total number of alert objects requiring COPY for the DB2 subsystem 'ABCD':

   SELECT SUMMARYSTATS FROM TABLE (DSNACC.HEALTH_OVERVIEW()) AS T 
         WHERE DB2SSID = 'ABCD'
                 AND HEALTHIND = 'CR';