News
Abstract
This wiki page contains a description of the updates, enhancements, and improvements that have been made to IBM Db2 Mirror for i.
Content
This wiki page contains a description of the enhancements made to IBM Db2 Mirror for i by PTF Group level and year. Instead of listing individual PTFs, updates to Db2 Mirror are denoted by the Db2 Mirror PTF Group level in which the enhancements are enabled.
Use the WRKPTFGRP (Work with PTF Groups) CL command or the QSYS2.GROUP_PTF_INFO view to list the current Db2 Mirror PTF Group level for your node:
SELECT CHAR(PTF_GROUP_NAME, 7) AS GRPPTF, PTF_GROUP_LEVEL
FROM QSYS2.GROUP_PTF_INFO
WHERE PTF_GROUP_NAME IN ('SF99961', 'SF99951', 'SF99668')
AND PTF_GROUP_STATUS = 'INSTALLED'
ORDER BY PTF_GROUP_LEVEL DESC LIMIT 1;
For a complete list of Db2 Mirror updates, enhancements, and improvements, see the What's new section within the IBM i Documentation for each corresponding release:
| IBM i 7.6 PTF Group | IBM i 7.5 PTF Group | IBM i 7.4 PTF Group |
|---|---|---|
| -- | SF99951 - Level 9 | SF99668 - Level 27 |
- [IBM i 7.4 & IBM i 7.5] New RDMA adapters for Power11: Network adapters
- [IBM i 7.4 & IBM i 7.5] Updated software requirements: Software requirements.
| IBM i 7.6 PTF Group | IBM i 7.5 PTF Group | IBM i 7.4 PTF Group |
|---|---|---|
| SF99961 - Level 1 | SF99951 - Level 8 | SF99668 - Level 26 |
- [IBM i 7.6] New process to manually reclone a single replicated object and its replicated dependent objects from one Db2 Mirror node to another: Reclone a single replicated object
- Significantly updated the Db2 Mirror GUI for IBM i Migrate While Active to give a clean, modern look consistent with other GUI's that are part of the IBM i family.
- [IBM i 7.6] Support a mixed release Db2 Mirror environment where the IBM i operating system level on one node is either IBM i 7.4 or IBM i 7.5 and the other node is IBM i 7.6: Mixed release Db2 Mirror environment, Application behavior when running in a mixed release environment, and Best practices for system management
- Updated software requirements: Software requirements.
- Performance improvements:
- Resynchronization of delete, move and rename operations for replication-eligible objects
- New services:
- [IBM i 7.6] RECLONE_OBJECT procedure: RECLONE_OBJECT procedure
- Updated services:
- [IBM i 7.6] AUDIT_JOURNAL_M8 and AUDIT_JOURNAL_M9 table functions have new result columns to reflect additional auditing added in IBM i 7.6: SYSTOOLS.AUDIT_JOURNAL_M8 table function and SYSTOOLS.AUDIT_JOURNAL_M9 table function
| IBM i 7.6 PTF Group | IBM i 7.5 PTF Group | IBM i 7.4 PTF Group |
|---|---|---|
| -- | SF99951 - Level 7 | SF99668 - Level 25 |
- A new product offering named IBM i Migrate While Active builds upon the continuous availability technology of IBM Db2 Mirror for i. Migrate While Active, 5770DBM – Option 2, is a separately licensed program option and it is used independently from 5770DBM – Option 1 Db2 Mirror Enablement. For additional information, see IBM i Migrate While Active
- Performance improvements:
- Resynchronization improvements
- Updated services:
- Compare of objects that are not replication eligible and add new optional OBJECT_TYPE_LIST parameter that identifies the object types to compare for MIRROR_COMPARE_LIBRARY procedure and MIRROR_COMPARE_NODE procedure.
| IBM i 7.6 PTF Group | IBM i 7.5 PTF Group | IBM i 7.4 PTF Group |
|---|---|---|
| -- | SF99951 - Level 6 | SF99668 - Level 24 |
- New RDMA adapters for Power10: Network adapters
- Health Center monitors for DASD attention indicator events against specific IASPs allowing SYSBAS to resume replication: Monitoring Db2 Mirror resources
- Performance improvements:
- Caching replication status results for the Replication Criteria List: Managing the Replication Criteria List
- Resynchronization improvements
- Updated services:
- [IBM i 7.5] Compare the RESTRICT ON DROP attribute for SQL functions, procedures, and tables: MIRROR_COMPARE_LIBRARY procedure, MIRROR_COMPARE_NODE procedure, and MIRROR_COMPARE_OBJECT table function.
| IBM i 7.6 PTF Group | IBM i 7.5 PTF Group | IBM i 7.4 PTF Group |
|---|---|---|
| -- | SF99951 - Level 5 | SF99668 - Level 23 |
- Health Center improvements: Monitoring Db2 Mirror resources
- Jobs preventing IASP vary off: Jobs preventing IASP vary off
- Performance improvements:
- Active replication of some object types
- Resynchronization improvements
- New services:
- Updated services:
| IBM i 7.6 PTF Group | IBM i 7.5 PTF Group | IBM i 7.4 PTF Group |
|---|---|---|
| -- | SF99951 - Level 4 | SF99668 - Level 22 |
- [IBM i 7.4] Automatic takeover of the primary role for unplanned outages: Automatic takeover
- Health Center monitoring of Db2 Mirror resources: Monitoring Db2 Mirror resources
- See the Memorandum To Users (MTU) for details about changes to command line tool db2mtool: Password parameters removed from db2mtool command
- Updated planning considerations for relational database directory entries: Relational database directory entries
- Performance improvements:
- Active replication of some object types
- Resynchronization improvements
- See the Db2 Mirror Performance FAQs for more specific details about Db2 Mirror performance: IBM Db2 Mirror for i: Performance Considerations
- New services:
- Health Center services: CHANGE_MIRROR_HEALTH_MONITOR procedure and MIRROR_HEALTH_MONITOR_INFO view
- Updated services:
- [IBM i 7.4] CHANGE_MIRROR procedure added new optional parameters to enable or disable automatic takeover for unplanned outages and read-only environment: CHANGE_MIRROR procedure
- Usability improvements including increasing the size of output columns and adding starting timestamp and ending timestamp input parameters for MIRROR_DISPLAY_JOURNAL table function
| IBM i 7.6 PTF Group | IBM i 7.5 PTF Group | IBM i 7.4 PTF Group |
|---|---|---|
| -- | SF99951 - Level 3 | SF99668 - Level 21 |
- IFS IASP geographic mirroring support: IFS IASP considerations, Adding IFS IASPs to Db2 Mirror, and Managing IFS IASPs
- Jobs preventing resume: Jobs preventing resume
- New RDMA adapters: Network adapters
- Submitted Job Tracker in a Db2 Mirror environment: Managing the Submitted Job Tracker
- New services:
- MIRROR_SUSPENDING_JOBS table function returns information about jobs preventing resume: MIRROR_SUSPENDING_JOBS table function
- Updated services:
- CHANGE_MIRROR procedure added a new parameter for resume type: CHANGE_MIRROR procedure
- CHECK_MIRROR_VERSION scalar function added a new optional parameter for the entry source of a version identifier: CHECK_MIRROR_VERSION scalar function
- MIRROR_DISPLAY_JOURNAL table function is enhanced with improved formatting of some of the content shown in the ACTION and DETAIL columns, to better align with the Db2 Mirror audit journal entry services: MIRROR_DISPLAY_JOURNAL table function
- RECLONE_REPLICATED_OBJECTS procedure added a new parameter for resume type: RECLONE_REPLICATED_OBJECTS procedure
| IBM i 7.6 PTF Group | IBM i 7.5 PTF Group | IBM i 7.4 PTF Group |
|---|---|---|
| -- | SF99951 - Level 1 | SF99668 - Level 19 |
- [IBM i 7.5] Automatic takeover of the primary role for unplanned outages: Automatic takeover
- [IBM i 7.5] Configure Db2 Mirror to restrict changes to replicated objects on the secondary node: Db2 Mirror - active/read-only and Application behavior on the read-only node
- [IBM i 7.5] Support Db2 Mirror nodes running on different IBM i operating system levels: Mixed release Db2 Mirror environment, Application behavior when running in a mixed release environment, and Best practices for system management
- Support versioning for Db2 Mirror nodes running on different software product levels.
- Updated Db2 Mirror security guidelines and considerations: Security guidelines and Security and auditing
- Updated exit point program considerations: Exit point program considerations
- Updated software requirements: Software requirements
- Updated storage requirements: IBM storage systems requirements
- See the Memorandum To Users (MTU) for details about security related changes for Db2 Mirror. Memo to users: Db2 Mirror (5770-DBM)
- New services:
- Updated services:
- [IBM i 7.5] CHANGE_MIRROR procedure added new optional parameters to enable or disable automatic takeover for unplanned outages and read-only environment: CHANGE_MIRROR procedure
| IBM i 7.6 PTF Group | IBM i 7.5 PTF Group | IBM i 7.4 PTF Group |
|---|---|---|
| -- | -- | SF99668 - Level 16 |
- New RDMA adapters and protocols: Network adapters and RDMA over Converged Ethernet
- ObjectConnect for Db2 Mirror: ObjectConnect for Db2 Mirror
- New services:
- ObjectConnect for Db2 Mirror services: CHANGE_MIRROR_OBJECTCONNECT procedure and MIRROR_OBJECTCONNECT_INFO view
| IBM i 7.6 PTF Group | IBM i 7.5 PTF Group | IBM i 7.4 PTF Group |
|---|---|---|
| -- | -- | SF99668 - Level 12 |
- Product level object replication controls: Object replication controls
- Replication of entries in a data queue (*DTAQ) object: Data queues
- Replication of user index (*USRIDX) and user space (*USRSPC) objects: User indexes and User spaces
- See the Memorandum To Users (MTU) for more details about the Db2 Mirror enhancements to object replication. Memo to users: Db2 Mirror (5770-DBM)
- Performance improvements:
- Db2 Mirror Performance FAQs introduced for specific details about Db2 Mirror performance. IBM Db2 Mirror for i: Performance Considerations
- Updated services:
- CHANGE_MIRROR procedure added new parameters to enable or disable replication for user index (*USRIDX) objects, user space (*USRSPC) objects and entries in a data queue (*DTAQ) object: CHANGE_MIRROR procedure
| IBM i 7.6 PTF Group | IBM i 7.5 PTF Group | IBM i 7.4 PTF Group |
|---|---|---|
| -- | -- | SF99668 - Level 8 |
- New process to reclone the replicated objects from one Db2 Mirror node to another: Software reclone
- Support automatic switchback for takeover IP address groups: Managing takeover IP address groups
- New services:
- CHANGE_MIRROR_TAKEOVER_GROUP procedure changes existing takeover IP address groups: CHANGE_MIRROR_TAKEOVER_GROUP procedure
- Software reclone services: CONFIRM_RECLONED_LIBRARY_DIFFERENCES table function, CONFIRM_RECLONE_SECURITY_OBJECTS view, EVALUATE_RECLONE_JOURNALED_OBJECTS table function, EVALUATE_RECLONE_RELATED_OBJECTS table function, EVALUATE_RECLONE_REPLICATION_CRITERIA table function, and RECLONE_REPLICATED_OBJECTS procedure
- Updated services:
- CREATE_MIRROR_TAKEOVER_GROUP procedure added a new optional parameter for automatic switchback: CREATE_MIRROR_TAKEOVER_GROUP procedure
| IBM i 7.6 PTF Group | IBM i 7.5 PTF Group | IBM i 7.4 PTF Group |
|---|---|---|
| -- | -- | SF99668 - Level 7 |
- Configuring Db2 Mirror on systems using internal storage: Manual storage cloning considerations and Cloning SYSBAS using save and restore
- Support takeover IP address groups: Managing takeover IP address groups
- New services:
Related Information
[{"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"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.4.0;7.5.0;7.6.0;and future releases"},{"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;7.5.0;7.6.0"}]
Was this topic helpful?
Document Information
Modified date:
08 July 2025
UID
ibm17231422