Skip to Content
Information
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.

Fine tuning BMC AMI Reorg

The default values shipped with BMC AMI Reorg are appropriate for most environments. To address specific needs, however, you can override these defaults by passing a set of parameters to BMC AMI Reorg during runtime.

Partition sizes and parallel processing

BMC AMI Reorg processes segmented table spaces with sequential reads and sequential writes. To improve performance, BMC recommends converting segmented table spaces to partition-by-growth (PBG) table spaces and taking advantage of parallelism.

Related topics

Using-BMC-AMI-Reorg

Reorganizing-table-spaces

Reorganizing-indexes

You can take advantage of parallelism by increasing the number of partitions and specifying DSSIZE values less than 32 GB.

For example, if a PBG table space holds one 64-GB partition, BMC AMI Reorg is still limited to one sequential read and sequential write. If the PBG table space holds eight 8-GB partitions instead of one 64-GB partition, BMC AMI Reorg reads and writes the eight partitions in parallel, increasing the speed of the reorganization.

Free space considerations

BMC AMI Reorg provides free space specification parameters:

  • The FREEPAGE parameter specifies the number of pages between empty pages in the table space.
  • The PCTFREE parameter specifies the percentage of free space in each data page of the table space.

These options are located in the RRGPARMS DD for table spaces and RRGPARMX DD for indexes. These parameters are equivalent to the Db2 parameters with the same names. 

 

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

BMC AMI Reorg for Db2 13.1