Object replication controls

Object replication controls provide the capability to control object replication for certain replication-eligible object types at the product level.

Object replication controls are available for the following object types:

Data queue entries
User index (*USRIDX)
User space (*USRSPC)

For data queues, the object replication control affects only the replication of data. When the object replication control is disabled, only the entries of a data queue are disabled from replication. The definition of the data queue remains replicated.

For user index and user space objects, the object replication control enables or disables replication of the object definition and data within the object.

The initial configuration default for these object types is disabled. A replication control applies to both nodes of the mirrored pair and it supersedes the Replication Criteria List (RCL) rules and the default inclusion state that are used to determine object replication status. When an object type is disabled through object replication controls, any RCL rules that include the object type will be ignored. When an object type is enabled, the RCL is used to determine object replication.

The following figure shows how to access the object replication controls menu through the Db2® Mirror GUI.

Figure 1. Selecting Object Replication Controls using the Db2 Mirror GUI

The following figure shows how object types can be enabled or disabled from replication.

Figure 2. Configuring Object Replication Controls with the Db2 Mirror GUI

Depending on the Db2 Mirror communication status between the nodes, changing the replication setting for an object type may require a Suspend and Resume. See CHANGE_MIRROR procedure for additional information.

You can use the Both Nodes tab to display the current replication setting for an object type as shown in the following figure.

Figure 3. Display Object Replication Controls detail

The QSYS2.CHANGE_MIRROR procedure can be used to change the replication setting for an object type.

CALL QSYS2.CHANGE_MIRROR(REPLICATE_USER_INDEX => 'ENABLE');

The QSYS2.MIRROR_INFO view can be used to display the object replication controls setting for each supported object type. See MIRROR_INFO view for details.