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

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

prodname
Call-Level Interface Version 2
vrm_release
15.10
category
Programming Reference
featnum
B035-2417-035K

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 244.
  • 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