The two-phase commit protocol allows applications to coordinate units of work across multiple databases so that the units of work are committed as a single unit of work. Two-phase commit guarantees that either all or none of the participating databases are updated. You can disable the two-phase commit protocol, or enable the TwoPC variable, as described further in the table below.
Value |
Description |
No |
This means you are not using two-phase commit protocols. |
TCP/IP |
Select this value to use the two-phase commit protocol with Microsoft Transaction Server (MTS) and Distributed Transaction Coordinator (DTC). |
XA |
Select this value to use the two-phase commit protocol with XA Distributed Transactions |