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

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

set would be /usr/tandem/sqlmx/TEMPMODULES

The directory location specified in the compiled_module_location attribute will include

the following files:

a. The compiled module plans.

b. Temporary files such as *.lst,*.sql*.mdf ; all these files are retained in the directory to

enable easy troubleshooting.

NOTE:

• If you assign the compiled_module_location evar to a value other than the

default, such as /usr/temp, ensure that the directory is created before assigning it.

• The created module files are available at the default location or the assigned

compiled_module_location. While upgrading from one version of SQL/MX

to the other, the created module files from the older versions must be deleted and

recreated for the following scenarios:

◦ Upgrading from SQL/MX Release 2.3.x to 3.0 and later releases.

◦ Upgrading from SQL/MX Release 3.0 to 3.1 and later releases.

◦ Upgrading from SQL/MX Release 3.1 to 3.2.

However, while upgrading from SQL/MX Release 3.2 to 3.2.1, you can reuse the

module files.

6. To verify that the values are assigned, enter the following command:

CS>info evar <data source>.*, type set;

The following output appears indicating that the values are assigned:

-- INFO EVAR \DMR15.$VCD9.<data source>.* Report

Sets:

SET STATEMENT_MODULE_CACHING TRUE

SET COMPILED_MODULE_LOCATION default

7. By default, MFC is disabled for SQLExecDirect. However, when you enable MFC for an

application as described from Step 1 to Step 6 of this procedure, MFC for SQLExecDirect

with parameterized queries is enabled and module files are created. To enable MFC for

SQLExecDirect non parameterized queries, configure the following setting:

add evar $R32.RAZ32_MFC.STATEMENT_EXECDIRECT_CACHING, type set, value 'true';

8. Start the data source:

start ds $MXOAS.”MCBS_datasource”;

Configuring MFC using NSM/Web

To configure MFC using NSM/Web:

1. Log on to NSM/Web.

2. Click MXCS.

3. Under Data Source Configurations, click the data source name for which you want to enable

MFC.

4. Click Sets.

5. To set the statement module caching:

a. Click +.

b. In the Name field, enter statement_module_caching.

c. In the Value field, enter true.

50 Starting, Configuring, and Managing MXCS