Administration Guide

Chapter 10. Designing for Transaction Managers

You may want to use your databases with an XA-compliant transaction manager if you have resources other than DB2 databases that you want to participate in a two-phase commit transaction. If your transactions only access DB2 databases, you should use the DB2 transaction manager, described in Updating Multiple Databases.

The following topics will assist you in using the database manager with an XA-compliant transaction manager, such as IBM TXSeries CICS, IBM TXSeries Encina, BEA Tuxedo, or Microsoft Transaction Server:

• X/Open Distributed Transaction Processing Model
• Setting Up a Database as a Resource Manager
• xa_open and xa_close Strings Usage
• New xa_open String Format for DB2 Version 7
• TPM and TP_MON_NAME Values
• xa_open String Format for Earlier Versions of DB2
• Updating Host or AS/400 Database Servers
• Database Connection Considerations
• Making a Heuristic Decision
• Security Considerations
• Configuration Considerations
• XA Function Supported
• XA Interface Problem Determination
• Configuring XA Transaction Managers to Use DB2 UDB
• Configuring Microsoft Transaction Server.

If you are using an XA-compliant transaction manager, or are implementing one, more information is available from our technical support web site:

   http://www.ibm.com/software/data/db2/library/

Once there, choose "DB2 Universal Database", then search the web site using the keyword "XA" for the latest available information on XA-compliant transaction managers.