SQL/MX 2.x Installation and Management Guide (H06.04+)

Reorganizing SQL/MX Tables and Maintaining Data
HP NonStop SQL/MX Installation and Management Guide—540436-001
10-4
Determining the Status of a Reorganization With
FUP STATUS
This command initiates a FUP RELOAD operation for the table named CUSTOMER.
The SLACK option sets a minimum amount of free space in the blocks.
FUP
- RELOAD $DATA08.ZSDAWVHH.J8MGRZ00, RATE 30, SLACK 50
Determining the Status of a Reorganization With FUP STATUS
The FUP STATUS command reports the status of a FUP 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 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