Adaptive Server includes these distributed transaction management features:
Improved transaction and thread management. Adaptive Server manages all transactions as server resources, and provides the ability to attach and detach threads from transactions. These new capabilities provide a common interface for supporting clients of local server transactions, as well as clients in X/Open XA and MSDTC environments. See “Configuring transaction resources”.
New distributed transaction coordination services. Adaptive Server provides consistent rollback and commit capabilities for transactions that modify data in remote Adaptive Servers via RPCs and CIS. New transaction coordination services guarantee the integrity of such distributed transactions, even when no external transaction manager is present. See “Using Adaptive Server coordination services”.
Improved recovery for prepared transactions. During recovery, Adaptive Server identifies prepared transactions that were coordinated by the X/Open XA protocol and Adaptive Server native transaction coordination services. Adaptive Server restores these transactions to the condition they were in prior to recovery, and brings the associated database online more quickly than in previous server versions. See “Crash recovery procedures for distributed transactions”.
New dbcc commands for heuristically completing distributed transactions. See “Heuristically completing transactions”.
