SQL/MX 2.x Installation and Management Guide (H06.04+)

Reorganizing SQL/MX Tables and Maintaining Data
HP NonStop SQL/MX Installation and Management Guide—540436-001
10-13
Recovering a Failed MODIFY Request and
Resetting Flags
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.
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 successfully or, if necessary, rolling it back
to the known good state that existed at the start of the operation.
If a flag remains set after a MODIFY request completes, this signifies that the table or
index the MODIFY request is acting upon contains unusable space. When the
MODIFY request completes, it starts an ORSERV process that reclaims the unused file
space, reloads the file, and calls on DP2 to reset any UNRECLAIMEDSPACE or
INCOMPLETE SQLDDL OPERATION flag that remains set.
While either flag remains set, any new MODIFY or DUP operation you attempt to
perform on the table or index will fail with error 20290 (operation still in progress). It
might be possible to successfully perform DML operations on the object, but all other
operations will fail.
Verifying That a Flag Is Set in a Partition
To determine whether or not an UNRECLAIMEDSPACE or INCOMPLETE SQLDDL
OPERATION flag is set for any of a given table's or index's partitions, perform a
SHOWLABEL or FUP INFO command on each partition. If you use SHOWLABEL, you
must provide Guardian names for partitions because SHOWLABEL returns file label
information for the primary partition only when ANSI names are used.
Using RECOVER or FUP RELOAD to Recover a Failed
MODIFY Operation and Reset the Flag
When you receive an error message in response to a request or some other indication
that a MODIFY operation has failed before completion, you can issue a query on the