Usage Notes - Director Program

Two-phase commit is available only for Teradata Database for UNIX version 2 release 2 (or later), and for Teradata DBS for TOS version 1 release 5 (or later).

The vote request parcel can be sent alone, or in a message (at the end of a sequence of request and data parcels that define a Teradata SQL statement).

If the vote request is sent in the same message as a Teradata SQL statement, then the request follows the rules for a multi‑statement request; that is, all statements succeed, or all fail.

If your program is using the Initiate with Protocol‑Function with the vote protocol function, then the VoteRequest parcel is included after the request and data parcels.

The response is one of the following:

A Success parcel, indicating that the Teradata Database voted Yes, and that the transaction is now in‑doubt.

A Failure parcel, indicating either that the Teradata Database has voted No and rolled the transaction back, or that the session is not in 2PC mode. The error code in Failure parcel indicates why the Teradata Database did not commit the transaction