Db2 Connect support for loosely coupled transactions

The support within Db2 Connect for loosely coupled transactions is intended for users who implement XA distributed applications that access IBM® Db2® for IBM i Version 5 Release 4 or later; and Db2 for z/OS® Version 7 or later. This support allows different branches of the same global transaction to share lock space on Db2 for z/OS.

Support for loosely coupled transactions is intended for .NET and COM+ applications.

This feature reduces the window where one branch of a distributed transaction encounters lock timeout or deadlock as a result of another branch within the same global transaction.

Restriction: In loosely coupled XA transactions, if there are multiple branches open against the same resource manager an application can encounter lock timeout or a deadlock within global transactions. The lock timeout or deadlock occurs because data sharing members can share locks only if multiple branches within a global transaction connect to the same member. An application might not be able to use workload balancing but it can use client affinity for high availability.