ROLLBACK - Teradata Director Program

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 Teradata Database.

The LHID parameter replaces the deprecated HOST parameter.

Completion Message 1

TDP0420 ALL IN-DOUBT SESSIONS FOR COORDINATOR TERCICS ROLLED BACK

Completion Message 2

TDP0403 SESSION 3253 ROLLED BACK