DS_POOLSIZE

onconfig.std value

None

if not present

127

units

Maximum number of entries in the data-distribution cache

range of values

Any positive value

takes effect

When the database server is shut down and restarted

refer to

The following material:

• IBM Informix Performance Guide for how to monitor and tune the data-distribution cache
• DS_HASHSIZE

The DS_POOLSIZE parameter specifies the maximum number of entries in each hash bucket in the data-distribution cache that the database server uses to store and access column statistics that the UPDATE STATISTICS statement generates in the MEDIUM or HIGH mode.

Use DS_HASHSIZE and DS_POOLSIZE to improve performance of frequently executed queries in a multi-user environment.

For information on configuration parameters for UDR cache, see PC_HASHSIZE and PC_POOLSIZE.