Contains the value that specifies a deadlock resolution priority to use in resolving deadlocks with other threads.
- 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.
SET SYSIBMADM.DEADLOCK_RESOLUTION_PRIORITY = DEFAULT;
SET SYSIBMADM.DEADLOCK_RESOLUTION_PRIORITY= NULL;
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.