Chapter 9: Using the reorg Command

Reclaiming unused space and undoing row forwarding

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 table_name partition partition_name
	with {resume, time = no_of_minutes}]

If you specify a partition, only the part of the table that resides on that partition is affected.

For information about the resume and time options, see “resume and time options for reorganizing large tables”.