STMT_CACHE_SIZE

onconfig.std value

None (this parameter is not in onconfig.std)

default size of
SQL statement cache

512 kilobytes (524288 bytes)

units

Kilobytes

range of values

Positive integer

takes effect

When the database server is shut down and restarted

utilities

onmode -W STMT_CACHE_SIZE
onstat-g ssc (Maxsize field)

refer to

The following material:

• Change Settings for the SQL Statement Cache
• Improving query performance, in the IBM Informix Performance Guide

The STMT_CACHE_SIZE configuration parameter specifies the size of the SQL statement cache in kilobytes. The new cache size takes effect the next time a statement is added to the cache.