HASHCELL parameter: Difference between revisions
Jump to navigation
Jump to search
(Automatically generated page update) |
|||
| (3 intermediate revisions by 2 users 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. | <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.