Start of change

CHANGE_MIRROR_HEALTH_MONITOR procedure

The CHANGE_MIRROR_HEALTH_MONITOR procedure is used to manage the properties the health center uses to monitor for issues in the Db2® Mirror environment.

Some properties, including changing the critical-resource-check-interval, the less-critical resource-check-interval, or the suspend-wait-time property, affect both nodes. Other properties only change the value on the current node. The individual option descriptions explain the scope of the change for each health center property.

The available-storage-threshold or suspend-wait-time properties can cause Db2 Mirror replication to be suspended. When the other properties trigger an alert, the health center sends notifications indicating the resource that caused the alert to the QSYSOPR message queue. For more information, see Monitoring for messages.

Authorization: For the authority needed to use this procedure, see Authorization.

Read syntax diagramSkip visual syntax diagram CHANGE_MIRROR_HEALTH_MONITOR ( IASP_NAME => iasp-name,AVAILABLE_STORAGE_THRESHOLD => available-storage-threshold,SUSPEND_WAIT_TIME => suspend-wait-time,CRITICAL_RESOURCE_CHECK_INTERVAL => critical-resource-check-interval,RESOURCE_CHECK_INTERVAL => resource-check-interval,LICENSE_EXPIRATION_THRESHOLD => license-expiration-threshold )

The schema is QSYS2.

iasp-name

A character or graphic string that contains the device description name of the independent auxiliary storage pool (IASP) where the changes are to occur. For an IASP group, specify the device description name of the primary IASP. Can contain the following special value:

*SYSBAS
Changes apply to SYSBAS. SYSBAS includes the system ASP (ASP 1) and the basic user ASPs (ASPs 2-32).

If this parameter is omitted, *SYSBAS is used.

The iasp-name parameter applies to the available-storage-threshold attribute. It is ignored for any other option.

available-storage-threshold

A character or graphic string that specifies the threshold percentage of remaining available storage in the auxiliary storage pool (ASP) before replication is suspended.

The attribute can be set individually for SYSBAS and each registered database IASP on the current node. Monitoring of the threshold is checked independently against each ASP that comprises SYSBAS and each registered database IASP. When the amount of available storage for an ASP falls beneath the available storage threshold percentage property, replication is suspended. The suspend of SYSBAS replication by the health center also suspends replication for all registered database IASPs.

If this parameter is omitted, the available storage threshold attribute is not changed.

The initial configuration default is 3.00 percent.

0.01-20.00
The percentage of storage to remain available.
NONE
Db2 Mirror does not monitor available storage within the health center.
suspend-wait-time

A character or graphic string value that specifies the amount of time, in seconds, that the health center waits before a suspend is initiated when communication is lost between the nodes for any reason.

The value must be at least three times the critical-resource-check-interval property.

If this parameter is omitted, the suspend wait time is not changed. The iasp-name parameter does not apply to suspend-wait-time and is ignored. The attribute value applies to both nodes.

The initial configuration default is 240 seconds (4 minutes).

15-3600
The time interval, in seconds, to be used.
NOMAX
Db2 Mirror does not monitor loss of communications to the other node within the health center.
critical-resource-check-interval

An integer value that specifies the time interval, in seconds, between checks for critical resources monitored by the health center against the target node. For more information on the types of resources monitored, see Critical resource checks.

If this parameter is omitted, the critical resource check interval is not changed. The iasp-name parameter does not apply to critical-resource-check-interval and is ignored. The attribute value applies to both nodes.

The initial configuration default is 15 seconds.

5-60
The time interval, in seconds, to be used.
resource-check-interval

An integer value that specifies the time interval, in minutes, that is used for monitoring Db2 Mirror product resources on the local node. The monitoring of Db2 Mirror product resources involves periodically checking the status of various resources that might jeopardize the Db2 Mirror environment. For more information on the types of resources monitored, see Product resource checks.

If this parameter is omitted, the Db2 Mirror product resource check interval is not changed. The iasp-name parameter does not apply to resource-check-interval and is ignored. The attribute value applies to both nodes.

The initial configuration default is 5 minutes.

1-1440
The time interval, in minutes, to be used.
Start of changelicense-expiration-thresholdEnd of change
Start of change

A character or graphic string expression that specifies the number of remaining days before alerts by the health center begin for any approaching expired license keys for the Db2 Mirror product. The products that are monitored by the health center are described in License expiration monitoring.

If this parameter is omitted, the license expiration threshold is not changed. The attribute value can only be set for SYSBAS on the current node. The iasp-name parameter does not apply to license-expiration-threshold and is ignored.

The initial configuration default is 30 days.

1-365
The number of remaining days before health center alerts begin for any approaching expired license keys.
NONE
Disable alerts for any approaching expired license keys.
End of change

Example

  • Set the threshold percentage of remaining available storage property associated with database IASP named IASP36 to 7 percent on the current node.
    CALL QSYS2.CHANGE_MIRROR_HEALTH_MONITOR(IASP_NAME => 'IASP36',
                                            AVAILABLE_STORAGE_THRESHOLD => '7.0');
End of change