SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Reorganizing SQL/MX Tables and Maintaining Data
HP NonStop SQL/MX Installation and Management Guide—523723-004
10-4
Suspending a Reorganization Operation
This command requests the status of the FUP RELOAD operation started in the
previous example for the table CUSTOMER:
FUP
- STATUS $DATA08.ZSDAWVHH.J8MGRZ00
The status is reported in this format:
FUP
- STATUS $DATA08.ZSDAWVHH.J8MGRZ00
$DATA08.ZSDAWVHH.J8MGRZ00
RELOAD IN PROGRESS
RELOAD INITIATED: 21 Jan 2004, 13:02
If the operation completes, terminates abnormally, or is suspended, FUP displays the
appropriate message.
Suspending a Reorganization Operation
During the reorganization of a table, you might need to suspend the reorganization
process. In most cases, 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 FUP RELOAD operation started in the previous example
for the table CUSTOMER:
FUP
- SUSPEND $DATA08.ZSDAWVHH.J8MGRZ00
If you issue a STATUS command for the FUP RELOAD operation suspended for the
CUSTOMER table in the preceding example, the status message follows that
command:
FUP
- STATUS $DATA08.ZSDAWVHH.J8MGRZ00
The status is reported in this format:
- STATUS $DATA08.ZSDAWVHH.J8MGRZ00
$DATA08.ZSDAWVHH.J8MGRZ00
RELOAD INITIATED: 21 Jan 2004, 13:02
RELOAD SUSPENDED: 21 Jan 2004, 13:48
When you want to restart the reorganization of the table, reissue the FUP RELOAD
command. In this case, you must omit the NEW option so that FUP restarts a
previously suspended reload operation.
If you want to change the RATE or SLACK option, you can do so in the restart
command. This command restarts the FUP RELOAD operation for the table
CUSTOMER, but adjusts the reloading rate to 20 percent:
FUP
- RELOAD $DATA08.ZSDAWVHH.J8MGRZ00, RATE 20, SLACK 50