|< < 18 > >|

Strict Two-Phase Locking

Strict

Strict 2PL holds all locks until the end of commit processing.

If locks are released before the commit, serializability can be lost.

T1	T2
X(A)
R(A)
W(A)
	X(A)
X(B)
R(B)
W(B)
U(B)
U(A)
	X(B)
	R(A)
	W(A)
	R(B)
ABORT
	W(B)
	U(B)
	U(A)
	commit

|< < 18 > >|