Reclaiming space in the DBD

You can reclaim space in the DBD when you drop a table by using the MODIFY RECOVERY utility.

Procedure

To reclaim space in the DBD when you drop a table:

  1. Commit the drop.
  2. Run the REORG utility.
  3. Run the COPY utility to make a full image copy of the table space.
  4. Run the MODIFY RECOVERY utility with the DELETE or RETAIN option to delete all previous image copies.