Specifies a threshold Free Space Percent (FSP) value above which intermediate structures during load operations will also be compressed to preserve free space. Intermediate structures will only be compressed if free space drops below the specified percent.
Field Group
Compression
Valid Range
1 through 100
Default
20
Changes Take Effect
Immediately
Usage Notes
SettingMinDataBaseFSPtoCompWorkDBs to 100 means all intermediate load blocks will be compressed, disabling the feature.
Related Information
| For more information on... | See... |
|---|---|
| BlockLevelCompression field | BlockLevelCompression. |
| COMPRESS and UNCOMPRESS commands | Ferret Utility (ferret). |