VoteTerm - Teradata Director Program

Teradata® Director Program Reference

Product
Teradata Director Program
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-11
dita:mapPath
xuf1527114222341.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2416
lifecycle
previous
Product Category
Teradata Tools and Utilities

Purpose

Requests a vote-and-terminate action in a Two-phase commit session.

The VoteTerm parcel either 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).

Usage Notes

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 Two-phase commit mode.

    The error code in the Failure parcel indicates why the Teradata Database could not commit the transaction.

Parcel Data

Field information applies for the VoteTerm parcel as follows:

Flavor Parcel BodyLength Parcel Body Fields
116 0 none