IBM Support

QSYS2.MIRROR_COMPARE_LIBRARY()

News


Abstract

The MIRROR_COMPARE_LIBRARY procedure returns a result table and an optional result set containing one or more rows for each object in the specified library on the source node that is different from the same object on the target node. The library is included in the comparison.

The objects that are compared return a value that is not EXCLUDE or INELIGIBLE from the QSYS2.CHECK_REPLICATION_CRITERIA function. 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. 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_LIBRARY procedure.
 

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 - [SF99951 Level 5 and SF99950 Level 5] & IBM i 7.4 - [SF99668 Level 23 and SF99704 Level 26]:

  • MIRROR_COMPARE_LIBRARY procedure enhanced to improve performance and serviceability of comparisons.
  • Compare the FILE_LEVEL_ID attribute for replicated database objects.
  • Compare the internal attribute used by Db2 Mirror that indicates that replicated database objects contain rows with tracked changes.
  • This enhancement requires an active version for the COMPARE-SERVICES version entry of at least 1.2 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 required by the MIRROR_COMPARE_LIBRARY procedure 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_LIBRARY procedure 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:
07 May 2024

UID

ibm16829463

Page Feedback