Tightly Coupled Distributed Transactions
- Last Updated: February 7, 2025
- 1 minute read
- DataDirect Connectors
- ODBC
- Documentation
Attribute
TightlyCoupledDistributedTransactions (TCDT)
Purpose
Determines whether the driver ensures that multiple connections within the same distributed transaction obey other’s locks.
Valid Values
0 | 1
Behavior
If set to 1 (Enabled), the driver uses tightly coupled
distributed transactions. Multiple connections within the same distributed transaction obey
other’s locks.
If set to 0 (Disabled), the driver does not use tightly
coupled distributed transactions. Multiple connections within the same distributed
transaction may hang each other because the connections do not obey other’s locks. This
value can provide better performance if concurrency of data is not needed.
Default
1 (Enabled)