Skip to Content

Default language.

Information
Space announcement This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Considerations when reorganizing the base table space for LOB data

When reorganizing the base table space for LOB data, REORG PLUS does not support certain conditions.

 (BMC.DB2.SPE2504)REORG PLUS cannot handle the reorganization of the LOB tablespace natively. To process the Reorg containing LOB data, it attempts to switch to BMC AMI Reorg for Db2, BMC AMI LOBMaster for Db2, or DSNUTILB, depending on the installation and configuration of REORG PLUS for DB2 and BMC AMI Reorg for Db2. REORG PLUS switches via the AMISWITCH, SMARTSWITCH, and the DSNUTILB options.

REORG PLUS terminates when any of the following conditions exist:

  • You specify one of the following options:
    • SELECT
    • DELETE
    • An UPDATE option that attempts to update a LOB column
    • A WHERE clause that references a LOB column
    • AUX YES and UNLOAD PAUSE.
  • You are rebalancing partitions during the reorganization when running natively.

Related topics

Reorganizing the base table space and its indexes 

Reorganizing LOB data

 

 

 

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

REORG PLUS for DB2 13.1