DROP_PART
You can use the DROP_PART option to specify whether the REORG PLUS utility should remove trailing empty partitions in a partition-by-growth (PBG) table space when the entire table space is being reorganized.
The DROP_PART option has no effect on the following table spaces:
- LOB table spaces
- Non-PBG table spaces
- PBG table spaces that are defined with a MAXPARTITONS value of 1
- PBG table spaces that contain tables that are defined with DATA CAPTURE CHANGES
DROP_PART keywords
Keyword | Description |
|---|---|
YES | REORG PLUS removes the trailing empty partitions in a PBG table space on successful completion. |
NO | REORG PLUS removes the trailing empty partitions in a PBG table space on successful completion. |
When the DROP_PART option is not specified, the REORG PLUS utility checks the DROPPBGPARTS user option. When the DROPPBGPARTS YES is specified, the system parameter REORG_DROP_PBG_PARTS setting is honored. When the DROPPBGPARTS NO is specified, the system parameter REORG_DROP_PBG_PARTS setting is ignored and the drop partition is not performed. For information about system parameter REORG_DROP_PBG_PARTS, see the DB2 Installation and Migration documentation.
If SHRLEVEL (REFERENCE or CHANGE) and FASTSWITCH NO are specified, DROP_PART YES is ignored.
Related topics