Start of change

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.
Start of changeLICENSE_EXPIRATION_THRESHOLDEnd of change Start of changeLIC_EXPIREEnd of change Start of changeVARCHAR(4)
Nullable
End of change		 Start of changeThe 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.

End of change

Example

  • Review the current health center properties for the current node.
    SELECT *
    FROM QSYS2.MIRROR_HEALTH_MONITOR_INFO;
End of change