News
Abstract
The VALIDATE_PENDING_REPLICATION_CRITERIA table function returns the set of Replication Criteria List (RCL) rules that are affected by the specified APPLY_LABEL. The list of rules returned includes all pending replication criteria rules that match the APPLY_LABEL and any active rules that are affected if the APPLY_LABEL is committed.
Each row is either an active or a pending rule in the RCL. All pending rules are validated to ensure no failures would occur if the APPLY_LABEL group of pending rules is committed. If a failure is detected for a pending rule, information about the error is returned in the SQLSTATE, MESSAGE_ID, MESSAGE_TEXT, and MESSAGE_SECOND_LEVEL_TEXT columns for that rule. This failure detail can be used to understand why a pending APPLY_LABEL cannot be committed.
Content
For complete detail, view the IBM Documentation page: VALIDATE_PENDING_REPLICATION_CRITERIA table function
Enhanced with IBM i 7.5 Base & IBM i 7.4 - [SF99668 Level 19 and SF99704 Level 20]:
- Add the optional RDMA_TYPE parameter.
- The default public authority of the Replication Criteria List (RCL) physical table changed to *EXCLUDE. Due to the public authority changes to the RCL, modify the authorization to call the VALIDATE_PENDING_REPLICATION_CRITERIA table function to require *OBJOPR and *READ authority on the RCL physical table.
Was this topic helpful?
Document Information
Modified date:
14 December 2022
UID
ibm16829899