NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
A-17
ALTER INDEX Statement
Check that the values you specify result in an index or partition large enough to hold
data being moved from an existing index or partition. Error 45 (File is full) occurs if
the new partition does not have enough space to store the rows transferred. The
default is the value of the corresponding attribute for the index or partition being
moved or split. For more information, see the entry for a specific attribute.
The CATALOG option in move-spec specifies a catalog on the same node as
dest-part to contain the description of the dest-part. The default is the
current default catalog. If you do not specify CATALOG for a move or merge
operation, SQL determines the correct catalog.
If ServerWare SMF is installed on your node, the PHYSVOL option directs SQL to
override ServerWare SMF and place the partition on the physical volume volume-
name. For volume-name, specify either a physical volume or equivalent
DEFINE.
[ NAME operation-name ]
[ ]
WITH SHARED ACCESS [ REPORT [ TO collector | ON | OFF ] ]
[ ]
[ {COMMIT [WORK] [commit-options]} ]
[ {ROLLBACK [WORK] } ]
specifies that the partition being moved be accessible for read and write access by
DML statements throughout most of the move operation.
The optional clauses allow you to name the operation, control EMS reporting for the
operation, specify a time window for the beginning of the commit phase of the
operation (the phase in which DML and utility operations on the file are temporarily
restricted), and specify the timeout period for lock requests and the handling of
retryable errors during the commit phase of the operation.
You can use WITH SHARED ACCESS only if the partition being moved is audited
and resides (both before and after the move) on a node running version 315 or later
of NonStop SQL/MP. You cannot use WITH SHARED ACCESS within a user-
defined transaction.
See the entry WITH SHARED ACCESS OPTION
on page W-4 for detailed
information about operations that use WITH SHARED ACCESS. See NAME
Option on page N-2, REPORT Option on page R-3, or COMMIT Option on
page C-46 for detailed information about the optional clauses.
{| { ALLOCATE int | DEALLOCATE } |}
[PARTONLY] {| MAXEXTENTS int |}
{| RESETBROKEN |}
{| RECOVER INCOMPLETE SQLDDL OPERATION |}
changes the ALLOCATE, MAXEXTENTS, RESETBROKEN attribute, or requests
a recovery operation to change the INCOMPLETE SQLDDL OPERATION flag for
the partition specified in name. The keyword PARTONLY is optional and has no
effect.