Start of Content Area

Object documentation DD_HASHSIZE and DD_HASHMAX (Informix)  Locate the document in its SAP Library structure

Definition

The DD_HASHSIZE and DD_HASHMAX parameters in the Informix ONCONFIG file specify how the hash table of the database server is configured.

Use

For up-to-date recommendations, see SAP Note 38307.

To determine whether the values of these parameters must be increased, execute the following command on a production system:

onstat -g dic | more

Check how many lists exist by looking at the number in the first column. If almost 511 lists are displayed, increase DD_HASHSIZE to 613.

Check whether the size of lists is already close to 20 by looking at the number in the second column. If you can see a number close to 20 several times, we recommend increasing DD_HASHMAX to 30.