DB2 Version 9.7 for Linux, UNIX, and Windows

Pausing and restarting an online table reorganization

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 option, and the PAUSE option. For example:
```
   reorg table employee inplace pause
```
To restart a paused online table reorganization, specify the RESUME option. 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 option is not specified on the current RESUME request, a NOTRUNCATE option 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.