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-12
MODIFY and Table Reloading
•
You specify an offline ADD request (that is, a prefix of a suffix split operation), and
the specified key range contains data.
•
You specify an online ADD request using the WITH SHARED ACCESS clause.
•
You specify a MOVE request for a move-partition-boundary operation, and the
specified key range contains data but does not include the entire partition.
•
You use the WITH SHARED ACCESS clause to specify an online MOVE request
for a move-partition-boundary operation, and the specified key range does not
include the entire partition.
For hash-partitioned tables and indexes, the MODIFY command starts one or more
ORSERV processes when:
•
You specify an ADD request.
•
You specify a DROP request.
For information about MODIFY command syntax, see the SQL/MX Reference Manual.
MODIFY assigns these default values of the FUP RELOAD parameters to ORSERV:
For more information about these and other FUP RELOAD parameters, see the File
Utility Program (FUP) Reference Manual.
You can monitor the progress of the ORSERV process with this TACL command:
FUP STATUS physical-file-name
You can determine the Guardian (physical) file name by using the MXCI SHOWLABEL
command. For example:
SHOWLABEL CAT.SCH.T1, DETAIL;
For information about the MXCI SHOWLABEL command, see the SQL/MX Reference
Manual.
FUP RELOAD Parameter Default Value
DEALLOCATE No
NEW True
RATE (percentage) 100
DSLACK (percentage) 15
ISLACK (percentage) 15
SHARE False
SLACK (percentage) 15
RECLAIM for range partition True
RECLAIM for hash partition False