Manual
Module File Caching Configurations
The Module File Caching (MFC) feature shares the prepared statement plans among the NonStop
SQL/MX database connections and helps in reducing resource consumption. MFC is disabled
by default; therefore, it must be configured to enable it.
To use the MFC feature, you must perform the following activities:
• Configuring NonStop SQL/MX DataSource for MFC
• Modifying the Spring Application
NOTE: JDBC Type 4 driver offers MFC feature.
Configuring NonStop SQL/MX DataSource for MFC
To configure MFC on a NonStop system, complete the following steps:
1. Enter the SQL/MX Connectivity Service (MXCS) subsystem using the SQL/MX Conversational
Interface (MXCI) subsystem:
mxci>> mode mxcs;
2. Configure a datasource for the user specified association service (MXOAS service):
mxci>> add ds $mcbs."MFC_datasource";
NOTE: You can configure any number of servers based on your requirement. If you do
not specify the number of servers, the default value (maxserver=5, initserver=1, and
idleserver=1) is assumed.
3. Stop the datasource:
mxci>> stop ds MFC_datasource, reason 'test';
NOTE: This step must be performed only if you have a configured datasource in the started
status.
4. To enable the MFC feature, add the statement_module_caching environment variable
to the datasource:
mxci>> add evar $mcbs."MFC_datasource".statement_module_caching, type set,
value 'true';
NOTE: MFC can have only two values: true or false.
5. Add the compiled_module_location environment variable to the datasource:
mxci>> add evar $mfc."MFC_datasource".compiled_module_location, type set,
value 'default';
NOTE: The compiled_module_location can be set to a value other than default, such
as, /usr/sash. However, you must ensure that the directory is created before specifying
it.
mxci>> add evar $mfc."MFC_datasource".compiled_module_location, type set,
value '/usr/sash';
6. Start the datasource:
>> start ds $mfc."MFC_datasource";
For more details, see the JDBC Type 4 Driver 2.0 Programmer's Reference.
Module File Caching Configurations 87