MIRROR_HEALTH_MONITOR_INFO view

The MIRROR_HEALTH_MONITOR_INFO view returns information about the health center properties used to monitor the Db2® Mirror environment. The information reflects values that are obtained from the current node.

Authorization: The privileges that are held by the authorization ID of the statement must include the following:

*EXECUTE authority on the QSYS2 library.
*OBJOPR and *READ authority on QSYS2/MIRROR_HMI.
For the authority needed to use this view, see Authorization.

The following table describes the columns in the view. The system name is MIRROR_HMI. The schema is QSYS2.

Table 1. MIRROR_HEALTH_MONITOR_INFO view
Column Name	System Column Name	Data Type	Description
IASP_NAME	IASP_NAME	VARCHAR(10)	The device description name of the independent auxiliary storage pool (IASP). IFS IASPs are omitted. For an IASP group, this column contains the device description name of the primary IASP. The special value of *SYSBAS indicates SYSBAS, which includes the system ASP (ASP 1) and the basic user ASPs (ASPs 2-32). IFS IASPs are not included in this view.
AVAILABLE_STORAGE_THRESHOLD	AVAIL_STG	VARCHAR(5)	The threshold percentage of remaining available storage in the auxiliary storage pool (ASP) before replication is suspended. 0.01-20.00 The percentage of storage to remain available. NONE No available storage threshold is used.
SUSPEND_WAIT_TIME	SUSP_WAIT	VARCHAR(5) Nullable	The amount of time, in seconds, that the health center waits before a suspend is initiated when communications is lost between the nodes for any reason. 15-3600 The number of seconds to wait. NOMAX The time to wait is indefinite. Contains the null value if this row is not for SYSBAS.
CRITICAL_RESOURCE_CHECK_INTERVAL	CRIT_CHK	INTEGER Nullable	The time interval, in seconds, between checks for critical resources monitored by the health center against the target node. 5-60 The time interval in seconds to be used. Contains the null value if this row is not for SYSBAS.
RESOURCE_CHECK_INTERVAL	RSC_CHK	INTEGER Nullable	The time interval, in minutes, between checks for Db2 Mirror product resources monitored by the health center against the local node. 1-1440 The time interval in minutes to be used. Contains the null value if this row is not for SYSBAS.
LICENSE_EXPIRATION_THRESHOLD	LIC_EXPIRE	VARCHAR(4) Nullable	The number of remaining days before alerts by the health center begin for any approaching expired license keys for the Db2 Mirror product. 1-365 The number of days to use as a threshold before the health center alerts of any approaching expired Db2 Mirror license keys. NONE No license expiration threshold is used. Contains the null value if this row is not for SYSBAS.

Example

Review the current health center properties for the current node.
```
SELECT *
    FROM QSYS2.MIRROR_HEALTH_MONITOR_INFO;
```