HASHCELL parameter

From m204wiki
Revision as of 12:51, 28 October 2014 by DCameron (talk | contribs) (→‎Description)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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.