COMPARE-SERVICES version entry

IBM i operating system makes use of registered version information entries to enable enhancements to Db2 Mirror for i that require coordination of specific features or functions across both nodes. A version information entry that contains DB2-MIRROR for its version group and COMPARE-SERVICES for its version name is used to enable features related to the QSYS2.MIRROR_COMPARE_LIBRARY() procedure, QSYS2.MIRROR_COMPARE_NODE() procedure, and QSYS2.MIRROR_COMPARE_OBJECT() table function.

Use the following SQL to display the highest registered version value that is available on both nodes for the COMPARE-SERVICES version information entry:

SELECT ACTIVE_VERSION, ENTRY_SOURCE, 
       VERSION_GROUP, VERSION_NAME, 
       PRIMARY_VERSION, SECONDARY_VERSION
    FROM QSYS2.MIRROR_VERSION_LIST
    WHERE STATE         = 'ACTIVE' AND
          VERSION_GROUP = 'DB2-MIRROR' AND
          VERSION_NAME  = 'COMPARE-SERVICES';

For complete details on viewing registered version information entries stored in the Mirror Version List (MVL), view the IBM Documentation page: MIRROR_VERSION_LIST view.

NOTE:  A PTF of Base indicates that the version for the enhancement is enabled in the base release. Base Enhanced indicates that the version for the enhancement was enabled in the base release without any additional PTFs.

• Active version:  1.3
• Version group:  DB2-MIRROR
• Version name:  COMPARE-SERVICES

Version 1.3 enhances support within the Db2 Mirror services that compares database objects and includes the following changes:

• Compare the RESTRICT ON DROP attribute introduced in IBM i 7.5 for SQL functions, procedures, and table database objects.

The enhancements for this version are enabled after the following Db2 Mirror for i and Db2 for i PTF Groups are loaded and applied:

• IBM i 7.5 - [SF99951 Level 6 and SF99950 Level 7]

• Active version:  1.2
• Version group:  DB2-MIRROR
• Version name:  COMPARE-SERVICES

Version 1.2 enhances support within the Db2 Mirror services that compare objects to improve the performance and serviceability of comparisons. The enhancement includes the following changes:

• Improve compatibility when Db2 Mirror is comparing objects that reside on nodes with different releases.
• 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.

The enhancements for this version are enabled after the following Db2 Mirror for i and Db2 for i PTF Groups are loaded and applied:

• IBM i 7.5 - [SF99951 Level 5 and SF99950 Level 5]
• IBM i 7.4 - [SF99668 Level 23 and SF99704 Level 26]

Back to top