DS_HASHSIZE

onconfig.std value

None

if not present

31

units

Number of hash buckets or lists

range of values

Any positive prime number

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_POOLSIZE

The DS_HASHSIZE parameter specifies the number of hash buckets 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 multiuser environment.

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