Conservative 2 phase locking.

Question

Is it Conservative 2 Phase locking (C2PL) ?

T1

LOCK-X (A)
LOCK-S (B)
R(A)
R(B)
W(A)
UNLOCK (A)
COMMIT
UNLOCK (B)

Comments

sir, are you sure that the lock an be released at any point???...m confused over it.....please clear my doubt.

Answer 1

yeah it is conservative cause in conservative u have to acquire all lock before transaction starts,but u acn release it at any time.but it is not strict or rigorous.in strict u can only release shared lock before commit operation,but u cannot release xclusive lock before commit,and in rigorous u cant relaese any lock before comit.