Use SQL Statement Cache Size (-SQLStmtCache) to set the number of statements that can be stored in the SQL cache.

Operating system and syntax UNIX / Windows -SQLStmtCache n
Use with Maximum value Minimum value Single-user default Multi-user default
SQL 1024 0 — 100
n
The number of statements to be stored in the SQL Statement Cache.

Use the command line to change the value of -SQLStmtCache.

The SQL Statement Cache Size (-SQLStmtCache) parameter may be modified while your database is online using PROMON or through the _DbParams VST. This change will only take effect on the primary broker and its newly spawned servers.