Chapter 12, Problem 11RQ

Explanation of Solution

Two-phase commit protocol:

The two-phase commit protocol is used to make sure that the transaction atomicity and database consistency in addition to integrity in distributed transaction.

The need of this protocol helps to make sure that the database changes form remote site is coincided. If not, each and every transaction is undone to sustain a consistent database.

There are two phases in two-phase commit protocol. They are,

• Preparation
• The final COMMIT

Phase 1: Preparation

• The coordinator transfers the message from PREPARE TO COMMIT to all subordinates...