DBMS: SELF DOUBT .

Question

Is basic 2 phase locking always recoverable?

Comments

No , it's not always recoverable .

For an instance let's check this schedule.

T1                  T2

w(a)

                       r(a)

                       w(a)

                       commit;

---failure

This schedule is allowed in Basic 2 phase locking , but this is not a recoverable schedule.

---

Thanks.. :)

Answer 1

yes 2PL locking is always recoverable.

Comments

No it's not.