Usage Notes - Director Program

Teradata Director Program Reference

Product
Director Program
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2416
lifecycle
previous
Product Category
Teradata Tools and Utilities

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).

If the VoteTerm parcel is used with updates that change existing data, it will always result in a commit.

If an immediate commit is not desired, use the VoteRequest parcel instead of the VoteTerm parcel.

If the VoteTerm parcel is sent in the same message as a Teradata SQL statement, then the vote and terminate request follows the rules for a multi‑statement request (all statements succeed, or all fail).

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

The response is one of the following:

  • A Success parcel indicating that the Teradata Database has committed the transaction
  • A Failure parcel indicating that the Teradata Database has rolled back the transaction or that the session is not in 2PC mode.
  • The error code in the Failure parcel indicates why the Teradata Database could not commit the transaction.