The Two-Phase Commit (2PC) protocol allows an application program to update databases on multiple database management systems, ensuring data consistency on all systems involved. If an application runs in Two-phase commit mode, all the changes in a defined logical unit of work either commit or roll back. In a system set up to support Two-phase commit transactions, there must be a coordinator (such as CICS or IMS) and one or more participants (such as the Teradata server or IBM DB2).
To set up your site to run applications that use Two-phase commit processing, you must customize the following:
- TDPPARM file
- IBM CICS Interface for Teradata (CICS Interface), for sites that use CICS as the coordinator. For more information, see Installing CICS.
- IBM IMS Interface for Teradata (IMS Interface), for sites that use IMS as the coordinator. For more information, see Installing IMS.
For additional background information on the Two-phase commit protocol, see the following documents:
- Teradata Vantage™ - Database Administration, B035-1093
- Teradata Vantage™ - Database Design, B035-1094