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


Important

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 exist:
    • 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*