Use the resume and time options of the reorg command when reorganizing an entire table would take too long and interfere with other database activities. time allows you to run a reorg for a specified length of time. resume allows you to start a reorg at the point in a table where the previous reorg left off. In combination, the two options allow you to reorganize a large table by running a series of partial reorganizations (for example, during off-hours).
resume and time are not available with reorg rebuild.
The syntax for resume and time is:
reorg forwarded_rows table_name partition partition_name
[with {resume, time = no_of_minutes}]
reorg reclaim_space table_name [index_name] partition partition_name
with {resume, time = no_of_minutes}]
reorg compact table_name partition partition_name
with {resume, time = no_of_minutes}]
The following considerations apply:
If you specify only the resume option, the reorg begins at the point where the previous reorg stopped and continues to the end of the table.
If you specify only the time option, the reorg starts at the beginning of the table and continues for the specified number of minutes.
If you specify both options, the reorg starts at the point where the previous reorg stopped and continues for the specified number of minutes.
