Running a SHRLEVEL CHANGE reorganization

This topic describes the steps to take to run a SHRLEVEL CHANGE reorganization.

For examples of syntax and output, see the following topics:

• Example-12-SHRLEVEL-CHANGE-with-DDLIN-and-online-repartitioning
• Example-13-SHRLEVEL-CHANGE-with-LONGLOG-and-DELAY
• Example-14-SHRLEVEL-CHANGE-with-table-controlled-partitioning-and-partition-rebalancing

Before you begin

Ensure that you have installed a version of XBM or SUF that is supported for SHRLEVEL CHANGE in REORG PLUS as described in System-requirements.

Also, ensure that you have the appropriate authorizations as described in Setting-REORG-PLUS-authorizations.

To run a SHRLEVEL CHANGE reorganization

1. Complete the following XBM or SUF steps:

   1. Create and activate a management set that contains the appropriate snapshot object definition.
   2. Create and activate a configuration that contains the appropriate cache attributes.

   For more information, see the EXTENDED BUFFER MANAGER for DB2 documentation.

2. Specify SHRLEVEL CHANGE on the REORG command statement.
3. (optional) Use the XBMID installation or command option to specify the XBM subsystem that you want REORG PLUS to use for snapshot processing.
4. If you are running a reorganization that might invoke DSNUTILB, supply a mapping table name or ensure that a mapping table will be created.For more information, see Enabling-REORG-PLUS-to-invoke-DSNUTILB.
5. Specify any additional SHRLEVEL CHANGE options as needed (see descriptions in SHRLEVEL-CHANGE-options-for-REORG-PLUS).
6. Use the information in the remainder of this chapter to ensure that you create JCL that is appropriate for your environment and job requirements.