News
Abstract
The MIRROR_COMPARE_OBJECT table function returns differences between the source and target nodes for the object identified by object-type, library-name, and object-name. The object does not need to be a currently replicated object.
For replication-eligible objects, comparison operations are made against the definitional attributes of the object, the data contained in the object, or both. Only *FILE, *USRIDX, *USRSPC, *DTAQ, and *OUTQ objects support data comparisons. For the object being compared, a value of YES or QUICK must be specified for at least one of the compare-attributes or compare-data parameters.
Content
![Db2 Mirror](/support/pages/system/files/inline-images/Db2MirrorDarkIcon.png)
For complete details, view the IBM Documentation page: MIRROR_COMPARE_OBJECT table function.
Enhanced with IBM i 7.5 - [SF99951 Level 6 and SF99950 Level 7]:
- Compare the RESTRICT ON DROP attribute introduced in IBM i 7.5 for SQL functions, procedures, and table database objects.
- This enhancement requires an active version for the COMPARE-SERVICES version entry of at least 1.3 to fully enable. See COMPARE-SERVICES version entry for more details.
Enhanced with IBM i 7.5 Base & IBM i 7.4 - [SF99668 Level 19 and SF99704 Level 20]:
- Modified the authorization to call the MIRROR_COMPARE_OBJECT table function to require *ALLOBJ special authority.
- Compare AUTHORITY_LIST, AUTHORITY_LIST_MANAGEMENT, and PRIMARY_GROUP attributes for replicated database objects.
Enhanced with IBM i 7.4 - [SF99668 Level 11 and SF99704 Level 14]:
- MIRROR_COMPARE_OBJECT table function enhanced to support comparisons of *USRIDX, *USRSPC, and *DTAQ object types.
Was this topic helpful?
Document Information
Modified date:
07 May 2024
UID
ibm16829465