FSPF
The Free Space Percentage Factor (FSPF) keyword is valid with the RELOAD, USERLOAD, REORG, OREORG, and ANALYZE commands.
You can specify this option in PLUSIN; it is not available as a global option. The following table describes the FSPF keyword.
To do this | Specify this in PLUSIN |
|---|---|
Specify a percentage of free space to qualify a block as free. | FSPF(n1, n2... n10) |
Internal default: 95 | |
The FSPF keyword specifies the percentage of free space to indicate that a block is free. You can specify a maximum of 10 values (a separate value for up to ten data set groups). The first value is for the first data set group, etc.
The values in each subparameter can be a null or a number.
- Number
Indicates that the free space percentage factor for the corresponding data set group is to be reset using the specified number. The number must be in the range of 0 through 99. - Null
Indicates that the value specified in the DBD for that data set will be used.
The FSPF keyword may be used to override the free space percentage factor specified in the DBD.
Online/Defrag uses the free blocks as the work area to reorganize database records. You can lower this number if a reorganization fails or if a lesser value will find more free blocks. A lesser value might result in using more blocks to reorganize the record.
Related topic