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