SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-18
ALTER INDEX Statement
{| { ALLOCATE int | DEALLOCATE } |}
[PARTONLY] {| MAXEXTENTS int |}
{| RESETBROKEN |}
{| RECOVER INCOMPLETE SQLDDL OPERATION |}
changes the ALLOCATE, MAXEXTENTS, RESETBROKEN attributes, 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.
For more information about ALLOCATE, MAXEXTENTS, or RESETBROKEN, see
ALLOCATE File Attribute on page A-7, MAXEXTENTS File Attribute on page M-2,
or RESETBROKEN File Attribute on page R-20, respectively. For more information
about INCOMPLETE SQLDDL OPERATION, see the consideration on page A-24
.
ADD PARTITION new-part add-spec
adds a partition named new-part to index name using the options specified in
add-spec. When specifying new-part, include the volume, subvolume, and file
name of the partition.
If SMF is installed on your node, the volume can be a virtual or a direct volume. If
you specify only a subvolume and a file name, SQL creates a new index partition
in the current default volume. If you specify a virtual volume, SQL creates a new
index partition in the virtual volume. In all other cases, SQL creates a new index
partition in the physical volume and the new partition is a direct file not managed by
SMF.
The ADD PARTITION clause is equivalent to the one-way split form of the MOVE
clause.
add-spec
specifies options for a partition added with the ADD PARTITION clause.
The FIRST KEY clause is required and specifies the primary or clustering key
value for the first key allowed in the new partition. val is a literal compatible with
the data type of the key column that specifies the key value. For clustering keys,
specify multiple vals, in order.
The WITH DATA MOVEMENT clause directs SQL to transfer appropriate rows
from name to dest-part. If you do not specify WITH DATA MOVEMENT, ADD
PARTITION creates an empty partition and returns an error if records exist within
the FIRST KEY declaration of the new partition.
add-spec also includes options that allow you to specify a catalog for the new
partition, a physical volume if SMF is installed, the partition’s format (1 or 2) and to
set the EXTENT and MAXEXTENTS file attributes for the partition. These options
are the same as options described under move-spec earlier in this entry.