NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
A-33
ALTER TABLE Statement
Make sure that the values you specify result in a table or partition large enough to
hold data being moved from an existing table 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 table 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 one-way move or a
merge operation, SQL determines the correct catalog.
If ServerWare SMF is installed, the PHYSVOL option directs SQL to override
ServerWare SMF and move the partition to 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 or split operation.
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.
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, 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.