SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-161
Considerations—CREATE TABLE
For more information, see the entry for a specific attribute.
Considerations—CREATE TABLE

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. For information, see DDL (Data Definition
Language) Statements on page D-20.

For partitioned tables, if 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 these:

create partitions in different virtual volumes

specify PHYSVOL for the primary and secondary partitions

specify direct file names for partitions

A table definition must comply with NonStop SQL/MP limits. For information, see
Limits on page L-6.
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 information
about partition limits, see Limits on page L-6.

If you plan to add columns to a relative file organization, you should use
RECLENGTH.

The DCOMPRESS extension applies only to key-sequenced tables.

These considerations apply to partition formats:

If you create a table with a FORMAT2ENABLED partition array, the table will
have an object version of at least version 350. Therefore, all partitions of the
table must be cataloged in version 350 or later catalogs for the CREATE
TABLE command to succeed.
SERIALWRITES Specifies serial or parallel writes. Default is serialwrites.
TABLECODE Sets tablecode. Default is 0.
VERIFIEDWRITES Controls verification of writes to disk. Default is no
verification.