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.