reorg compact combines the functions of reorg reclaim_space and reorg forwarded_rows. Use reorg compact when:
You do not need to rebuild an entire table (reorg rebuild); however, both row forwarding and unused space from deletes and updates may be affecting performance.
There are a large number of forwarded rows. See “Using reorg compact to remove row forwarding”.
The syntax for reorg compact is:
reorg compact tablename
[with {resume, time = no_of_minutes}]
For information about the resume and time options, see “resume and time options for reorganizing large tables”.
