HP Neoview Messages, Manual

Page: 38 / 400

SQL 1150
1150 Table table-name was not created because Partition Overlay Support
could not generate volume names for the partitions to reside on.
table-name
is the name of the table.
Cause
When the Partition Overlay Support (POS) feature is enabled without setting volume
names (through POS_LOCATIONS) for table partitions to reside on, location names are
generated automatically. However, the HP Neoview database software could not generate the
location names automatically and, because the 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 segment 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 POS_RAISE_ERROR, in which case, a simple table without partitions is
created when the volume names cannot be generated.
SQL 1151
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.
table-name
is the name of the table.
Cause When the Partition Overlay Support (POS) feature is enabled without setting volume
names (through POS_LOCATIONS) for table partitions to reside on, location names are
generated automatically. However, the HP Neoview database software could not generate the
location names automatically, and because the POS_RAISE_ERROR is not set, the given table
is created as a simple table without partitions as it would be if the POS 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.
SQL 1154
1154 Cannot create object object-name as the table size is too big to
fit on the system.
object-name
is the name of the object
Cause
The HP Neoview database software could not create the object because the requested
table size is bigger than the total amount of disk space available on the cluster.
Effect The SQL operation fails.
Recovery Check that the table size requested is big enough to fit on the cluster, and then
retry the statement.
SQL 1155
1155 Operation cannot be performed because object name is not a synonym.
Cause You specified an alter or drop of synonym on an object
object name
, which is not
a synonym.
38 Data Definition Language (DDL) Messages (1000 Through 1999)