2PL Doubt

Question

T1: W(X), T2: R(Y), T1: R(Y), T2: R(X)

does 2PL protocol allows it?
 

T1	T2
L-X(X) W(X) L-S(Y) R(Y) U(X)	L-S(Y) R(Y) L-S(X) R(X)

here T2 is granted lock on X as T1 enters shrinking phase as no exclusive locks are held on X
is my solution correct?

Answer 1

I think you're correct because the growing and shrinking phase is for transaction and not for the schedule. T2 will grant lock because T2 is not in shrinking phase, T1 is in shrinking phase.

hope you understood.correct me if i am wrong.

Comments

yes