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.

Reorganizing the base table space and its indexes

However, REORG PLUS will seemlessly switch to another product to complete the reorganization when any of the following conditions exist:s:

  • 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.
  • When REORG PLUS determines that a LOB object requires non-native support it can choose the following options, in this order, depending on the configuration and installation of those options and products
    • AMISWITCH
    • SMARTSWITCH
    • DSNUTILB

Related topic

Considerations when reorganizing the base table space for LOB data 

  • 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 exist:
    • 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 exist. (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.

 

 

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

REORG PLUS for DB2 13.1