Chapter 12. IBM Data Server Driver for JDBC and SQLJ type 4
connectivity JDBC and SQLJ distributed transaction support
The IBM Data Server Driver for JDBC and SQLJ in the z/OS environment supports
distributed transaction management when you use IBM Data Server Driver for
JDBC and SQLJ type 4 connectivity.
This support implements the Java 2 Platform, Enterprise Edition (J2EE) Java
Transaction Service (JTS) and Java Transaction API (JTA) specifications, and
conforms to the X/Open standard for global transactions (Distributed Transaction
Processing: The XA Specification, available from http://www.opengroup.org). IBM
Data Server Driver for JDBC and SQLJ distributed transaction support lets
Enterprise Java Beans (EJBs) and Java servlets that run under WebSphere
Application Server Version 5.01 and above participate in a distributed transaction
system.
JDBC and SQLJ distributed transaction support provides similar function to JDBC
and SQLJ global transaction support. However, JDBC and SQLJ global transaction
support is available with IBM Data Server Driver for JDBC and SQLJ type 2
connectivity on DB2 for z/OS only.
JDBC and SQLJ distributed transaction support is available for connections to DB2
for z/OS, DB2 Database for Linux, UNIX, and Windows, and DB2 for i5/OS
servers.
A distributed transaction system consists of a resource manager, a transaction
manager, and transactional applications. The following table lists the products and
programs in the z/OS environment that provide those components.
Table 99. Components of a distributed transaction system on DB2 for z/OS
Distributed transaction system component Component function provided by
Resource manager DB2 for z/OS or DB2 Database for Linux,
UNIX, and Windows
Transaction manager WebSphere Application Server or another
application server
Transactional applications JDBC or SQLJ applications
Your client application programs that run under the IBM Data Server Driver for
JDBC and SQLJ can use distributed transaction support for connections to DB2 for
z/OS or DB2 Database for Linux, UNIX, and Windows servers. DB2 UDB for
OS/390 and z/OS Version 7 servers do not have native XA mode support, so the
IBM Data Server Driver for JDBC and SQLJ emulates the XA mode support using
the existing DB2 DRDA two-phase commit protocol. This XA mode emulation uses
a DB2 table named SYSIBM.INDOUBT to store information about indoubt
transactions. DB2 uses a package named T4XAIndbtPkg to perform SQL operations
on SYSIBM.INDOUBT.
If your JDBC or SQLJ applications use distributed transactions, and those
applications connect to DB2 UDB for OS/390 and z/OS Version 7 servers, you
need to run the DB2T4XAIndoubtUtil utility at those servers to create the
© Copyright IBM Corp. 1998, 2008 467
|
|
|
|
To Next Page
Loading...
Need help?
General