SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-17
ALTER INDEX Statement
The EXTENT, DSLACK, ISLACK, SLACK, and FORMAT options are not supported
for a move or a merge of a partition into an existing partition.
name specifies a valid partition of the index. NonStop SQL/MP determines the
actual source partition during an execution.
Check that the values you specify result in an index or a 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 a merge
operation, SQL determines the correct catalog.
If SMF is installed on your node, the PHYSVOL option directs SQL to override
SMF and place the partition on the physical volume-name. For volume-name,
specify either a physical volume or equivalent DEFINE. Do not include the node
name in your volume name.
[ 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.
For information about operations that use WITH SHARED ACCESS, see WITH
SHARED ACCESS OPTION on page W-4. For more information about optional
clauses, see NAME Option
on page N-2, REPORT Option on page R-3, or
COMMIT Option
on page C-52.