Use Client Database-Request Statement Cache Size (-clstmtCacheSize) to specify the size of the client statement cache. If the database-request statement information for a client exceeds the specified value, the informaiton is stored in a temporary file.

Operating system and syntax UNIX / Windows -clstmtCacheSize n
Use with Maximum value Minimum value Single-user default Multi-user default
Database Server 30,000 256 N/A 256
For optimal performance, set the client statement cache size value high enough to not trigger the creation of a temporary file. You can set the value to the maximum of 30,000, but if you have concerns about reserving so much shared memory, set it to a lower value.
Note: You do not receive a notification if the client statement cache has been exceeded. The only indicator is a temporary appearing in your specified directory that is deleted when the session ends.
For more information, see Client Database-Request Statement Cache.