CHANGE_RESYNC_ENTRIES procedure

The CHANGE_RESYNC_ENTRIES procedure deletes or defers entries in the Object Tracking List (OTL).

If no arguments are specified, all historical and error entries are removed from the tracking table. Otherwise, entries for the specified objects are removed or modified in the OTL according to the resync-entries parameter value. If no entries for the specified object exist, an error is returned. Entries can be examined with the QSYS2.RESYNC_STATUS view. Historical entries have a RESYNC_ENDTIME column value that is not null. Error entries have a FAILURE_MESSAGE column value that is not null.

CHANGE_RESYNC_ENTRIES is not allowed while entries are currently being resynchronized in the OTL.

Authorization: The privileges held by the authorization ID of the statement must include the following1:

  • For the authority needed to use this procedure, see Authorization.
  • Authorization to the QIBM_DB2_MIRROR function usage identifier.
  • *EXECUTE authority on the QRECOVERY library.
  • To remove a historical or error entry,
    • *OBJOPR and *DLT authority on QRECOVERY/QADBRSYSTS.
  • To defer an entry that is not a historical or error entry,
    • *OBJOPR and *UPD authority on QRECOVERY/QADBRSYSTS.
Read syntax diagramSkip visual syntax diagram CHANGE_RESYNC_ENTRIES ( SYSTEM_OBJECT_SCHEMA => system-object-schema,SYSTEM_OBJECT_NAME => system-object-name,SYSTEM_OBJECT_TYPE => system-object-type,RESYNC_NUMBER => resync-number,RESYNC_ENTRIES => resync-entries )

The schema is QSYS2.

system-object-schema
A character or graphic string that identifies the library containing the objects whose entries will be removed or modified. It must be a system schema name.

The special value of *ALL can be used to indicate all objects in any schema. *ALL is the default.

system-object-name
A character or graphic string that identifies the object whose entries will be removed or modified. It must be a system object name.

The special value of *ALL can be used to indicate all objects of any name. *ALL is the default.

system-object-type
A character or graphic string that identifies the object type of the objects whose entries will be removed or modified.

The special value of *ALL can be used to indicate objects of any object type. *ALL is the default.

resync-number
An integer value that identifies the resync number of the entries that will be removed or modified. The resync number must be greater than zero. A null value indicates that entries with any resync number will be changed.
resync-entries
An integer value that indicates which entries that will be removed or modified.
0
Historical entries, resync deferred entries, and non-recoverable error entries are removed. This is the default.
1
Historical entries, resync deferred entries, and all error entries are removed. All other entries will have their RESYNC_DEFERRED column set to the value USER DEFERRED.
Warning: This option should be used with extreme caution as it will potentially cause entries that should be processed to be removed from resynchronization consideration.

Example

Remove all historical and error entries from the OTL.

   CALL QSYS2.CHANGE_RESYNC_ENTRIES( );
1 For each IASP, the QADBRSYSTS table exists in library QRCYnnnnnn; the authorization rules apply to these tables as well.