HASHCELL parameter: Difference between revisions

From m204wiki
Jump to navigation Jump to search
(Automatically generated page update)
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
{{Template:HASHCELL parameter subtitle}}
==Summary==
==Summary==
<dl>
<dl>
Line 14: Line 15:
==Description==
==Description==
<p>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. </p>
<p>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. </p>
<p>The default (and minimum) value for HASHCELL is 3 and the maximum value is 7. Rocket Software recommends resetting the default only when running with AMPSUBS>0.</p>
<p>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 <var>[[AMPSUBS_parameter|AMPSUBS]]</var>>0.</p>
[[Category:System parameters]]
[[Category:System parameters]]
[[Category:Parameters]]
[[Category:Parameters]]

Latest revision as of 12:51, 28 October 2014

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.