HP NonStop SQL/MX, Messages Manual

Page: 65 / 752

Data Definition Language (DDL) Messages (1000
through 1999)
HP NonStop SQL/MX Messages Manual — 640324-001
3- 39
SQL 1150
Where
table-name
is the name of the table.
Cause. When the Partition Overlay Support feature is enabled without setting volume
names (through CQD POS_LOCATIONS) for table partitions to reside on, location
names are generated automatically. However, NonStop SQL/MX could not generate
the location names automatically and, because the CQD POS_RAISE_ERROR is set,
the table is not created.
Effect. The operation fails.
Recovery. To correct the error, choose a recovery method:
•
Verify that the disk volumes are available on the current node and retry the
request.
•
Specify the volume names where the partitions need to be created for the given
CREATE TABLE statement through CONTROL QUERY DEFAULT
POS_LOCATIONS, and then retry the request.
•
Do not set the CQD POS_RAISE_ERROR, in which case, a simple table without
partitions is created when the volume names cannot be generated.
SQL 1151
Where
table-name
is the name of the table.
Cause. When the Partition Overlay Support feature is enabled without setting volume
names (through CQD POS_LOCATIONS) for table partitions to reside on, location
names are generated automatically. However, NonStop SQL/MX could not generate
the location names automatically, and because the CQD POS_RAISE_ERROR is not
set, the given table is created as a simple table without partitions as it would be if the
Partition Overlay Support feature was not enabled.
Effect. The POS feature was not applied. A simple table without partitions was
created.
Recovery. None if a nonpartitioned table is requested. To request a partitioned table,
delete the table, verify that disk volumes are available, and resubmit. You can also
specify the volume names where the partitions need to be created for the given
CREATE TABLE through CONTROL QUERY DEFAULT POS_LOCATIONS, and then
retry the request.
1150 Table table-name was not created because Partition
Overlay Support could not generate volume names for the
partitions to reside on.
1151 POS (Partition Overlay Support) was not applied because
volume names could not be generated for the partitions. So a
simple table
table-name was created without partitions.