Vendor Specifics

How to: Create the XA Configuration File

The implementation specifics for Db2 with CLI on UNIX, Windows, and z/OS are:

• The DB2CLI.INI file must have an entry in the common section

  [COMMON]
  DISABLEMULTITHREAD=1

• Only the global file, DB2CLI.INI, can be used. It must reside in:
  • For UNIX/NT, installation home.
  • For z/OS, exported by DSNAOINI variable.

The implementation specifics for Db2 with CLI on z/OS are:

• Requires RRS
• RRSAF in DB2CLI.INI

The implementation specific of MS SQL Server is:

• Required DTS

Note: If the client and the serve are on different machines, DTS must be installed on both machines.

The implementation specifics of Sybase are:

• The Sybase XA configuration file is needed.
• No bulk load/fast load functionality in XA, no messages are produced, and insert will operate in normal mode.
• Users can create their XA configuration file and point to it in the profile.

ENGINE SQLSYB SET XACONFIGFILE path