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-3
Determining the Status of a Reorganization With
FUP STATUS
•
During the operation, performance can be degraded if the data blocks have
become physically disorganized. Disorganization can occur as a result of INSERT,
UPDATE, or DELETE operations performed over a period of time. You can,
however, control the amount of degradation by using the command’s RATE option.
The higher the rate, the faster the reload occurs, but the more performance
degrades. Conversely, the lower the rate, the slower the reload occurs, but the less
performance degrades. The default value for RATE is 100 percent.
•
To FUP RELOAD an SQL/MX table, you must first identify the Guardian files
(objects) that are associated with that table. For instructions on obtaining this
information, see Displaying Table Information on page 8-30 or use the SHOWDDL
command. You then run FUP RELOAD on each of these Guardian files (objects)
for the SQL/MX table. FUP RELOAD can be run in parallel or sequential order.
•
The FUP RELOAD command reorganizes either a table or an index independent of
each other.
•
You can FUP RELOAD a nonpartitioned table or index. You can also FUP
RELOAD one, some, or all partitions of a partitioned table or index.
•
When the FUP RELOAD command is issued, FUP uses the ORSERV program to
initiate a background process to perform the operations requested by the
command. After the process is initiated, FUP displays the message RELOAD
STARTED and either returns a prompt or terminates (depending upon whether
FUP was initiated interactively or noninteractively).
•
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 on page 10-3.
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.
Note. Do not attempt to perform a FUP RELOAD operation on a partition while other
operations are in progress on its table or index.