News
Abstract
Db2 Mirror Services (SQL)
Content
This table lists for each Db2 Mirror service, the Db2 for i PTF Group levels and the earliest possible release where a version of the service is available. The values shown in this table are closely related to the values returned by the QSYS2.SERVICES_INFO table for the MIRROR-COMMUNICATION, MIRROR-PRODUCT, MIRROR-RECLONE, MIRROR-REPLICATION, MIRROR-RESYNCHRONIZATION, and MIRROR-SERVICEABILY service categories.
To list all Db2 Mirror services contained in the QSYS2.SERVICES_INFO table:
SELECT SERVICE_CATEGORY, SERVICE_NAME, SQL_OBJECT_TYPE,
LATEST_DB2_GROUP_LEVEL, INITIAL_DB2_GROUP_LEVEL,
EARLIEST_POSSIBLE_RELEASE
FROM QSYS2.SERVICES_INFO
WHERE SERVICE_CATEGORY IN ('MIRROR-COMMUNICATION',
'MIRROR-PRODUCT',
'MIRROR-RECLONE',
'MIRROR-REPLICATION',
'MIRROR-RESYNCHRONIZATION',
'MIRROR-SERVICEABILY')
ORDER BY SERVICE_CATEGORY, SERVICE_NAME;
Quick links to individual service categories:
These services can be used to configure and review details for Db2 Mirror Network Redundancy Groups (NRGs) and Remote Direct Memory Access (RDMA) connections.
| Service name | Type of service | IBM i 7.5 | IBM i 7.4 |
|---|---|---|---|
| QSYS2.ADD_NRG_LINK() | Procedure | Base Enhanced | Base Enhanced: SF99704 Level 17 |
| QSYS2.CHANGE_NRG() | Procedure | Base | Base |
| QSYS2.CHANGE_NRG_LINK() | Procedure | Base Enhanced | Base Enhanced: SF99704 Level 17 |
| QSYS2.NRG_INFO | View | Base | Base |
| QSYS2.NRG_LINK_INFO | View | Base Enhanced | Base Enhanced: SF99704 Level 17 |
| QSYS2.RDMA_CONNECTION_INFO | View | Base | Base |
| QSYS2.RDMA_LINK_INFO | View | Base Enhanced | Base Enhanced: SF99704 Level 17 |
| QSYS2.REMOVE_NRG_LINK() | Procedure | Base | Base |
NOTE: A PTF of Base indicates that the service is available in the base release. Base Enhanced indicates that the service was enhanced in the base release without any additional PTFs.
These services can be used to configure and review details for the Db2 Mirror product configuration.
| Service name | Type of service | IBM i 7.5 | IBM i 7.4 |
|---|---|---|---|
| QSYS2.ADD_MIRROR_IASP() | Procedure | Base | Base |
| QSYS2.ADD_MIRROR_TAKEOVER_ADDRESS() | Procedure | Base | SF99704 Level 7 |
| QSYS2.ADD_MIRROR_VERSION() | Procedure | Base | SF99704 Level 20 |
| QSYS2.CHANGE_MIRROR() | Procedure | Base Enhanced Enhanced: SF99950 Level 3 |
Base Enhanced: SF99704 Level 14 Enhanced: SF99704 Level 17 Enhanced: SF99704 Level 23 Enhanced: SF99704 Level 25 |
| QSYS2.CHANGE_MIRROR_HEALTH_MONITOR() | Procedure | SF99950 Level 4 Enhanced: SF99950 Level 5 |
SF99704 Level 25 Enhanced: SF99704 Level 26 |
| QSYS2.CHANGE_MIRROR_OBJECTCONNECT() | Procedure | Base | SF99704 Level 17 |
| QSYS2.CHANGE_MIRROR_TAKEOVER_GROUP() | Procedure | Base | SF99704 Level 10 |
| QSYS2.CHECK_MIRROR_VERSION() | Scalar function | Base Enhanced: SF99950 Level 3 |
SF99704 Level 20 Enhanced: SF99704 Level 23 |
| QSYS2.COMPARE_MIRROR_VERSION() | Scalar function | SF99950 Level 5 | SF99704 Level 26 |
| QSYS2.CREATE_MIRROR_TAKEOVER_GROUP() | Procedure | Base | SF99704 Level 7 Enhanced: SF99704 Level 10 |
| QSYS2.DELETE_MIRROR_TAKEOVER_GROUP() | Procedure | Base | SF99704 Level 7 |
| QSYS2.MIRROR_CLUSTER_INFO | View | Base | Base |
| QSYS2.MIRROR_HEALTH_MONITOR_INFO | View | SF99950 Level 4 Enhanced: SF99950 Level 5 |
SF99704 Level 25 Enhanced: SF99704 Level 26 |
| QSYS2.MIRROR_INFO | View | Base Enhanced | Base Enhanced: SF99704 Level 14 Enhanced: SF99704 Level 17 Enhanced: SF99704 Level 25 |
| QSYS2.MIRROR_OBJECTCONNECT_INFO | View | Base | SF99704 Level 17 |
| QSYS2.MIRROR_TAKEOVER_INFO | View | Base | SF99704 Level 7 |
| QSYS2.MIRROR_VERSION_LIST | View | Base | SF99704 Level 20 |
| QSYS2.PROCESS_PENDING_MIRROR_VERSION() | Procedure | Base | SF99704 Level 20 |
| QSYS2.REMOVE_MIRROR_IASP() | Procedure | Base | Base |
| QSYS2.REMOVE_MIRROR_TAKEOVER_ADDRESS() | Procedure | Base | SF99704 Level 7 |
| QSYS2.REMOVE_MIRROR_VERSION() | Procedure | Base | SF99704 Level 20 |
| QSYS2.SET_DEFAULT_INCLUSION_STATE() | Procedure | Base | Base |
| QSYS2.SET_MIRROR_CLUSTER() | Procedure | Base | Base |
| QSYS2.SETUP_MIRROR() | Procedure | Base | Base |
| QSYS2.SWAP_MIRROR_ROLES() | Procedure | Base | Base |
| QSYS2.SWAP_MIRROR_TAKEOVER_GROUP() | Procedure | Base | SF99704 Level 7 |
| QSYS2.TERMINATE_MIRROR() | Procedure | Base | Base |
NOTE: A PTF of Base indicates that the service is available in the base release. Base Enhanced indicates that the service was enhanced in the base release without any additional PTFs.
These services can be used to configure and work with serviceability details for Db2 Mirror.
| Service name | Type of service | IBM i 7.5 | IBM i 7.4 |
|---|---|---|---|
| QSYS2.CONFIRM_RECLONED_LIBRARY_DIFFERENCES() | Table function | Base | SF99704 Level 10 |
| QSYS2.CONFIRM_RECLONE_SECURITY_OBJECTS | View | Base | SF99704 Level 10 |
| QSYS2.EVALUATE_RECLONE_JOURNALED_OBJECTS() | Table function | Base | SF99704 Level 10 |
| QSYS2.EVALUATE_RECLONE_RELATED_OBJECTS() | Table function | Base | SF99704 Level 10 |
| QSYS2.EVALUATE_RECLONE_REPLICATION_CRITERIA() | Table function | Base | SF99704 Level 10 |
| QSYS2.RECLONE_REPLICATED_OBJECTS() | Procedure | Base Enhanced: SF99950 Level 3 |
SF99704 Level 10 Enhanced: SF99704 Level 23 |
NOTE: A PTF of Base indicates that the service is available in the base release. Base Enhanced indicates that the service was enhanced in the base release any without any additional PTFs.
These services can be used to configure and review details for Db2 Mirror replication.
| Service name | Type of service | IBM i 7.5 | IBM i 7.4 |
|---|---|---|---|
| QSYS2.ADD_REPLICATION_CRITERIA() | Procedure | Base Enhanced | Base Enhanced: SF99704 Level 20 |
| QSYS2.CHECK_REPLICATION_CRITERIA() | Scalar function | Base | Base |
| QSYS2.EVALUATE_PENDING_REPLICATION_CRITERIA() | Table function | Base Enhanced | Base Enhanced: SF99704 Level 20 |
| QSYS2.INSPECT_REPLICATION_CRITERIA() | Table function | Base Enhanced | Base Enhanced: SF99704 Level 20 |
| QSYS2.PROCESS_PENDING_REPLICATION_CRITERIA() | Procedure | Base Enhanced | Base Enhanced: SF99704 Level 20 |
| QSYS2.REMOVE_REPLICATION_CRITERIA() | Procedure | Base Enhanced | Base Enhanced: SF99704 Level 20 |
| QSYS2.REPLICATION_CRITERIA_INFO | View | Base Enhanced | Base Enhanced: SF99704 Level 20 |
| QSYS2.VALIDATE_PENDING_REPLICATION_CRITERIA() | Table function | Base Enhanced | Base Enhanced: SF99704 Level 20 |
NOTE: A PTF of Base indicates that the service is available in the base release. Base Enhanced indicates that the service was enhanced in the base release without any additional PTFs.
These services can be used to configure and review details for Db2 Mirror resynchronization.
| Service name | Type of service | IBM i 7.5 | IBM i 7.4 |
|---|---|---|---|
| QSYS2.CHANGE_RESYNC_ENTRIES() | Procedure | Base | Base |
| QSYS2.COMPARE_RESYNC_STATUS() | Table function | Base Enhanced | Base Enhanced: SF99704 Level 14 |
| QSYS2.MIRROR_SUSPENDING_JOBS() | Table function | SF99950 Level 3 Enhanced: SF99950 Level 5 |
SF99704 Level 23 Enhanced: SF99704 Level 26 |
| QSYS2.RESYNC_STATUS | View | Base | Base |
| QSYS2.SET_RESYNC_PRIORITIES() | Procedure | Base | Base |
NOTE: A PTF of Base indicates that the service is available in the base release. Base Enhanced indicates that the service was enhanced in the base release without any additional PTFs.
These services can be used to configure and work with serviceability details for Db2 Mirror.
| Service name | Type of service | IBM i 7.5 | IBM i 7.4 |
|---|---|---|---|
| QSYS2.MIRROR_COMPARE_LIBRARY() | Procedure | Base Enhanced Enhanced: SF99950 Level 5 |
Base Enhanced: SF99704 Level 14 Enhanced: SF99704 Level 20 Enhanced: SF99704 Level 26 |
| QSYS2.MIRROR_COMPARE_NODE() | Procedure | Base Enhanced Enhanced: SF99950 Level 5 |
Base Enhanced: SF99704 Level 14 Enhanced: SF99704 Level 20 Enhanced: SF99704 Level 26 |
| QSYS2.MIRROR_COMPARE_OBJECT() | Table function | Base Enhanced | Base Enhanced: SF99704 Level 14 Enhanced: SF99704 Level 20 |
| QSYS2.MIRROR_DISPLAY_JOURNAL() | Table function | Base Enhanced: SF99950 Level 3 Enhanced: SF99950 Level 4 Enhanced: SF99950 Level 5 |
Base Enhanced: SF99704 Level 23 Enhanced: SF99704 Level 25 Enhanced: SF99704 Level 26 |
| QSYS2.MIRROR_FLIGHT_RECORDER_INFO | View | Base Enhanced: SF99950 Level 4 Enhanced: SF99950 Level 5 |
Base Enhanced: SF99704 Level 25 Enhanced: SF99704 Level 26 |
| QSYS2.SET_MIRROR_FLIGHT_RECORDER_ALL_LEVELS() | Procedure | Base | Base |
| QSYS2.SET_MIRROR_FLIGHT_RECORDER_INFO() | Procedure | Base Enhanced: SF99950 Level 4 Enhanced: SF99950 Level 5 |
Base Enhanced: SF99704 Level 25 Enhanced: SF99704 Level 26 |
NOTE: A PTF of Base indicates that the service is available in the base release. Base Enhanced indicates that the service was enhanced in the base release without any additional PTFs.
The documentation for these services can be found here: Db2 Mirror Services
Was this topic helpful?
Document Information
Modified date:
10 October 2023
UID
ibm16829119