SQL/MP Installation and Management Guide

Reorganizing Tables and Maintaining Data
HP NonStop SQL/MP Installation and Management Guide—523353-004
8-4
Determining the Status of a Reorganization
Determining the Status of a Reorganization
The FUP STATUS command reports the status of a RELOAD operation. Use the
STATUS command to determine if the operation has completed or has been
suspended and to find out what percentage of the file has been processed.
This command requests the status of the RELOAD operation started in the previous
example for the table CUSTOMER:
14> FUP
- STATUS $VOL.SALES.CUSTOMER
The status is reported in this format:
OPERATION INITIATED date-time of initiation
DSLACK = 50%
ISLACK = 50%
RATE = 30%
10% COMPLETED
If the operation is completed, terminated abnormally, or suspended, FUP displays an
appropriate message.
Suspending a Reorganization Operation
During the reorganization of a table, you might need to suspend the reorganization
process. In most cases, the suspension is necessary for performance considerations.
Later, you can restart the reorganization, causing the process to continue from the
point where it left off.
This command suspends the RELOAD operation started in the previous example for
the table CUSTOMER:
15> FUP
- SUSPEND $VOL.SALES.CUSTOMER
If you issue a STATUS command for the RELOAD operation suspended for the
CUSTOMER table in the preceding example, the status message follows that
command:
16> FUP
- STATUS $VOL.SALES.CUSTOMER
OPERATION INITIATED date-time of initiation
OPERATION SUSPENDED date-time of suspension
DSLACK = 50%
ISLACK = 50%
RATE = 30%
10% COMPLETED
When you want to restart the reorganization of the table, reissue the RELOAD
command. In this case, you must omit the NEW option so that FUP restarts a
previously suspended reload operation.