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

ManualsBrandsHP ManualsServerHP Integrity NonStop J-Series

d. Click OK.

6. To add the compiled module location:

a. Click +.

b. In the Name field, enter compiled_module_location.

c. In the Value field, enter default or any other location that you want.

d. Click OK.

7. Click Apply.

8. Stop and start the data source.

Managing MFC

Every application must have its own module file directory so that all the modules for an application

are grouped together.

OSS commands can be used to remove temporary files and modules when required.

The MFC module files can be managed using an OSS script called mgscript.

The mgscript is located at the Guardian location, where the MXOSRVR objects are present. The

following options can be used with the MFC management script:

This option deletes all MFC related files from the specified

directory. For example:

-A

>>mgscript -A <Dir>

Dir : This must be the directory mentioned

in the compiled_module_location

This option deletes all MFC related binary files from the

specified directory related to a specific table. For

example:

-T

>>mgscript –T <Dir> <table_name>

<catalog_name.schema_name>

-T must have three options: Directory, table name, and

catalog.schema name.

When you alter the table using MXCI, specify the correct

table name. Do not use wild card characters.

This option deletes all MFC related files from the

specified directory related to a specific catalog and

schema. For example:

-C

>>mgscript –C <Dir> <catalog_name>

<schema_name>

-C must have three options: Directory, catalog name, and

schema name.

Benefits of MFC

JDBC and ODBC applications that use complex queries result in lower processor utilization, lower

memory consumption, and better response time. For more information on best practices and benefits

of MFC, refer the technical white paper on Module File Cache for NonStop SQL/MX.

Limitations of MFC

• It does not handle session-specific SQL/MX Control Query Defaults (CQD) and SQL/MX

Control Query Shape (CQS).

• For light weight queries, MFC performs only marginally better than SQL/MX compile.

• MFC is not supported for rowset operations.

• Starting with SQL/MX 3.1, MFC supports only INSERT, SELECT, UPDATE, or DELETE queries.

Module File Caching (MFC) 51