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.

Resizing Db2 objects

Resizing your Db2 objects during a reorganization enables you to:

  • Reclaim unused space
  • Provide additional space for growth
  • Manage the object size at the partition level
  • Use the new size for subsequent allocations by altering the Db2 catalog to reflect the changes

Related topic

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

After completing object redefinition, REORG PLUS issues an SQL ALTER TABLESPACE or ALTER INDEX statement to update the Db2 catalog with the modified primary and secondary quantities for use with subsequent allocations. You can modify a variable to prevent REORG PLUS from issuing this statement. For information about how to resize objects, see Modifying the variables for resizing the data sets.

 

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