Interested to Buy Any Domain ? << Click Here >> for more details...
What is Two-Phase Commit ?
- 3 Answers
- 5867 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
Two-phase commit is mechanism that guarantees a
distributed transaction either commits on all involved nodes
or rolls back on all involved nodes to maintain data
consistency across the global distributed database. It has
two phase, a Prepare Phase and a Commit Phase.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Answer / nishi
Two-phase commit is mechanism that guarantees a distributed transaction either commits on all involved nodes or rolls back on all involved nodes to maintain data consistency across the global distributed database. It has two phase, a Prepare Phase and a Commit Phase.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the advantages of dbms?
hi, i am new to database cau give me link where can i get about databse..
how can we restore RMAN backup from SUN O/S to AIX 5.3? is it possible or not?
How do you handle your own transaction?
Is it possible to modify a Datatype of a column when column contains values?
What is big data in database?
What is data model in dbms?
What is maintaining database?
What do you understand by functional dependency and transitive dependency in dbms?
What is the main purpose of triggers in database?
Explain the hierarchical database?
What are the Different Types of Joins and How do They Work?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
