Setting Free Space Percent Limits
You can control the Free Space Percent (FSP) at the global and table level using the following parameters.
| Parameter | Description |
|---|---|
| FREESPACE = n of a CREATE/ALTER TABLE statement | n percent of cylinder space to remain free on each cylinder when bulk loading this table (where n is an integer constant). For Object File System tables, this is a default setting that you cannot change. |
| DEFAULT FREESPACE of an ALTER TABLE statement | Reset the current free space percent for a table at the global or table level. DEFAULT FREESPACE resets Free Space to the value defined in the FreeSpacePercent field in DBS Control. For Object File System tables, this is a default setting that you cannot change. |