Db2 Mirror services

Edit online

There are many SQL services that you can use to work directly with the Db2® Mirror environment. In addition to the details of each service, the authorization details and SQLSTATE values that apply to these services are described in this section.

To see a list of all Db2 Mirror services and the IBM® i Migrate While Active services that work indirectly with the Db2 Mirror environment, you can run this query:

SELECT * FROM QSYS2.SERVICES_INFO
    WHERE SERVICE_CATEGORY IN ('MIRROR-COMMUNICATION', 'MIRROR-PRODUCT',
                               'MIRROR-RECLONE', 'MIRROR-REPLICATION', 
                               'MIRROR-RESYNCHRONIZATION', 'MIRROR-SERVICEABILITY',
                               'MIGRATE WHILE ACTIVE')
    ORDER BY SERVICE_CATEGORY, SERVICE_NAME;