Important We are integrating BMC AMI LOBMaster technology into the BMC AMI Reorg product and discontinuing BMC AMI LOBMaster as a separate product. For the latest integrated documentation, see BMC AMI Reorg for Db2 13.1.

+PBGPARTS

The +PBGPARTS parameter specifies whether BMC AMI Reorg should reorganize partitions specified in the REORG statement for partition-by-growth (PBG) table spaces.


Related topic

BMC-AMI-Reorg-parameters-RRGPARMS-DD-RRGPARMX-DD 


PBGPARTS.png

PROCESS

(Default) BMC AMI Reorg reorganizes only the partitions specified in the REORG statement.

This is a space-only reorganization. It does not move data from one partition to another.

DSNUM ALL can override PROCESS.

IGNORE

BMC AMI Reorg ignores any partitions specified in the REORG statement and reorganizes the entire PBG table space.

Specifying PROCESS reorganizes only a specified subset of partitions, but this is not a true reorganization of the table space, because the partitions are processed separately and rows are not moved between them. If free space is being reclaimed, the reorganization might fail because of insufficient space in a partition. 

It is common that a subset of parts will trigger the BMC AMI Utility Manager thresholds selecting only that subset of parts for reorganization. Specifying IGNORE processes all the partitions even when BMC AMI Utility Manager selects only a subset of parts, resulting in a true reorganization.  

Best practice
Configure +PBGPARTS(IGNORE) as the default setting, and specify PROCESS in any individual job to process a subset of the partitions rather than a true reorganization of the table space.

Example
+PBGPARTS(IGNORE)

BMC AMI Reorg reorganizes the entire PBG table space.

Important

For rules that apply to parameter syntax, see Parameter syntax rules.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*