Database Administrator Guide > Database Administrator Guide > Understanding the Locking System > How the Locking System Works > Lock Mode Compatibility
Was this helpful?
Lock Mode Compatibility
The following table shows which Granted lock modes are compatible with the Requested mode:
Granted Mode
Req. Mode
N
IS
IX
S
SIX
U
X
N
Yes
Yes
Yes
Yes
Yes
Yes
Yes
IS
Yes
Yes
Yes
Yes
Yes
No
No
IX
Yes
Yes
Yes
No
No
No
No
S
Yes
Yes
No
Yes
No
No
No
SIX
Yes
Yes
No
No
No
No
No
U
Yes
No
No
Yes
No
No
No
X
Yes
No
No
No
No
No
No
For meaning of the lock mode abbreviations, see Lock Modes.
Last modified date: 01/30/2023