Start of change

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.
End of change