SQL/MX 3.2.1 Management Manual (H06.26+, J06.15+)

• The FUP RELOAD operation might take a long time, depending upon the size of the file and
the rate specified for the command.
• You can suspend the FUP RELOAD operation or request a status report about the progress of
the operation, as explained in “Determining the Status of a Reorganization With FUP STATUS”
(page 180).
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. For more information, see the File Utility
Program (FUP) Reference Manual.
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
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:
180 Reorganizing SQL/MX Tables and Maintaining Data