16.20 - Manual In-Doubt Resolution - Teradata Tools and Utilities

Teradata® Call-Level Interface Version 2 Reference for Mainframe-Attached Systems

prodname
Teradata Tools and Utilities
vrm_release
16.20
created_date
September 2019
category
Programming Reference
featnum
B035-2417-108K

When automatic in-doubt resolution is unavailable or unsuccessful, it may be necessary to manually resolve the in-doubt sessions. This is because the in-doubt sessions could be holding locks on database objects that block the progress of other work that is executing against that Teradata Database.

Incorrect use of manual in-doubt resolution can damage Teradata Database.
You can use any of the following interfaces to accomplish manual in-doubt resolution:
  • The TDP commands DISPLAY INDOUBT, COMMIT, and ROLLBACK
  • The TPCCONS utility on the operator‘s console
  • A CLIv2 program to log on to the Resolver Base Module (RBM) with the CLIv2 Run parcel and resolving the sessions using the TPCCONS commands
  • Using CLIv2 applications to issue TDP commands using the CMD function (for more information on the CMD function, see DBCHCL.

For more information on Two-phase commit in-doubt resolution, see the following documents:

  • IBM CICS Interface for Teradata® Reference, B035-2448
  • IBM IMS/DC Interface for Teradata® Reference, (B035-2447)
  • IBM Database 2 V1 R1-CICS/VS Interface Guide, document number GG24-1632-00, from IBM
  • IBM Database 2 V1 R1-IMS/VS Interface Guide, document number GG24-1637-00, from IBM