An online table reorganization that is in progress can
be paused and restarted by the user.
Before you begin
You must have SYSADM, SYSCTRL, SYSMAINT, DBADM, or SQLADM
authority, or CONTROL privilege on the table whose online reorganization
is to be paused or restarted. You must also have a database connection
to pause or restart an online table reorganization.
Procedure
- To pause an online table reorganization using the REORG
TABLE command, specify the name of the table, the INPLACE parameter,
and the PAUSE parameter.
For example:
reorg table employee inplace pause
- To restart a paused online table reorganization, specify
the RESUME parameter.
For example:
reorg table employee inplace resume
When an online table reorg operation is paused, you cannot
begin a new reorganization of that table. You must either resume or
stop the paused operation before beginning a new reorganization process.
Following
a RESUME request, the reorganization process
respects whatever truncation option is specified on the current RESUME request.
For example, if the NOTRUNCATE parameter is not
specified on the current RESUME request, a NOTRUNCATE parameter
specified on the original REORG TABLE command,
or with any previous RESUME requests, is ignored.
A
table reorg operation cannot resume after a restore and rollforward
operation.