Interested to Buy Any Domain ? << Click Here >> for more details...
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
Is this statement true or false? All databases must be in third normal form?
How to detect applications and users that hold transactions open too long?
How to prevent concurrent access to my data?
What is dbms_output put_line?
for what purpose we use MDM(master data management)tell me plz.
What are the different types of DBMS architecture?
What are the importance of database in banking?
What do you understand by fragmentation?
Explain degree of a relation?
Explain a tp monitor?
What is the concept of sub-query in terms of sql?
How to find the size of database?
Explain the terms database and dbms. Also, mention the different types of dbms.
What is database management system(dbms) and why it is used?
Why do we need database normalization?
