Reorganizing LOB table spaces
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.
To reorganize LOB table spaces when invoking DSNUTILB
- 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.
- If you want to reorganize the LOB table space and base table space in the same job, also complete the following steps:
- Specify the base table space as the table space that you are reorganizing.
- 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*