skip to main content
Part 2: The 32-Bit/64-Bit Drivers : The Sybase Wire Protocol Driver : Connection Option Descriptions : Tightly Coupled Distributed Transactions
  
Tightly Coupled Distributed Transactions
Attribute
TightlyCoupledDistributedTransactions (TCDT)
Purpose
Sybase 12 or higher server only. 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)
GUI Tab
Advanced tab