DB2 Version 9.7 for Linux, UNIX, and Windows

hadr_syncmode - HADR Synchronization Mode monitor element

The current high availability disaster recovery (HADR) synchronization mode of the database.

Table 1. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Database	hadr	Basic

Usage

Use this element to determine the HADR synchronization mode of a database.

The data type of this element is integer.

HADR database configuration parameters are static. Changes to a parameter are not effective until the database is stopped and restarted. This monitor element reports the value the HADR system is actually using rather than the value in the database configuration file.

If the database is in HADR primary or standby role, the value for this element is one of the following constants:

SQLM_HADR_SYNCMODE_SYNC: SYNC mode.
SQLM_HADR_SYNCMODE_NEARSYNC: NEARSYNC mode.
SQLM_HADR_SYNCMODE_ASYNC: ASYNC mode.
SQLM_HADR_SYNCMODE_SUPERASYNC: SUPERASYNC mode.

This element should be ignored if the database's HADR role is standard. Use the hadr_role monitor element to determine the HADR role of the database.