In-Doubt Session Resolution - Teradata Director Program

Teradata® Director Program Reference - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Director Program
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-11-17
dita:mapPath
cki1641301536147.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
frc1470439950465
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.