In-Doubt Session Resolution - Teradata Director Program

Teradata® Director Program Reference

Product
Teradata Director Program
Release Number
17.10
Published
October 2021
Language
English (United States)
Last Update
2021-11-02
dita:mapPath
bvb1608578422774.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2416
Product Category
Teradata Tools and Utilities

For sessions using 2PC, if a coordinator fails, the database cannot unilaterally decide to commit or roll back the updates. When either the coordinator returns or manual resolution of the in-doubt session becomes necessary, TDP provides facilities to inform the database of the resolution. The TDP AUTHORIZ command is used to allow a coordinator to use the TDP RESOLVE command.

The TDP COMMIT and ROLLBACK commands can be used to perform manual in-doubt resolution. Manual resolution can also be performed from the database using the TPCCONS utility on the RDBMS console. For more information, see Teradata Vantage™ - Database Utilities, B035-1102.

Manual resolution of in-doubt sessions must be done with care. Incorrect manual in-doubt resolution causes a loss of data integrity between the participating databases.