COMMIT - 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

Commits a single Two-phase commit in-doubt session or all Two-phase commit in-doubt sessions for a specified coordinator.

Syntax



where:

ALL
Specifies that all in-doubt sessions for the coordinator are to be committed.
SESSION
Specifies that only one session is to be committed.
number
Number of the in-doubt session to be committed.
name
Coordinator name in alphanumeric characters.
In z/OS, the coordinator name is either:
  • The CICS VTAM application name, or
  • The IMS system id
id
(Optional) Logical-host id, a decimal number.
The default is host id of the current TDP.

Usage Notes

The COMMIT command includes a LOGOFF action by default. The result of this command is recorded in the InDoubtResLog on the Teradata Database.

The LHID parameter replaces the deprecated HOST parameter.

Example 1: COMMIT

COMMIT ALL COORD IMS

Completion Message 1

TDP0419 ALL IN-DOUBT SESSIONS FOR COORDINATOR IMS COMMITTED

Example 2: COMMIT

COMMIT SESSION 4321 COORD CICSS2

Completion Message 2

TDP0402 SESSION 4321 COMMITTED