MX Release 3.2.1 (H06.26+, J06.15+)

matching data source is not available on the server, client applications use the default server-side

data source, TDM_Default_DataSource, to connect to the database. In this case, default values

cannot be changed using NSM/web.

For information on managing data sources using MACL, see the SQL/MX Connectivity Service

Administrative Command Reference manual.

Managing data sources

Only user ID’s with MXCS OPERATOR permission can perform MXCS management tasks. See

“Operation Access Controls” (page 15) for information about MXCS permissions.

Displaying Data Source Status

1. Using NSM/web, click MXCS Services.

2. Click the Data Source Status tab.

For more information about a screen, click Help.

Creating and Configuring Server Data Sources

You can modify the configuration of a data source while the data source is running.

You must use a user ID that has OPERATOR permission to perform management tasks.

1. Using NSM/web, right-click Data Source Configurations.

2. Click Create New Data Source to start the data source wizard.

3. Fill out each screen displayed by the wizard.

If you have questions about a screen, click Help.

Configuring MXCS XA Data Source

For XA transactions, do not use the default data source. You must create one or more data sources

with the following configurations and use the JDBC serverDataSource property to refer to them.

1. Use NSM/Web or MXCI to create a data source that has to participate in distributed (XA)

transactions. Consider that the XADS data source is created.

2. Log on as the super ID to the NonStop server where you want to configure the server side

data source.

3. Start MXCI.

4. At the MXCI prompt, run the following commands:

a. set schema NONSTOP_SQLMX_machine_name.MXCS_SCHEMA;

where, machine_name is the NonStop operating system server.

For example: For a machine \HPIDMR4, the command is:

set schema NONSTOP_SQLMX_HPIDMR4.MXCS_SCHEMA;

b. select * from name2id;

This command is used to find the ID associated with your data source, XADS, created in

Step 1.

For example, the output of the command is:

LAST_UPDATEDOBJ_NAMEOBJ_TYPEOBJ_ID

?TDM_Default_ODBCService11

?TDM_Default_DataSource22

2007-01-24XADS23

11:05:26.846

563

28 Starting, Configuring, and Managing MXCS