DD_HASHMAX configuration parameter
Use the DD_HASHMAX configuration parameter to specify 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 the DD_HASHMAX configuration parameter is set to 10 and the DD_HASHSIZE configuration parameter is set to 59, you can store information about 590 tables in the data-dictionary cache, and each hash bucket can have a maximum of 10 tables.
Use a text editor to modify the configuration file.
- onconfig.std value
- DD_HASHMAX 10
- values
- Positive integers
- units
- Maximum number of tables in a hash bucket
- takes effect
- After you edit your onconfig file and restart the database server.