BREUSE parameter
Free space required to reuse table B page
Summary
- Default value
- 20
- Parameter type
- Tables
- Where set
- During file creation or reset by file manager
- Related products
- All
- Introduced
- Model 204 V6.1 or earlier
Description
The amount (percentage) of free space required on a Table B page before it can be added to the reuse queue (unordered files)
If BREUSE is set fairly high and an unordered file fills up to the point where the reuse queue is empty and there is no room to increase BHIGHPG, 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 BREUSE lower.
BREUSE can be set for files with any file organization, but the reuse queue is built for unordered files only. Files other than unordered might have BREUSE set but no reuse queue present.