REORG_IGNORE_FREESPACE in macro DSN6SPRM
By default, when REORG TABLESPACE is run against a partition-by-growth table space, it uses the defined PCTFREE and FREEPAGE values in the partition or table space. As data is loaded back into the table space, new partitions are created as necessary to accommodate the partition or table space’s growth in size.
However, the addition of new partitions might cause the utility to fail because of a lack of disk
space in the following situations:
- When REORG TABLESPACE is run against a subset of the partitions in a partition-by-growth table space
- When REORG TABLESPACE is run against a partition-by-growth table space in which a table contains LOB columns
The REORG_IGNORE_FREESPACE subsystem parameter controls whether DB2® ignores the PCTFREE and FREEPAGE values that are defined for partition-by-growth table spaces in these situations.
Acceptable values: | NO, YES |
Default: | NO |
DSNZPxxx: | DSN6SPRM REORG_IGNORE_FREESPACE |
- NO
- The REORG TABLESPACE utility uses the defined PCTFREE and FREEPAGE values.
- YES
- DB2 uses 0 for the PCTFREE and FREEPAGE values when it reloads data into the table space. This setting can alleviate space problems when REORG TABLESPACE is run against partition-by-growth table spaces.