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.