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}][,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 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 fully-qualified name of the library that contains the transaction manager's
ax_reg and
ax_unreg functions. Must be set to
casaxlib or
casaxlib64 for 64-bit applications.
- 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 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, BATCHONLY,
LOCALTX, ISOLEVEL, ESLOGGING, and PACKAGEPATH
- See
SQL xa_open string Configuration Options for details.