REORG DROP PBG PARTS field (REORG_DROP_PBG_PARTS subsystem parameter)
The REORG_DROP_PBG_PARTS subsystem parameter specifies whether the REORG utility removes trailing empty partitions when operating on an entire partition-by-growth table space. An empty trailing partition occurs when the REORG utility moves all data records from a partition into lower numbered partitions.
| Acceptable values: | DISABLE, ENABLE |
|---|---|
| Default: | DISABLE |
| Update: | option 37 36 on panel DSNTIPB |
| DSNZPxxx: | DSN6SPRM REORG_DROP_PBG_PARTS |
This parameter is meaningful only when the REORG utility is run against an entire partition-by-growth table space. It is ignored for:
- LOB table spaces
- Table spaces that are not defined as partition-by-growth
- Partition-by-growth table spaces that are defined with a MAXPARTITONS value of 1
Partition-by-growth table spaces that
contain tables that are defined with DATA CAPTURE CHANGES
- Hash partition-by-growth table spaces
- ENABLE
- Specifies that any trailing empty partitions that are present at the successful completion of the REORG are always removed. LOB table spaces and auxiliary indexes that are associated with these empty partition-by-growth partitions are also removed.
- DISABLE
- Specifies that the number of partition-by-growth partitions at the successful completion of the REORG are always equal or greater than the number of partitions before the REORG utility was run. Even if the REORG is able to relocate all data records into the lowest numbered partitions, trailing empty partition-by-growth partitions are retained.