Replication services

These services can be used to configure and review details for Db2® Mirror replication.

ADD_REPLICATION_CRITERIA procedure
The ADD_REPLICATION_CRITERIA procedure registers a replication criteria rule in the Replication Criteria List (RCL). The rules are used to determine which objects are included or excluded from replication through Db2 Mirror.
CHECK_REPLICATION_CRITERIA scalar function
The CHECK_REPLICATION_CRITERIA scalar function returns an indication of the replication inclusion state for an object. Rules defined in the Replication Criteria List (RCL) are applied against the object identified by the iasp-name, library-name, object-type, and object-name parameters.
EVALUATE_PENDING_REPLICATION_CRITERIA table function
The EVALUATE_PENDING_REPLICATION_CRITERIA table function returns one row for each object found that matches any of the replication criteria rules from the Replication Criteria List (RCL) identified by the apply-label parameter. Only objects whose replication action will be changed by the replication criteria rules will be returned. This list of objects can be examined to understand the replication action that would be applied to each object when the pending rules are committed.
INSPECT_REPLICATION_CRITERIA table function
The INSPECT_REPLICATION_CRITERIA table function returns one row for each rule that applies to the object identified by the iasp-name, library-name, object-type, and object-name parameters. The list of rules generated with and without a pending apply-label can be examined to understand the effect of applying a pending rule.
PROCESS_PENDING_REPLICATION_CRITERIA procedure
The PROCESS_PENDING_REPLICATION_CRITERIA procedure handles a set of pending replication criteria rules in the Replication Criteria List (RCL) by either changing the APPLY_STATE to ACTIVE or permanently removing the pending entries for the specified apply-label.
REMOVE_REPLICATION_CRITERIA procedure
The REMOVE_REPLICATION_CRITERIA procedure removes a replication criteria rule from the Replication Criteria List (RCL). The rules are used to determine which objects are included or excluded from replication through Db2 Mirror.
REPLICATION_CRITERIA_INFO view
The REPLICATION_CRITERIA_INFO view returns the Db2 Mirror object replication rules. The view returns one row for each rule in the Replication Criteria List (RCL). Each row describes a rule that determines whether objects are included or excluded from replication.
VALIDATE_PENDING_REPLICATION_CRITERIA table function
The VALIDATE_PENDING_REPLICATION_CRITERIA table function returns the set of Replication Criteria List (RCL) rules that are affected by a given apply-label. The list of rules returned includes all pending replication criteria rules that match the apply-label and any active rules that will be affected if the apply-label is committed.
Additional replication examples
The following examples demonstrate additional concepts for working with the Replication Criteria List (RCL).

Parent topic: Db2 Mirror services