JDBC Type 2 Driver 3.0 Programmer's Reference (SQL/MX 3.x)

These temporary files are generated during preprocessing. These .mdf files are retained for easier support and
troubleshooting.
Disk Activity
The MFC access plans, stored in the disk OSH location (/usr/tandem/sqlmx/USERMODULE), increases the processor
utilization of the disks. To overcome this problem, use the fileset for that directory. It is beneficial to have OSS
caching on data volumes. To enable fileset and OSS caching, see Enable Fileset and OSS Caching.
Note: If a DDL alters, it is recommended that you run the management script (mgscript) to delete
module files associated with that table or catalog. For information on the management script, see
Managing MFC in the HP NonStop SQL/MX Connectivity Service Manual.
Enable Fileset and OSS Caching
To add a fileset pointing to the USERMODULES directory, perform the following steps:
1. At a TACL prompt, enter:
SCF
and then enter:
assume $zpmon
2. At an SCF prompt, enter the SCF command:
add server #zpns1,cpu 1,backupcpu 2
3. Add a fileset:
add fileset mxc1,nameserver #zpns1,catalog $oss, pool
mxcpool, mntpoint "/usr/tandem/sqlmx/USERMODULES"
4. Verify the status of the fileset:
info fileset mxc1,detail
5. Start the fileset:
start fileset mxc1
To enable OSS caching, perform the following steps:
1. At a TACL prompt, enter:
SCF
and then enter:
assume $zpmon
2. At an SCF prompt, enter the following SCF command to stop all filesets on your system:
STOP FILESET $ZPMON.*