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

Reorganizing SQL/MX Tables and Maintaining Data
HP NonStop SQL/MX Installation and Management Guide—544536-007
10-3
Determining the Status of a Reorganization With
FUP STATUS
•
Beginning with SQL/MX Release 2.2, you can either specify an ANSI name or a
Guardian file name when you perform a FUP RELOAD on an SQL/MX table or
index. FUP RELOAD only supports the use of ANSI names for individual table or
index partitions. If you provide an ANSI name for a table or index partition, FUP
converts it to its corresponding Guardian file name and performs RELOAD on the
file as if the Guardian name had been entered directly. If you provide a Guardian
file name, you must first identify the Guardian files (objects) that are associated
with that table or index. For instructions on obtaining this information, see
Displaying Table Information on page 8-28 or use the SHOWDDL command. You
then run FUP RELOAD on each of these Guardian files (objects) for the SQL/MX
table or index. 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. If you do use ANSI names with FUP RELOAD, the FUP command line cannot
exceed 132 characters. Do not use ANSI names that span more than one input line and
require an embedded “&” line continuation character. One alternative would be to accept
an input file and read the ANSI names out of that file, limiting it to names of 255 characters
or less because EDIT files have that limit.
Note. Do not attempt to perform a FUP RELOAD operation on a partition while other
partition (DDL) operations are in progress on its table or index.