MX 2.x)

Starting, Configuring, and Managing MXCS

HP NonStop SQL/MX Connectivity Service Manual—524944-008

3-28

Configuring MFC

2. Configure a data source for the user-specified MXOAS service:

add ds $MXOAS.”MCBS_datasource”;

3. Stop the data source:

stop ds “MCBS_datasource”, reason ‘test’;

4. Add the statement_module_caching attribute to the data source to enable the

module file caching feature:

add evar $MXOAS.”MCBS_datasource”.statement_module_caching,

type set, value ‘true’;

This attribute has only two values, true and false. By default, this attribute is not

enabled.

To set the attribute using NSM/web:

•

In the NSM/web SET tab for the data source, set the

statement_module_caching attribute to true.

5. Add the compiled_module_location attribute to the data source:

add evar $MXOAS.”MCBS_datasource”.compiled_module_location,

type set, value ‘default’;

add evar $MXOAS.”MCBS_datasource”.compiled_module_location,

type set, value ‘/usr/MCBS_modules’;

If the ‘default’ value is specified then, compiled_module_location directory that

is set would be /usr/tandem/sqlmx/TEMPMODULES

To set the attributes using NSM/web:

•

In the NSM/web SET tab for the data source, set the

compiled_module_location attribute to default.

•

In the NSM/web SET tab for the data source, set the

compiled_module_location attribute to /usr/temp.

For more information on using NSM/web to change settings, see Reconfiguring

Server Data Sources on page 3-4.

The directory location specified in the compiled_module_location attribute

includes the following files:

1. The compiled module plans.

Note. For instructions to add a data source, see the SQL/MX Connectivity Service

Administrative Command Reference manual.

Note. Perform step 3 only if the configured data source is in the started state.