Two Phase Lock(1)

• 2PL:all locking operations precede the first unlock operation Fig 22(20).6-8

• Cascading rollback:Fig 22(20).18

• Unlock too early

• Rigorous 2PL:all locks are unlocked on the end of the transtation

• Strict 2PL:holds all exclusive locks to the end of transtation