MX 3.x)

Starting, Configuring, and Managing MXCS

HP NonStop SQL/MX Connectivity Service Manual—640327-001

3-4

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. 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.

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: