IBM Support

QSYS2.MIRROR_COMPARE_OBJECT()

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 each object being compared, comparison operations can be performed for the definitional attributes of the object, the data contained in the object, or both. Only *DTAQ, *FILE, *OUTQ, *USRIDX, and *USRSPC 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

For complete details, view the IBM Documentation page: MIRROR_COMPARE_OBJECT table function.
 

Enhanced with IBM i 7.5 - [SF99951 Level 7 and SF99950 Level 8] & IBM i 7.4 - [SF99668 Level 25 and SF99704 Level 29]:

  • All system object types can be compared. However, object types that are not eligible for replication will only have attributes extracted from QSYS2.OBJECT_STATISTICS table function from each node compared.
  • This enhancement requires an active version for the COMPARE-SERVICES version entry of at least 1.4 to fully enable. See COMPARE-SERVICES version entry for more details.

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.

[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"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":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"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:
08 April 2025

UID

ibm16829465

Page Feedback