Start of change


Contains the value that specifies a deadlock resolution priority to use in resolving deadlocks with other threads.

FL 501

DEADLOCK_RESOLUTION_PRIORITY has the following characteristics:
  • It is updatable, with values maintained by the user.
  • The type is SMALLINT.
  • The schema is SYSIBMADM.
  • The scope of this global variable is session.
  • The default value is NULL.
A user with the WRITE privilege on the global variable can use either of the following SET assignment statements to reinitialize DEADLOCK_RESOLUTION_PRIORITY to the default value:

After assigning DEFAULT or NULL to the global variable, a subsequent request for the value of the global variable returns a NULL value.

The acceptable range of values is 0 - 2551. The higher the value, the less likely that lock requests acquired by an application will deadlock when the application is involved in a deadlock situation.

End of change
1 Db2 for z/OS® allows a value of up to 255 for this built-in global variable to help insure that a Db2 for z/OS application can set a higher priority than an IMS application. The parameter on IMS/CICS Transaction Server for z/OS CREATE THREAD is a multiple of the IRLMRWT subsystem parameter value, which also influences deadlock resolution.