Serviceability services

These services can be used to configure and work with serviceability details for Db2® Mirror.

MIRROR_COMPARE_LIBRARY procedure
The MIRROR_COMPARE_LIBRARY procedure returns a result table and an optional result set containing one or more rows for the library and for each object in the specified library that is different from the same object on the other node.
MIRROR_COMPARE_NODE procedure
The MIRROR_COMPARE_NODE procedure populates a result table with one or more rows for each object in every library that is different from the same object on the other node. The compares can be made for all libraries in SYSBAS, for all libraries in the current IASP, or for all libraries in SYSBAS and all active IASPs.
MIRROR_COMPARE_OBJECT table function
The MIRROR_COMPARE_OBJECT table function returns differences between the source and target nodes for the object identified by object-type, library-name, and object-name. The object does not need to be a currently replicated object.
MIRROR_DISPLAY_JOURNAL table function
The MIRROR_DISPLAY_JOURNAL table function formats Db2 Mirror specific audit journal entries as well as returning typical audit journal information.
MIRROR_FLIGHT_RECORDER_INFO view
The MIRROR_FLIGHT_RECORDER_INFO view returns a single row of data containing information about the configuration and status of the Db2 Mirror Flight Recorder. The flight recorder contains categories which can be uniquely configured to produce different levels of detail related to on-going Db2 Mirror operations.
SET_MIRROR_FLIGHT_RECORDER_ALL_LEVELS procedure
The SET_MIRROR_FLIGHT_RECORDER_INFO_ALL_LEVELS procedure sets a single level for all logging categories within the Db2 Mirror flight recorder.
SET_MIRROR_FLIGHT_RECORDER_INFO procedure
The SET_MIRROR_FLIGHT_RECORDER_INFO procedure sets values that are used for the Db2 Mirror flight recorder.

Parent topic: Db2 Mirror services