Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see REORG PLUS for DB2 13.1.

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

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*