Specifying a directory for database-request statement caching files

If the database-request statement cache information for a client exceeds 256 bytes of shared memory, it is stored in a temporary file. You must specify a directory for these temporary files, but you may do so using PROMON, a VST, or a startup parameter.

To specify a directory using PROMON, choose option 8 in the Client Database-Request Statement Caching menu. The following appears:

04/08/15        Status: Specify Directory for Temporary Files
15:49:15    
    
Enter the name of the statement Cache Temporary Directory:

Enter the name of the directory. The directory name cannot exceed 255 bytes in length, and must be created prior to accessing this option.

Note: If you do not specify the directory name, and the database-request statement cache information exceeds 256 bytes, the information is written to a file in the current working directory.

You can also specify the directory using the _DbParams VST or the Client Database-Request Statement Caching Directory parameter (-clstmtcachedir).

For more information, see Database startup parameters file status (_DbParams) and Client Database-Request Statement Caching Directory (-clstmtcachedir).