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.

Reorganizing LOB table spaces

BMC AMI Reorg processes LOB table spaces and their base table spaces separately and puts LOB table spaces in UT status.

The BMC AMI Reorg AUX YES product checks and reorganizes base and LOB auxiliary table spaces at the same time.

When you specify a wildcard list of table spaces to process, you can omit LOB table spaces by specifying the +LOB(NO) parameter. +LOB(NO) is the default. With +LOB(YES), BMC AMI Reorg processes all base and LOB table spaces included by the wildcard specified.

Related topics

Reorganizing-objects-in-REORG-pending-REORP-status

Reorganizing-table-spaces

Using-BMC-AMI-Reorg

The following restrictions apply when reorganizing LOB table spaces or their base table spaces:

  • BMC AMI Reorg does not rebalance partitions in table spaces that contain LOB columns or in LOB table spaces.
  • BMC AMI Reorg does not natively reorganize PBG table spaces that contain LOB columns, but you can reorganize such table spaces using one of the following methods:
    • Invoke DSNUTILB. For more information, see Invoking-DSNUTILB.
    • If you have a license for BMC AMI Reorg AUX YES, add the AUX keyword to your BMC AMI Reorg syntax. BMC AMI Reorg AUX YES reorganizes both the LOB table space and the base table space.

  • BMC AMI Reorg does not process a base table space with LOB columns when that table space is in REORP status.

    A reorganization to remove the REORP status might require moving rows between partitions, including the LOB rows in the associated LOB table spaces.

    This restriction applies to any ALTER statement that puts a table space in REORP status, such as ALTER ADD PARTITION or ALTER ROTATE.

  • During a reorganization with discards from the base table, BMC AMI Reorg puts the LOB auxiliary table in ACHKP status. After the reorganization, you can run IBM CHECK utilities to find and delete orphaned LOB rows.

    If you use BMC AMI Reorg AUX YES instead of BMC AMI Reorg, this restriction does not apply.

 

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