Manual In-Doubt Resolution - Call-Level Interface Version 2

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

Product
Call-Level Interface Version 2
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
dita:id
B035-2417
lifecycle
previous
Product Category
Teradata Tools and Utilities

Manual In‑Doubt Resolution

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.

Notice:

Incorrect use of manual in‑doubt resolution can damage the 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” on page 252.
  • For more information on 2PC in‑doubt resolution, see the following documents:

  • IBM CICS Interface for Teradata Reference (B035‑2448)
  • IIBM 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