NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
A-7
Considerations—ALLOCATE
For ALTER TABLE or ALTER INDEX, ALLOCATE allocates new extents until the
total of new and existing extents equals the specified number.
DEALLOCATE
frees all unused allocated extents (that is, all allocated extents beyond the extent that
contains the end-of-file). DEALLOCATE is valid only for ALTER TABLE or
ALTER INDEX.
Considerations—ALLOCATE
•
Partitioned tables and indexes
ALLOCATE and DEALLOCATE apply to all partitions of the specified file unless
you include a PARTONLY clause on the statement that specifies the file attribute.
Use the PARTONLY clause if you want to specify different numbers of extents for
different partitions, as follows:
°
In a CREATE TABLE statement that defines the primary partition and four
secondary partitions, ALLOCATE 40 allocates 40 extents to each of the five
partitions.
°
In an ALTER TABLE statement that specifies PARTONLY, ALLOCATE 40
allocates additional extents so that the specified partition has a total of 40
extents.
°
In an ALTER TABLE statement that does not specify PARTONLY, ALLOCATE
40 allocates additional extents to each partition whose total is less than 40 to
make the number of extents equal to 40. ALLOCATE has no effect on partitions
with 40 or more extents.
•
Extent size
ALLOCATE affects the number of extents, but not the size of the extents. The
EXTENT file attribute determines extent size.
ALTER CATALOG Statement
ALTER CATALOG is a DDL statement that alters security attributes for an entire
catalog.
catalog
is the name of the catalog to alter (or an equivalent DEFINE). If ServerWare Storage
Management Facility (SMF) is installed on your node, then catalog must be
either a virtual or direct name.
{| { [NO]CLEARONPURGE } |}
{| NOPURGEUNTIL date |}
ALTER CATALOG catalog {| OWNER group,user |}
{| SECURE "rwep" |}