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 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.
For more information on Two-phase commit 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