Explain the concept of two phase locking protocol with an example?

dhs01

 Profile Answers by dhs01 Questions by dhs01

• Apr 15th, 2009

Not sure of the particular terminology but 2 phase locking I believe would be similar to 2 phase commit where you must first make sure that everybody involved is ready, able, and willing (phase 1) then the next phase is when it actually happens (phase 2).   

rpeters83

 Profile Answers by rpeters83 Questions by rpeters83

• Dec 9th, 2008

I'm no DB admin but I'll give it a shot. It's a protocol gauranteed to allow serialized actions on a database by having a locking phase and an unlocking phase. Meaning, during locking, no other transactions may be performed on the database until it is unlocked.

Answer Question  Select Best Answer