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

  1. 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
  2. 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.