SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-24
Considerations—ALTER INDEX
If ALTER INDEX fails during a merge or one-way move operation with the
WITH SHARED ACCESS option, use the SQL FILEINFO utility to see if the D
or F flag is present for the target partition:

The D flag, INCOMPLETE SQLDDL OPERATION, indicates that you need
to request an ALTER INDEX name PARTONLY RECOVER INCOMPLETE
SQLDDL OPERATION, followed by a FUP RELOAD command for the
target partition.

The F flag, UNRECLAIMED FREE SPACE, indicates that you need to
request a FUP RELOAD operation to reclaim space from the source
partition.
If the slack space in the source table is less than the value chosen for the
target table, a MOVE operation can fail with a file full error. To prevent this
error, check the actual slack amount in the source file (using FILEINFO
STATISTICS) and specify EXTENTS and MAXEXTENTS values for the
target table sufficient to hold the data.

If any partition of an index specified in a move or split operation (even a
partition other than the one being moved or split) resides on a node running
version 1 of the SQL/MP software, error 1125 (Incompatible remote system)
occurs.
You cannot use the WITH SHARED ACCESS option with a split, merge, or
move request unless each source object and each target object resides on a
node running a version of SQL/MP software (315 or later) that supports the
specific type of split, merge, or move operation.