IBM DB2 xa_open string

To complete the definition of an IBM DB2 XAR, add the following values to the Open string field. Enclose values containing spaces in double quotes.

DB=name,UID=identifier,PWD=password,AXLIB=casaxlib
   [,SREG={T|F}][,TCTX={TRUE|FALSE}][,USERP={T|F}][,LNAME={T|F}][,BATCHONLY={T|F}]
   [,LOCALTX={T|F}][,ISOLEVEL={CR|RR|SZ|UR}][,ESLOGGING=0001]
   [,PACKAGEPATH=schema1[+schema2+...schemaN]]

Note: The open string format is defined by IBM. We strongly recommend that you become familiar with all of the available options by reviewing the DB2 Administration Guide and the Application Programmer's Guide in your IBM documentation. Example settings are shown in this topic for guidance only.

The parameters are:

DB

The name of your DB2 database.

UID

The user ID required to connect to the DB2 server.

PWD

The password required to connect the user ID to the DB2 Server. Required.

AXLIB

The name of the library that contains the transaction manager's ax_reg and ax_unreg functions.

For Windows:: If the %PATH% environment variable includes the directory that contains the axlib library, set AXLIB to CASAXLIB.dll.
If the %PATH% environment variable does not include the directory that contains the axlib library, set AXLIB to include the absolute path of the axlib library. For example, set AXLIB to either %COBDIR%\bin\CASAXLIB.dll (32bit) or %COBDIR%\bin64\CASAXLIB.dll (64bit).

Note: In all cases, specification of the .dll file extension is optional.
For UNIX:: If the $LD_LIBRARY_PATH or $LIBPATH environment variable includes the directory that contains the axlib library, set AXLIB to either casaxlib.so or casaxlib64.so.
If the $LD_LIBRARY_PATH or $LIBPATH environment variable does not include the directory that contains the axlib library, set AXLIB to include the absolute path of the axlib library. For example, set AXLIB to either $COBDIR/lib/casaxlib.so (32bit) or $COBDIR/lib/casaxlib64.so (64bit).

Note: In all cases, specification of the .so file extension is required.

SREG

Static Registration flag (optional). To register the XA switch module statically, you must set SREG=T. Set SREG=F or do not specify SREG to omit static registration (Default).

TCTX

Specifies whether or not the transaction should use a trusted connection. Set this to TRUE to instruct transaction manager to attempt to open a trusted connection. Set this to FALSE to omit the instruction (Default).

Important: If you are configuring your XAR for user impersonation (setting UserP=T), you must also add TCTX=TRUE to the Open string field.

USERP, LNAME, BATCHONLY, LOCALTX, ISOLEVEL, ESLOGGING, and PACKAGEPATH

See SQL xa_open string Configuration Options for details.