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.

Setting REDEFINE NO

You can improve performance by telling REORG PLUS not to redefine an object during the current reorganization.

For that particular object, REORG PLUS will change REDEFINE YES to REDEFINE NO, bypassing VSAM DELETE/DEFINE processing. This function can be particularly useful in an SAP environment where many indexes exist, but only a few are growing and need to be redefined. For information about how to bypass the redefinition of objects, see Modifying the variable for selective REDEFINE.

Related topic

Using-DSRSEXIT-to-manage-VSAM-data-set-redefinition

Considerations for redefining a nonpartitioned Db2 object

If Db2 determines that the capacity of the A001 data set of a nonpartitioned Db2 object has been exceeded, Db2 allocates another data set (A002) with the same size as the original, creating a multiple data set table space or index space. During object redefinition, REORG PLUS calls the DSRSEXIT user exit once for each of these data set components so that you can perform any of the functions in the exit for each one individually.

Even though you cannot change the size of the additional data set components with Db2, you can change the size with the DSRSEXIT user exit. By default (because the BMC_ALTER_DB2 _CATALOG variable is set to YES), REORG PLUS alters the Db2 catalog for the first data set component (A001). Because the DB2 catalog reflects only one set of values for a nonpartitioned data set, REORG PLUS sets BMC_ALTER_DB2_CATALOG to NO for any other data set components. If you set BMC_ALTER_DB2_CATALOG to YES for any component other than the first, REORG PLUS ignores the request and issues the following message:

 BMC50305I REQUESTED SQL ALTER OF DB2 CATALOG IGNORED FOR dbname.spname COMPONENT Annn

 

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