SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-36
ALTER TABLE Statement
The option 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 utilities 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 or split is
audited and resides (both before and after the operation) 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 information about the optional
clauses, see NAME Option
on page N-2, REPORT Option on page R-3, or
COMMIT Option on page C-52.
{| { ALLOCATE int | DEALLOCATE } |}
[PARTONLY] {| MAXEXTENTS int |}
{| RESETBROKEN |}
{| RECOVER INCOMPLETE SQLDDL OPERATION |)
changes the ALLOCATE, MAXEXTENTS, or 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.
For more information about ALLOCATE, MAXEXTENTS, or RESETBROKEN, see
the ALLOCATE File Attribute on page A-7, MAXEXTENTS File Attribute on
page M-2, or RESETBROKEN File Attribute on page R-20 entries. For more
information about INCOMPLETE PARTITION CHANGE, see the Considerations—
ALTER TABLE on page A-37.
ADD PARTITION new-part add-spec
adds a partition named new-part to table 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, the volume can be a virtual or direct volume name. If you
specify only a subvolume and 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.
You must use ADD PARTITION to add a partition to a table with relative or
entry-sequenced file organization. For tables with key-sequenced organization, you
can use the MOVE clause to add a partition; ADD PARTITION is equivalent to the
one-way split form of the MOVE clause.