STMT_CACHE_NOLIMIT

onconfig.std value

None (this parameter is not in onconfig.std)

if not present

1

range of values

0 or 1

takes effect

When the database server is shut down and restarted

utilities

onmode -W STMT_CACHE_NOLIMIT
onstat (See The onstat -g ssc Option.)

refer to

The following material:

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

STMT_CACHE_NOLIMIT controls whether to insert qualified statements into the SQL statement cache after its size is greater than the STMT_CACHE_SIZE value. The following table describes the possible values.

Value

Meaning

0

Prevents statements from being inserted in the cache when its size is greater than the value of STMT_CACHE_SIZE. The cache can grow beyond the size limit if most of the statements in the cache are currently in use, because the cache cleaning cannot catch up with the insert rate. If you are concerned about memory usage, turn off STMT_CACHE_NOLIMIT to prevent the database server from allocating a large amount of memory for the cache.

1

Always insert statements in the SQL statement cache regardless of the cache size.