ROLLBACK - Teradata Director Program

Teradata® Director Program Reference - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Director Program
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-17
dita:mapPath
cki1641301536147.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
frc1470439950465
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