If the database-request statement information for a client exceeds the value that you specify with the -clstmtCacheSize parameter or the default of 256 bytes of shared memory, the information is stored in a temporary file. You can specify a directory for the temporary file 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 the directory must be created prior to accessing this option.

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

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