HASHCELL parameter

From m204wiki
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Hash cells per buffer

Summary

Default value
3
Parameter type
System
Where set
On User 0's parameter line
Related products
All
Introduced
Model 204 V7.4

Description

The HASHCELL parameter indicates the number of hash cells to allocate for each buffer in the buffer pool. Hash cells are used to locate database pages in the buffer pool based on file, table, and page number.

The default (and minimum) value for HASHCELL is 3 and the maximum value is 7. It is recommended that this parameter be reset from its default value only when running with AMPSUBS>0.