Module file caching configurations, Configuring nonstop sql/mx datasource for mfc – HP Integrity NonStop H-Series User Manual
Page 87
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