Skip to Content
Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see REORG PLUS for DB2 13.1.

Reorganizing the base table space and its indexes

In general, REORG PLUS reorganizes the base table space (and its indexes) for LOB data natively.

However, REORG PLUS invokes DSNUTILB to reorganize a base table space that contains a LOB column when any of the following conditions exists:

  • The table space contains an index on an inline LOB column.
  • The table space contains an inline LOB column whose length definition was altered before the reorganization.
  • Pending definition changes exist on the table space.
  • You are reorganizing both the base table space and the LOB table space in the same job step. This occurs when any of the following conditions exists:
    • You specify AUX YES.
    • You do not specify the AUX option, but you are reorganizing a table space that contains a LOB column and any of the following conditions exists. (In this case, the DB2 REORG utility defaults to AUX YES.)
      • You specify SHRLEVEL REFERENCE and REBALANCE.
      • You are reorganizing more than one partition of a partition-by-growth table space
      • You specify SHRLEVEL REFERENCE or SHRLEVEL CHANGE, and any partition is in REORP status.

To reorganize base table spaces and their indexes when REORG PLUS invokes DSNUTILB

  1. Ensure that you meet the requirements for a DSNUTILB job, as described in Reorganization-jobs-that-invoke-DSNUTILB.If you do not supply the correct options or environment for invoking DSNUTILB, REORG PLUS issues BMC50178E and terminates.

  2. For either of the following conditions, specify AUX YES on the REORG command:

    • An inline LOB column was altered before the reorganization
    • You want to reorganize the base table space and LOB table space in the same job

    For more information about this option, see AUX.

To reorganize base table spaces and their indexes in all other cases

Create your job as usual, making any necessary adjustments based on the information in Considerations-when-reorganizing-the-base-table-space-for-LOB-data.

Related topic

Considerations-when-reorganizing-the-base-table-space-for-LOB-data 

 

 

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

REORG PLUS for DB2 11.2