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.

+PARTINDEPEND


The +PARTINDEPEND parameter controls the order that partitions are processed when only partitioned indexes are being reorganized.


PARTINDEPEND.png

By default, when there are only partitioned indexes, BMC AMI Reorg performs reorganization on each partition independently of the other partitions. This parameter lets you override this behavior and complete all the partitions together when the last partition completes. The values are defined as follows:

NO

(Default) Switch and post all partitions together, when all partitions are completed

YES

When only partitioned indexes are being reorganized, switch and post partitions as they complete

Important

If +PARTINDEPEND(NO) is in effect and any partition fails, BMC AMI Reorg does not reorganize any partition.

Important

For the 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*