Client Database-Request Statement Caching Directory (-clstmtCacheDir)
- Last Updated: February 11, 2026
- 1 minute read
- OpenEdge
- Version 13.0
- Documentation
Use Client Database-Request Statement Caching directory (
-clstmtCacheDir) to
specify the location for storing temporary files of statement information that
exceeds that specified client statement cache size or the default 256 bytes of
shared memory.Note: Both
-clstmtcachedir
and -clstmtCacheDir are valid parameter names.
However, -clstmtCacheDir is displayed when referring to the
Client Database-Request Statement Caching directory
startup parameter.| Operating system and syntax | UNIX / Windows | -clstmtcachedir directory-name |
||
|---|---|---|---|---|
| Use with | Maximum value | Minimum value | Single-user default | Multi-user default |
| Client Connection, Database Server | N/A | N/A | N/A | N/A |
- directory-name
- A fully-qualified specification for an existing directory. The directory name can be a maximum of 255 bytes. If the directory does not exist, an error is returned and the database does not start.
You can change the name of the directory while the database is running, regardless of whether
-clstmtCacheDir was previously set or
not.
- Adjust Startup Parameters menu of PROMON
For more information, see Modify database startup parameters online using PROMON.
_DbParamsVSTFor more information, see Database startup parameters file status (_DbParams).
- Options 8 of the PROMON Client Database-Request Statement
Caching menu.
For more information, see Client Database-Request Statement Cache.8. Specify Directory for Statement Cache Files