IBM Support

QSYS2.EVALUATE_PENDING_REPLICATION_CRITERIA()

News


Abstract

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 is changed by the replication criteria rules are 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.

Each row describes a single object that is eligible for replication that matches one or more of the replication criteria rules identified by the APPLY_LABEL parameter. The function identifies objects that exist on either node and indicates the replication action that would be performed against the object. Additional information about the object is returned in the OBJECT_INFO column. When a node or an IASP is not accessible, only those objects that can be identified from the current node are returned. No comparison of the objects can be performed when a node is inaccessible.

When the compare-objects parameter is set to YES and an object that will require replication is found on both nodes, the objects are compared and the result is returned in the COMPARE_RESULT column. While rows are returned for all object types eligible for replication, only some types support comparisons. All others return the null value for the comparison result. If any object's COMPARE_RESULT is DIFFERENT, the OBJECT_INFO column contains additional information about why this object prevents the pending replication criteria rules from being committed. Rows where COMPARE_RESULT is the null value might cause failures when replication processing occurs.

Content

Db2 Mirror

For complete detail, view the IBM Documentation page: EVALUATE_PENDING_REPLICATION_CRITERIA table function
 

Enhanced with IBM i 7.5 Base & IBM i 7.4 - [SF99668 Level 19 and SF99704 Level 20]:

  • The default public authority of the service program used to implement the Db2 Mirror Replication service QSYS2.EVALUATE_PENDING_REPLICATION_CRITERIA was changed from QSYS2/QMRDBSSRTV, which was shipped with *PUBLIC *USE authority to QSYS/QMRDBSSDBA which is shipped with *PUBLIC *EXCLUDE authority.

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSLLPF","label":"IBM Db2 Mirror for i"},"ARM Category":[{"code":"a8m0z0000001hExAAI","label":"DB2 Mirror"}],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.4.0;and future releases"},{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000001hExAAI","label":"DB2 Mirror"}],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.4.0;and future releases"}]

Document Information

Modified date:
14 December 2022

UID

ibm16829905