NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
A-16
ALTER INDEX Statement
{[FROM KEY val [UP TO LAST KEY]] } }
{ TO dest-part [ move-spec ] } }
{ [WITH SHARED ACCESS [wsa-spec]] } }
{ } }
{TO dest-part [ move-spec ] } }
{ WITH SHARED ACCESS [wsa-spec] } }
[PARTONLY] MOVE { } }
{([FROM FIRST KEY] UP TO KEY val } }
{ TO dest-part [ move-spec ] , } }
{ [WITH SHARED ACCESS [wsa-spec]])} }
{ } }
{([FROM FIRST KEY] UP TO KEY val } }
{ TO dest-part [ move-spec ] , } }
{ FROM KEY val [UP TO LAST KEY] } }
{ TO dest-part [ move-spec ]) } }
moves a specified portion of the index name to a new or existing partition, dest-
part, that has the attributes described in move-spec. You can specify dest-
part with a Guardian name, a DEFINE equivalent to a Guardian name, a node
name and volume name, or a volume name only.
For more information about move operations, see Types of reconfiguration
on
page A-19 in the Considerations section of this entry.
PARTONLY indicates that name is a partitioned index, one partition of which is to
be moved or split. You must include PARTONLY if name is partitioned.
val is a list of comma-separated literals (one for each column in the key) that
specifies a point at which to split the existing partition. Use the keyword NULL to
represent a null value in the list.
move-spec
sets the catalog name and the following file attributes for the index or partition
dest-part:
The EXTENT, DSLACK, ISLACK, and SLACK options are not supported for a
move or 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 execution.
CATALOG Sets the catalog name
PHYSVOL Sets a physical volume for the new partition that overrides
ServerWare SMF
DSLACK Sets percent of slack in data blocks
EXTENT Sets extent sizes
ISLACK Sets percent of slack in index blocks
MAXEXTENTS Sets maximum extents
SLACK Sets percent of slack in blocks if not specified by DSLACK or
ISLACK