NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
C-150
Considerations—CREATE TABLE
For more information, see the entry for a specific attribute.
Considerations—CREATE TABLE
•
Authorization and access requirements
CREATE TABLE requires authority to write to the catalogs that receive the
description of the table and any partitions of the table.
The LIKE clause also requires authority to read the source table and the catalog that
describes the source table.
Only one DDL statement can operate on a given SQL object (or partition of an SQL
object) at a time. An error occurs if you attempt to execute a CREATE TABLE
statement while another process is executing a DDL operation on the same object.
The specific error depends on the DDL operation involved and the phase of the
operation at which the conflict occurs. (See DDL (Data Definition Language)
Statements on page D-19 for more information.)
•
Performance
For partitioned tables, if ServerWare SMF is installed on your node and you omit the
PHYSVOL option, SQL can place all partitions on a single physical volume in the
virtual volume. To distribute partitions among multiple physical volumes, do one of
the following:
°
create partitions in different virtual volumes
°
specify PHYSVOL for the primary and secondary partitions
°
specify direct file names for partitions
•
Limits for tables
A table definition must comply with NonStop SQL/MP limits. See Limits
on
page L-5 for more information.
When you create a table with a large number of partitions, the PARTNS catalog
table and associated IXPART01 index might become full. To correct the situation,
distribute object and partition definitions across multiple catalogs. For more
information about partition limits, see Limits
on page L-5.
•
If you plan to add columns to a relative file organization, you should use
RECLENGTH.
•
The DCOMPRESS extension applies only to key-sequenced tables.
SERIALWRITES Specifies serial or parallel writes. Default is serialwrites.
TABLECODE Sets tablecode. Default is 0.
VERIFIEDWRITE
S
Controls verification of writes to disk. Default is no verification.