MX 3.x)

Starting, Configuring, and Managing MXCS

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

3-32

Benefits of MFC

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

utilization, lower memory consumption, and better response time.

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.

Troubleshooting MFC

The troubleshooting of MFC includes:

•

.lock Files

•

.mdf Files

•

.lst Files

•

.sql Files

•

Disk Activity

•

Enable Fileset and OSS Caching

•

Known Issues

.lock Files

The *.lock files are generated for every query that pass through the MFC module file

creation process. These files are also used for synchronizing, so that different

connections do not re-create the same module file. The *.lock files are deleted from the

specified compiled_module_location directory after the binary module is

successfully created.

The *.lock files are not deleted for the queries that cannot create module files. For

example, ODBC application queries using scalar functions, such as SUM or AVG or

ABS cannot create module files.

.mdf Files

The .mdf temporary files are generated during preprocessing. These .mdf files are

retained for easier support and troubleshooting.