ROLLBACK - Teradata Director Program

Teradata® Director Program Reference
Product
Teradata Director Program
Release Number
17.10
Published
October 2021
ft:locale
en-US
ft:lastEdition
2021-11-02
dita:mapPath
bvb1608578422774.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2416
Product Category
Teradata Tools and Utilities

Purpose

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

Syntax



where:

ALL
Specification that all in-doubt sessions for the coordinator are to be rolled back.
SESSION
Specification that only one session is to be rolled back.
number
Number of the in-doubt session to be rolled back.
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 the host id of the current TDP.

Usage Notes

The ROLLBACK command includes a LOGOFF action by default. The result of this command is recorded in the InDoubtResLog on the database.

The LHID parameter replaces the deprecated HOST parameter.

Example 1: ROLLBACK

ROLLBACK ALL COORD TERCICS

Completion Message 1

TDP0420 ALL IN-DOUBT SESSIONS FOR COORDINATOR TERCICS ROLLED BACK

Example 2: ROLLBACK

ROLLBACK SESSION 3253 COORD IMS

Completion Message 2

TDP0403 SESSION 3253 ROLLED BACK