16.20 - Sync Point Services - Teradata Tools and Utilities

Teradata® Call-Level Interface Version 2 Reference for Mainframe-Attached Systems

Teradata Tools and Utilities
September 2019
Programming Reference

With Two-phase commit, the CICS or IMS applications can access the Teradata Database as a sync point participant. In this way, Teradata Database updates are committed or rolled back through the use of CICS or IMS sync point services. The use of the sync point services guarantees that all updates performed within a logical unit of work will either all commit or all roll back. The Teradata Database and the CICS or IMS Attachment Facilities support the sync point manager and its use of the Two-phase commit protocol. In the Two-phase commit protocol, CICS or IMS act as the coordinator, and the Teradata Databases act as participants.

Two-phase commit applications must use a coordinator such as IMS or CICS. They cannot run as batch applications, unless the application provides its own coordinator.