SQL/MX 3.2.1 Management Manual (H06.26+, J06.15+)
MODIFY and Table Reloading
Some MODIFY command options start the online reload process ORSERV, which runs in the
background. Until the ORSERV process completes, you cannot perform DDL operations and utility
operations—including another MODIFY command—on the affected table or index. ORSERV keeps
the file open and does not terminate for five minutes after the reload operation completes.
For range-partitioned tables and indexes, the MODIFY command starts one or more ORSERV
processes when:
• 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 more information, see the SQL/MX Reference Manual.
MODIFY assigns these default values of the FUP RELOAD parameters to ORSERV:
Default ValueFUP RELOAD Parameter
NoDEALLOCATE
TrueNEW
100RATE (percentage)
15DSLACK (percentage)
15ISLACK (percentage)
FalseSHARE
15SLACK (percentage)
TrueRECLAIM for range partition
FalseRECLAIM for hash partition
For more information, 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 more information, see the SQL/MX Reference Manual.
Recovering a Failed MODIFY Request and Resetting Flags
The UNRECLAIMEDSPACE (F) flag or the INCOMPLETE SQLDDL OPERATION (D) flag can be left
set when a MODIFY operation fails to complete successfully. If possible, the MODIFY utility responds
by invoking its own internal recovery procedure for the purpose of completing the operation
186 Reorganizing SQL/MX Tables and Maintaining Data