160. 2 phase locking (2pl)

[@AmitKhuranaSir]

@14:45 I have done a small mistake I have done U(A) but after that T2 is doing S(B) which is not allowed in 2PL because transaction can't apply lock after unlocking any item..... Hence this schedule is not according to 2PL... But we can make it according to 2PL by adjusting few locks... Here is the image of solution.... drive.google.com/file/d/100V-vp9kfzla21YaapppgxbhWw1TyaYZ/view?usp=drivesdk

[@sahebsarkar8330]

And T3 also have same thing U(B) then X(A) I this also not allowed.

[@AmitKhuranaSir]

@@sahebsarkar8330 yes....

[@alekhyobanerjee2099]

PL @14:45 If we place U(A) below COMMIT in T2 @15:27 If we place U(B) below COMMIT in T3 Then 2 PL allows the transaction, isn't it ?

[@AmitKhuranaSir]

@@alekhyobanerjee2099 ✅ For exact solution refer this link.... drive.google.com/file/d/100V-vp9kfzla21YaapppgxbhWw1TyaYZ/view?usp=drivesdk

[@vinaysingh1971]

sorry to say sir but these small mistakes are so many please likewise this , in other viedeos also rectify these mistakes much love and respect for your contribution 🙌

[@TechS12]

superb, excellent, lucid and upto the point explanation... very well explained... thanks a lot sir.

[@ashishratnawat2711]

Sir at 17:00 how is it in 2pl ? Because in T2 there is Shared lock on B after unlocking A. There is growing shrinking and then growing phase. Isn't it ?

[@AmitKhuranaSir]

yes please refer pinned comment

[@ajitnegi8195]

Good explanation

[@siddhantjha6649]

sir can we study your whole lecture and refer the notes provided in telegram is it enough ???

[@PIYUSHSHARMA-ql3uz]

18:30