HASHSPIL parameter
Hash file spill chain length
Summary
- Default value
- 16
- Parameter type
- System
- Where set
- User 0 parameter line
- Related products
- All
- Introduced
- Model 204 version 6.1 or earlier
Description
If a Hash-Key Record cannot be stored on the page to which its hash-key hashes, Model 204 will attempt to store that record on the next physical page in that file and is said to have spilled to that page.
HASHSPIL determines the number of times Model 204 will attempt to store a record on a spilled page and therefore, the spill chain length. Long hash spill chains may affect performance as more records may have to be retrieved before the desired record is located.