SQL/MX Connectivity Service Manual for SQL/MX Release 3.2 (H06.25+, J06.14+)
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:
1) Control Query Default ODBC_METADATA_PROCESS 'ON';
2) 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 -DM BRK_TEST_XABR -PATH /G/system/ZXABRKR -CONN 100
-TRANS 10 -LVL 0');
For more information on XA transactions, see the XACI Command Reference Manual.
Reconfiguring Server Data Sources
You must use a user ID that has OPERATOR permission to perform management tasks.
1. Using NSM/web, click Data Source Configurations to expand the list of data sources.
2. Click on the data source you want to reconfigure.
3. Click the tab associated with the change you want to make.
Click This TabTo Change This
Control Query DefaultsControl Query Default
Controlled TablesControlled Tables
DefinesDEFINE statement
SetsSET statement
Resource Management PolicyResource management policy
Resource StatisticsResource statistics
General ConfigurationNumber of servers, Performance, and Start options
Process ManagementCPU utilization and process priority
If you have questions about a screen, click Help.
Managing data sources 29










