SPILLADD parameter

Spill indicator - adds

Summary

Default value

None

Parameter type

Tables

Where set

View-only

Related products

All

Introduced

Model 204 V6.1 or earlier

Description

The number of times records have spilled (sorted and hash key files)

When a record is added to a nonpreferred overflow area in a sorted file, SPILLADD is incremented by the number of overflow areas that have to be skipped before the record can be added. For a hash key file, SPILLADD is incremented by the number of extra pages that are tried before a record is added.