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: 08/14/2024
This site works best with JavaScript enabled