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:
- Commit the drop.
- Run the REORG utility.
- Run the COPY utility to make a full image copy of the table space.
- Run the MODIFY RECOVERY utility with the DELETE or RETAIN option to delete all previous image copies.