Mode Values
Possible mode values that can appear in locking displays (for example, in the Convert and Granted fields of the Resource Lock Display) are as following:
S (Shared)
This mode is used when reading.
IS (Intent shared)
For table resource types, this means that there are shared page locks in this table.
Note: This lock strength can be seen on pages if row level locking is used.
X (Exclusive)
This mode is used when writing.
IX (Intent exclusive)
This is same as intent shared, except pages are exclusively locked.
Note: This lock strength can be seen on pages if row level locking is used.
N (Null)
Used to keep a lock without causing locking contention. It is less expensive to convert a lock than to drop and request a new one.
SIX (Shared with intent to update)
This mode is used with Embedded SQL cursors.
Last modified date: 11/09/2022