Limited supportBMC 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 LOB table spaces


Important

With BQU2329 applied, REORG PLUS will send reorganizations of all LOB table spaces to DSNUTILB until further notice.

How REORG PLUS handles LOB table spaces depends on the type of job that you are running as follows:

  • For SHRLEVEL REFERENCE, REORG PLUS natively reorganizes the LOB table space and updates the auxiliary index.
  • REORG PLUS invokes DSNUTILB when any of the following conditions exists:
    • You specify SHRLEVEL NONE or SHRLEVEL CHANGE.
    • Pending definition changes exist on the table space.
    • You are reorganizing both the LOB table space and base table space in the same job step.

Important

For any SHRLEVEL option, REORG PLUS natively reorganizes the auxiliary index on a LOB table space when you specify REORG INDEX.

To reorganize LOB table spaces when invoking 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. If you want to reorganize the LOB table space and base table space in the same job, also complete the following steps:
    1. Specify the base table space as the table space that you are reorganizing.
    2. Specify AUX YES on the REORG command.For more information about the AUX option, see AUX.

To reorganize LOB table spaces when SHRLEVEL REFERENCE is in effect

Create your job as usual, making any adjustments as needed based on the information in Considerations-when-reorganizing-LOB-table-spaces-SHRLEVEL-REFERENCE.

 

 

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