Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is Two-Phase Commit ?

Answer Posted / syed sohel

The 2PC protocol is so named because it employs the
following two phases prior to committing the operation
performed:

* Phase 1—Prepare. In this phase, each of the programs
involved in the transaction sends a message to the TP
Manager, such as Microsoft Distributed Transaction
Coordinator (MS DTC), informing the TP Manager that it is
ready to and capable of performing its part of the
operation. This phase is also known as prepare because the
programs are prepared either to commit the changes or
rollback the changes. If the TP Manager receives
confirmation from each of the programs involved, it proceeds
to phase 2.
* Phase 2—Commit or Rollback. In this phase, the TP
Manager instructs each of the programs to commit or rollback
all of the changes that were requested as part of the
transaction. A properly executed rollback should return the
system to its original state.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different stages in 'data warehousing'?

965


How do you start a database?

887


What is a candidate key in dbms?

1045


What is the quickest sorting method to use?

1040


Compare a hierarchical and network database model?

969


What is a join in the sql?

981


Describe the difference between homogeneous and heterogeneous distributed database.

1044


What are stand-alone procedures?

940


What is implicit cursor in dbms?

1000


How to detect the server version?

1051


How do you call a stored procedure from jdbc?

931


What do you understand by data redundancy?

910


What is meant by database server?

978


How to activate all indexes in firebird?

1031


What are the three main types of models?

883