SQL/MX Connectivity Service Manual (SQL/MX 3.x)

Starting, Configuring, and Managing MXCS
HP NonStop SQL/MX Connectivity Service Manual—640327-001
3-5
Configuring MXCS XA Data Source
The XADS data source is assigned the value ‘3’ in the above table.
c. Set the following Control Query Default (CQD) to access and modify the
ENVIRONMENTVALUES table:
a. Control Query Default ODBC_METADATA_PROCESS 'ON';
b. Insert the XA definition of the XADS data source that is created in Step 1.
Insert the following parameters in the ENVIRONMENTVALUES table:
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 transactions -LVL debug level]
VARIABLE_VALUE allows the command-line arguments to start the XA
Broker product. The 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 transactions = 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,
VARIABLE_SEQUENCE,VARIABLE_TYPE,VARIABLE_VALUE)
values(3,0,7, '-XABRK
XABR -DMBRK_TEST_XABR -PATH /G/system/ZXABRKR -CONN 100
-TRANS 10 -LVL 0');
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.846
563