DD_HASHMAX

onconfig.std value

None

units

Maximum number of tables in a hash bucket

range of values

Positive integers

takes effect

When the database server is shut down and restarted

utilities

Use a text editor to modify the configuration file.

refer to

The following material:

• Configuration effects on memory, in your IBM Informix Performance Guide
• DD_HASHSIZE

DD_HASHMAX specifies the maximum number of tables in each hash bucket in the data-dictionary cache. A hash bucket is the unit of storage (typically a page) whose address is computed by the hash function. A hash bucket contains several records.

For example, if DD_HASHMAX is 10 and DD_HASHSIZE is 100, you can store information about 1000 tables in the data-dictionary cache, and each hash bucket can have a maximum of 10 tables.