News
Abstract
Registered version information in the Mirror Version List is used to determine the common active version that is used by both nodes to coordinate specific features or functions in either a Db2 Mirror replication or a IBM i Migrate While Active environment. This table lists each version information entry added by the IBM i operating system, a description of the feature or function that uses that version information, the Db2 Mirror for i PTF Group levels and the earliest possible release where that active version is available.
Content
Db2 Mirror for i and IBM i Migrate While Active makes use of registered version information stored in the Mirror Version List (MVL) view to identify the highest version value that is available on both nodes. The same version identifier value can exist on separate OS releases or when nodes are on different Group PTF levels. This allows for the coordination of new features or functions to be enabled when the operating system levels are different across the nodes.
-
Version group:
Used to associate related version names together. An application can have multiple version names that share group names to allow version information to be updated and committed together in the same group.
Version name:
Used to identify a version entry within a group. IBM Db2 Mirror for i makes use of version entries with the same version-group and version-name are evaluated when calculating the ACTIVE_VERSION, PRIMARY_VERSION, and SECONDARY_VERSION.
Active version:
The version identifier that is actively used by both nodes. The PRIMARY_VERSION and SECONDARY_VERSION values are evaluated to determine the highest version value that is available on both nodes. The format is xxx.yyy.zzz, where:
xxx: The major version number. This value is always present for a version number.
yyy: An optional minor version number.
zzz: An optional revision version number.PTF groups:
Which PTFs for each supported release are required for a given registered version information.
To list all the registered Db2 Mirror version information contained in the QSYS2.MIRROR_VERSION_LIST view:
SELECT VERSION_GROUP, VERSION_NAME,
TEXT_DESCRIPTION, ACTIVE_VERSION,
PRIMARY_VERSION, SECONDARY_VERSION
FROM QSYS2.MIRROR_VERSION_LIST
WHERE STATE = 'ACTIVE' AND
ENTRY_SOURCE = 'SYSTEM' AND
VERSION_GROUP IN ('DATABASE', 'DB2-MIRROR', 'MRDB')
ORDER BY VERSION_GROUP, VERSION_NAME;Quick links to a table that describes version names for individual version groups:
DATABASE version group
| Version name | Description | Active version | IBM i 7.6 | IBM i 7.5 | IBM i 7.4 |
|---|---|---|---|---|---|
| PERF‑BLOCKED‑INSERT | Enhancements for Database file blocked inserts. | 1.1 | Base | SF99951 Level 3 SF99950 Level 3 | SF99668 Level 21 SF99704 Level 23 |
| SQL-ADD_DAYS | ADD_DAYS is a new built-in scalar function that can be used to add or subtract a specific unit of time from a timestamp or date. See ADD_DAYS built-in scalar function for more details. | 1.1 | Base | SF99951 Level 4 SF99950 Level 4 | SF99668 Level 22 SF99704 Level 25 |
| SQL-ADD_HOURS | ADD_HOURS is a new built-in scalar function that can be used to add or subtract a specific unit of time from a timestamp or date. See ADD_HOURS built-in scalar function for more details. | 1.1 | Base | SF99951 Level 4 SF99950 Level 4 | SF99668 Level 22 SF99704 Level 25 |
| SQL-ADD_MINUTES | ADD_MINUTES is a new built-in scalar function that can be used to add or subtract a specific unit of time from a timestamp or date. See ADD_MINUTES built-in scalar function for more details. | 1.1 | Base | SF99951 Level 4 SF99950 Level 4 | SF99668 Level 22 SF99704 Level 25 |
| SQL-ADD_SECONDS | ADD_SECONDS is a new built-in scalar function that can be used to add or subtract a specific unit of time from a timestamp or date. See ADD_SECONDS built-in scalar function for more details. | 1.1 | Base | SF99951 Level 4 SF99950 Level 4 | SF99668 Level 22 SF99704 Level 25 |
| SQL-ADD_YEARS | ADD_YEARS is a new built-in scalar function that can be used to add or subtract a specific unit of time from a timestamp or date. See ADD_YEARS built-in scalar function for more details. | 1.1 | Base | SF99951 Level 4 SF99950 Level 4 | SF99668 Level 22 SF99704 Level 25 |
| SQL-ANY_VALUE | ANY_VALUE is a new built-in aggregate function that returns an arbitrary value for a set of values in a group. See ANY_VALUE aggregate function for more details. | 1.1 | Base | SF99951 Level 6 SF99950 Level 7 | SF99668 Level 24 SF99704 Level 28 |
| SQL-CREATE-ALIAS-LAST | CREATE ALIAS statement can be used with a member name of *LAST. This alias refers to the most recently created member of a file at the time an SQL statement references it. See CREATE ALIAS with *LAST member for more details. | 1.1 | Base | SF99951 Level 6 SF99950 Level 7 | SF99668 Level 24 SF99704 Level 28 |
| SQL‑DB2‑GEOSPATIAL‑ANALYTICS | Geospatial functions, with IBM Watson, add industry-leading technology in the form of Geospatial Analytics to Db2 for i. With these analytic functions that include projection-free Ellipsoidal support and native Geohashes, the IBM i client can easily use SQL to use Watson Geospatial technology. See Geospatial Analytics for more details. | 1.1 | Base | SF99951 Level 3 SF99950 Level 3 | SF99668 Level 21 SF99704 Level 23 |
| SQL-DETERMINISTIC-CTE | Changes to the query optimizer in how it implements queries in which a Common Table Expression (CTE) is referenced multiple times within that same query. See Change to implementation of some shared common table expressions for SQL queries for more details. | 1.1 | Base | SF99951 Level 5 SF99950 Level 5 | SF99668 Level 23 SF99704 Level 26 |
| SQL-ENCRYPT_AES256 | ENCRYPT_AES256 is a new function that return a value that is the result of encrypting a string of data using the AES encryption algorithm with a 256-bit encryption key. See ENCRYPT_AES256 built-in scalar function for more details. | 1.1 | Base | SF99951 Level 5 SF99950 Level 5 | SF99668 Level 23 SF99704 Level 26 |
| SQL‑FIRST_DAY | FIRST_DAY is a new built-in scalar function that is used to derive the first day of the month in date or timestamp format. See FIRST_DAY built-in scalar function for more details. | 1.1 | Base | SF99951 Level 3 SF99950 Level 3 | SF99668 Level 21 SF99704 Level 23 |
| SQL-FROM_SYSTEM_TIMESTAMP | New built-in FROM_SYSTEM_TIMESTAMP and TO_SYSTEM_TIMESTAMP scalar functions returns either a TIMESTAMP from an internal system timestamp value or an internal system timestamp value for a timestamp expression. See FROM_SYSTEM_TIMESTAMP and TO_SYSTEM_TIMESTAMP function scalar functions for more details. | 1.1 | SF99961 Level 2 SF99960 Level 2 | SF99951 Level 11 SF99950 Level 12 | - |
| SQL-TO_SYSTEM_TIMESTAMP | |||||
| SQL‑GENERATE_UUID | New built-in GENERATE_UUID and GENERATE_UUID_BINARY scalar functions that return a formatted string representation and a binary string representation of a Universally Unique Identifier (UUID) using the version 4 algorithm. See GENERATE_UUID and GENERATE_UUID_BINARY scalar functions for more details. | 1.1 | Base | SF99951 Level 7 SF99950 Level 8 | SF99668 Level 25 SF99704 Level 29 |
| SQL‑GENERATE_UUID_BINARY | |||||
| SQL-HTML_ENTITY_DECODE | New built-in HTML_ENTITY_DECODE and HTML_ENTITY_ENCODE scalar functions decode and encode HTML entities in a string. See HTML_ENTITY_DECODE and HTML_ENTITY_ENCODE built-in scalar functions for more details. | 1.1 | Base | SF99951 Level 5 SF99950 Level 5 | SF99668 Level 23 SF99704 Level 26 |
| SQL-HTML_ENTITY_ENCODE | |||||
| SQL-HTTP_DELETE_BLOB | New built-in HTTP functions that can be used make an HTTP DELETE request and return BLOB data. See New HTTP functions based in QSYS2 for more details. | 1.1 | Base | SF99951 Level 4 SF99950 Level 4 | SF99668 Level 22 SF99704 Level 25 |
| SQL-HTTP_DELETE_BLOB_VERBOSE | |||||
| SQL-HTTP_GET_BLOB | New built-in HTTP functions that can be used make an HTTP GET request and return BLOB data. See New HTTP functions based in QSYS2 for more details. | 1.1 | Base | SF99951 Level 4 SF99950 Level 4 | SF99668 Level 22 SF99704 Level 25 |
| SQL-HTTP_GET_BLOB_VERBOSE | |||||
| SQL-HTTP_PATCH_BLOB | New built-in HTTP functions that can be used make an HTTP PATCH request and return BLOB data. See New HTTP functions based in QSYS2 for more details. | 1.1 | Base | SF99951 Level 4 SF99950 Level 4 | SF99668 Level 22 SF99704 Level 25 |
| SQL-HTTP_PATCH_BLOB_VERBOSE | |||||
| SQL-HTTP_POST_BLOB | New built-in HTTP functions that can be used make an HTTP POST request and return BLOB data. See New HTTP functions based in QSYS2 for more details. | 1.1 | Base | SF99951 Level 4 SF99950 Level 4 | SF99668 Level 22 SF99704 Level 25 |
| SQL-HTTP_POST_BLOB_VERBOSE | |||||
| SQL-HTTP_PUT_BLOB | New built-in HTTP functions that can be used make an HTTP PUT request and return BLOB data. See New HTTP functions based in QSYS2 for more details. | 1.1 | Base | SF99951 Level 4 SF99950 Level 4 | SF99668 Level 22 SF99704 Level 25 |
| SQL-HTTP_PUT_BLOB_VERBOSE | |||||
| SQL‑JSON_UPDATE | The JSON_UPDATE built-in scalar function provides a tactical programmatic approach for updating or removing a piece of a JSON document. See JSON_UPDATE built-in scalar function for more details. | 1.1 | Base | SF99951 Level 3 SF99950 Level 3 | SF99668 Level 21 SF99704 Level 23 |
| SQL-RESTRICT-ON-DROP-ROUTINES | RESTRICT ON DROP is an attribute that can be added or removed to SQL Routines to provide an added layer of protection from accidental or malicious delete actions. See RESTRICT ON DROP for more details. | 1.1 | Base | SF99951 Level 4 SF99950 Level 4 | Not Supported |
| SQL-SQ-INTERNAL-MAINTENANCE | Internal maintenance for Db2 Mirror to enable features related to replication of SQL objects. | 1.1 | Base | SF99951 Level 4 SF99950 Level 4 | SF99668 Level 22 SF99704 Level 25 |
| SQL‑TIMESTAMPDIFF_BIG | The TIMESTAMPDIFF_BIG built-in scalar function provides an alternative to TIMESTAMPDIFF, and is able to handle any granularity and scale of timestamp comparison. See TIMESTAMPDIFF_BIG built-in scalar function for more details. | 1.1 | Base | SF99951 Level 3 SF99950 Level 3 | SF99668 Level 21 SF99704 Level 23 |
| SQL-TRIGGER-FILE-NAME | Trigger pseudo columns can be referenced within an SQL trigger to access the name of the file, library, and member that caused the trigger to fire. See Trigger pseudo columns for more details. | 1.1 | SF99961 Level 3 SF99960 Level 3 | SF99951 Level 11 SF99950 Level 12 | - |
| SQL-UDTF-COMMENT-ON | User-Defined Table Functions return rows and columns, and now with COMMENT ON UDTF Return Columns, the same usability comes to UDTFs that is found with tables and views. See COMMENT on table function return columns for more details. | 1.1 | Base | SF99951 Level 3 SF99950 Level 3 | SF99668 Level 21 SF99704 Level 23 |
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.
DB2-MIRROR version group
| Version name | Description | Active version | IBM i 7.6 | IBM i 7.5 | IBM i 7.4 |
|---|---|---|---|---|---|
| COMPARE-SERVICES | Internal maintenance for Db2 Mirror to enable features related to MIRROR_COMPARE_LIBRARY, MIRROR_COMPARE_NODE, or MIRROR_COMPARE_OBJECT services. | 1.4 | Base | SF99951 Level 7 SF99950 Level 8 | SF99668 Level 25 SF99704 Level 29 |
| 1.3 | - | SF99951 Level 6 SF99950 Level 7 | SF99668 Level 24 SF99704 Level 28 | ||
| 1.2 | - | SF99951 Level 5 SF99950 Level 5 | SF99668 Level 23 SF99704 Level 26 | ||
| HEALTH-MONITOR | Enhancements for the health center as it monitors for issues in the Db2 Mirror environment. | 1.2 | Base | SF99951 Level 5 SF99950 Level 5 | SF99668 Level 23 SF99704 Level 26 |
| 1.1 | - | SF99951 Level 4 SF99950 Level 4 | SF99668 Level 22 SF99704 Level 25 | ||
| RECLONE-OBJECT | Enhancements for Db2 Mirror to enable features related to the RECLONE_OBJECT service. | 1.1 | Base | Not Supported | Not Supported |
| RESYNC | Enhancements for Db2 Mirror Resync to enable features related to resynchronization processing for changes to Db2 Mirror replication eligible objects. | 1.1 | Base | SF99951 Level 7 SF99950 Level 8 | SF99668 Level 25 SF99704 Level 29 |
| SECURITY-INTERNAL-MAINTENANCE | Internal maintenance for Db2 Mirror to enable features related to Security. | 1.1 | Base | SF99951 Level 8 SF99950 Level 9 | SF99668 Level 26 SF99704 Level 30 |
| SOFTWARE‑RECLONE | Enhancements for Db2 Mirror software reclone where only the replicated objects are copied from the source of the reclone to the target. | 2.1 | Base | Base | SF99668 Level 19 SF99704 Level 20 |
| SYSTEM-MIGRATION-UTILITY | Enhancements for IBM i Migrate While Active to enable features related to migrating an IBM i partition. | 1.3 | SF99961 Level 3 SF99960 Level 3 | SF99951 Level 11 SF99950 Level 12 | SF99668 Level 29 SF99704 Level 33 |
| 1.2 | SF99961 Level 2 SF99960 Level 2 | SF99951 Level 10 SF99950 Level 11 | SF99668 Level 28 SF99704 Level 32 | ||
| 1.1 | Base | SF99951 Level 7 SF99950 Level 8 | SF99668 Level 25 SF99704 Level 29 |
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.
MRDB version group
| Version name | Description | Active version | IBM i 7.6 | IBM i 7.5 | IBM i 7.4 |
|---|---|---|---|---|---|
| RCL-INTERNAL-MAINTENANCE | Internal maintenance for Db2 Mirror to enable features related to the Replication Criteria List (RCL). | 1.2 | SF99961 Level 2 SF99960 Level 3 | SF99951 Level 10 SF99950 Level 11 | SF99668 Level 28 SF99704 Level 32 |
| 1.1 | Base | SF99951 Level 6 SF99950 Level 7 | SF99668 Level 24 SF99704 Level 28 | ||
| RESUME‑INTERNAL‑MAINTENANCE | Internal maintenance for Db2 Mirror to enable features related to resuming replication. | 1.2 | Base | SF99951 Level 5 SF99950 Level 5 | SF99668 Level 23 SF99704 Level 26 |
| 1.1 | - | SF99951 Level 3 SF99950 Level 3 | SF99668 Level 21 SF99704 Level 23 |
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.
Related Information
Was this topic helpful?
Document Information
Modified date:
14 July 2026
UID
ibm16839205