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.
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
host-name
The fully qualified domain name of the DB2 server. This is a column of type VARCHAR(255).
summary-stats
alert-state
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.
SELECT SUMMARYSTATS FROM TABLE (DSNACC.HEALTH_OVERVIEW()) AS T
WHERE DB2SSID = 'ABCD'
AND HEALTHIND = 'CR';