JDBC Type 4 Driver 2.0 Programmer's Reference (SQL/MX 2.x)
Configuring MXCS XA Data Source
For XA transactions, do not use the default data source. A new data source, with the following configurations, must be created,
and the JDBC serverDataSource property must be used to refer to this data source.
Use NSM/Web or MXCI to create a data source that has to participate in distributed (XA) transactions. Assuming that
the data source created is XADS.
1.
Logon to the NonStop server where the server side data source has to be configured, as super.super.2.
Start MXCI.3.
At the MXCI prompt, run the command:
Set schema NONSTOP_SQLMX_<machine_name>.MXCS_SCHEMA;
where, machine_name is the NonStop operating system server that is logged.
For example: For a machine \HPIDMR4, the command is,
set schema NONSTOP_SQLMX_HPIDMR4.MXCS_SCHEMA;
a.
Run the command, select * from name2id; to find out the ID associated with your data source, XADS,
created in Step 1.
For example, the output of the command is:
OBJ_ID OBJ_TYPE OBJ_NAME LAST_UPDATED
1 1 TDM_Default_ODBCService ?
2 2 TDM_Default_DataSource ?
3 2 XADS
2007-01-24
11:05:26.846563
The data source, XADS, is assigned the value ‘3’ from the above table.
b.
Set the following control query default to access and modify the ENVIRONMENTVALUES table:
Control Query Default ODBC_METADATA_PROCESS 'ON';i.
Insert the XA definition of the data source XADS that is created in Step 1.
Insert these into ENVIRONMENTVALUES:
ENV_ID: what we got from step a> and b>
VARIABLE_SEQUENCE: 0
VARIABLE_TYPE: 7
VARIABLE_VALUE: -XABRK <XABROKER PROCESS NAME> -DM <DOMAIN NAME> -PATH
<OSS PATH OF THE XABROKER FILE> [-CONN <number of connections> -TRANS
<number of transaction> -LVL <debug level>]
VARIABLE_VALUE allows the command line arguments to start the XA Broker product. The
recommended and default values are:
-XABRK <XABROKER PROCESS NAME> = $XABR
-DM <DOMAIN NAME> = BRK_TEST_XABR
-PATH <OSS PATH OF THE XABROKER FILE> = /G/system/zxabrkr
-CONN <number of connections> = Default 100, Max 1000
-TRANS <number of transaction> = Default 10, Max 100
-LVL <debug level> = Default 0. Valid levels: 0 (Error), 1 (Error and
Info), 2 (Error, Info and Debug)
For example:
Insert into ENVIRONMENTVALUES (ENV_ID,
ii.
c.
4.