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).

The order in which objects are resynchronized is based on their object type and based on whether an object is dependent on another object. The suggested priority will be considered when determining when a specific object will be processed, but it is not an absolute priority. The default priority for objects is the null value which indicates that there is no suggested priority.

SET_RESYNC_PRIORITIES is allowed while entries are currently being resynchronized in the Object Tracking List (OTL). However, the priority will not be taken into account once resync has started processing the OTL entries.

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

For the authority needed to use this procedure, see Authorization.
*EXECUTE authority on the QRECOVERY library.
To add a priority,
- *OBJOPR and *ADD authority on QRECOVERY/QADBRSYSTS.
To remove a priority,
- *OBJOPR and *DLT authority on QRECOVERY/QADBRSYSTS.
To change a priority,
- *OBJOPR and *UPD authority on QRECOVERY/QADBRSYSTS.

The schema is QSYS2.

system-object-schema

A character or graphic string that identifies the library for the specified priority. It must be a system schema name.

system-object-name

A character or graphic string that identifies the object for the specified priority. It must be a system object name.

The special value of *ALL can be used to specify a priority for all objects with the specified schema name and object type.

system-object-type

A character or graphic string that identifies the system object type of the object for the specified priority.

The supported object types are: *DTAARA, *FILE, *JOBD, *JOBQ, *OUTQ, *PGM, *SQLPKG, *SQLUDT, *SQLXSR, and *SRVPGM.

The special value of *ALL can be used to specify a priority for all supported object types with the specified schema and object name. If *ALL is specified for system-object-type, *ALL must also be specified for system-object-name.

resync-priority

A non-negative integer value that specifies the resynchronization priority for the specified schema, object, and object type. The highest priority is 0. The lowest priority is the null value. If the specified resync-priority is the null value, any existing priority for the specified schema, object, and object type is removed.

Examples

Set the suggested priority for all objects in schema SALESLIB to 1 so that objects in SALESLIB are considered for resynchronization before most other objects.
```
   CALL QSYS2.SET_RESYNC_PRIORITIES('SALESLIB', '*ALL', '*ALL', 1);
```
Set the suggested priority for table SALES in schema SALESLIB to 0 so that it is considered for resynchronization before the other objects in SALESLIB.
```
   CALL QSYS2.SET_RESYNC_PRIORITIES('SALESLIB', 'SALES', '*FILE', 0);
```

Remove the suggested priority for table SALES in schema SALESLIB.

   CALL QSYS2.SET_RESYNC_PRIORITIES('SALESLIB', 'SALES', '*FILE', NULL);

¹ For each iASP, the QADBRSYSTS table exists in library QRCYnnnnnn; the authorization rules apply to these tables as well.