STMT_CACHE_NUMPOOL

onconfig.std value

None (this parameter is not in onconfig.std)

if not present

1

units

Positive integer

range of values

1 to 256

takes effect

When the database server is shut down and restarted

refer to

Improving query performance, in the IBM Informix Performance Guide

STMT_CACHE_NUMPOOL specifies the number of memory pools for the SQL statement cache. To obtain information about these memory pools, use onstat -g ssc pool.

Because the database server does not insert not all statements that allocate memory from the memory pools in the cache, the cache size might be smaller than the total size of the memory pools.