XREUSE parameter

Free space required to reuse table X page

Summary

Default value

20

Parameter type

Tables

Where set

During file creation or reset by file manager

Related products

All

Introduced

Model 204 V7.1

Description

The amount (percentage) of free space required on a Table X page before it can be added to the reuse queue. The minimum percent is 1, the maximum is 100.

If XREUSE is set fairly high and Table X fills up to the point where the reuse queue is empty and there is no room to increase XHIGHPG, considerable space might still be available on most pages. To prevent a file full condition, Model 204 tries to find space to add a new record on as many as 16 randomly selected pages. Under these circumstances, increase a file or set XREUSE lower.

The Table X reuse queue is built for only unordered or entry order files for which XSIZE is greater than zero.