XDB xa_open string

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

[{SERVER | SRV}=["]server-name["],] [{LOCATION | LOC | DB}=["]location-name["],]
     [{USERID | UID}=["]userid["],] {PASSWORD | PWD}=["]password["]

The parameters are:

server-name

The name of your XDB Server. The default is the value set in the Server Name field of the XDB Client Options dialog box in the Options Utility. Optional.

location-name

Your XDB location. The default is the value set in the Locations field of the XDB Client Options dialog box in the Options Utility. Optional.

Note: If you want to use multiple locations within a singleenterprise server instance with a single XA resource definition, you can omit the location-name from the XA Open string and configure the location to use for that transaction by modifying the XDB Client Options dialog box before each transaction executes. To use this feature, edit the xdb.ini file and add the XDBIniReread variable to the [Client] section as follows:

[CLIENT]
XDBCFG=C:\ProgramData\Micro Focus\Enterprise Developer\mfsql\cfg\
XDBIniReread=Yes

When XDBIniReread=Yes, the switch module rereads the settings in the XDB Client Options dialog box each time it connects.

userid

The user ID required to connect to the XDB server. The default is the value set in the AuthID field of the Options Utility. Optional.

password

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

Note: You can access the Options Utility from Start > All Programs > Micro Focus Enterprise Developer > Data Tools > SQL Option for DB2 > Configuration > Client Options.