Enabling XA support for a Sysplex in non-Java clients

XA support for a Db2 for z/OS Sysplex can be enabled implicitly either by WLB being enabled or Microsoft Distributed Transaction Coordinator or Microsoft Component Services (COM+) being used for instance-less clients. To explicitly enable XA support for clients that access a Db2 for z/OS Sysplex, you either specify settings in the db2dsdriver configuration file or use the SINGLE_PROCESS parameter in the xa_open string.

Before you begin

A Db2 Connect license is required to access a Db2 for z/OS Sysplex.

The listed clients provide XA support for applications that access the sysplex:
  • IBM Data Server Client
  • IBM Data Server Runtime Client
  • IBM Data Server Driver Package
  • IBM Data Server Driver for ODBC and CLI

About this task

This task describes how to explicitly enable XA support for IBM® data server clients and non-Java data server drivers.


Restrictions

XA support is only available for transaction managers that use a single-transport processing model. For more information about this restriction, see the topic about client Sysplex limitations.

Procedure

  1. For instance-based clients (IBM data server clients), specify whether XA support is on (true) or off (false). You can specify the XA support by setting the enableDirectXA parameter in the db2dsdriver configuration file, or by using the SINGLE_PROCESS parameter in the xa_open string.
  2. For instance-less clients, (IBM data server drivers), XA support is enabled by default for Microsoft Distributed Transaction Coordinator or Microsoft Component Services (COM+). For all other supported transaction managers, specify whether XA support is enabled by setting the SINGLE_PROCESS keyword in the xa_open string. Settings for enableDirectXA in the db2dsdriver configuration file are not applicable to instance-less clients.

Results

If XA support is enabled, an application can run a distributed transaction over a single transport within a single application process without going through a middle-tier Db2 Connect server.

Example

Enable single-transport XA support for the database SAMPLE.

<database name="SAMPLE" host="v33ec065.my.domain.com" port="446">
   <!-- database-specific parameters -->
   <!-directXA is disabled by default -->
      <parameter name="enableDirectXA" value="true" />
   </parameters>
</database>