Resynchronization services

These services allow you to configure and review details for Db2® Mirror resynchronization.

CHANGE_RESYNC_ENTRIES procedure
The CHANGE_RESYNC_ENTRIES procedure deletes or defers entries in the Object Tracking List (OTL).
COMPARE_RESYNC_STATUS table function
The COMPARE_RESYNC_STATUS table function compares the entries in the QSYS2.RESYNC_STATUS views on the primary and secondary nodes and returns any potentially conflicting entries from both nodes. If potentially conflicting entries exist, the user must defer the conflicting entries on the secondary node before resynchronization can be performed. For more information on deferring entries see the QSYS2.CHANGE_RESYNC_ENTRIES procedure.
MIRROR_SUSPENDING_JOBS table function
The MIRROR_SUSPENDING_JOBS table function returns a row for each job with a Db2 Mirror database connection that have not yet completed their suspend processing for a previous suspend request. Allowing Db2 Mirror to resume replication or allowing an IASP to vary off before jobs have completed their suspend processing could cause replicated objects to become out of sync. These jobs may exist on the source node only, on the target node only, or on both nodes.
RESYNC_STATUS view
The RESYNC_STATUS view returns information from the Object Tracking List (OTL).
SET_RESYNC_PRIORITIES procedure
The SET_RESYNC_PRIORITIES procedure sets a suggested priority for one or more objects that should be considered when resynchronization is required in a Db2 Mirror environment. The specified objects do not need to exist. The specified object or group of objects are associated with the current thread's Auxiliary Storage Pool Group (ASPGRP).

Parent topic: Db2 Mirror services