Neoview Messages Manual (Volume 1) (R2.5)

Effect The operation fails.
Recovery Retry the query and use a valid disk pool number. The disk pool number must be
greater than 0 and less than or equal to the number of disk pools set through the DDL.
Alternatively, to pick a random disk pool, ignore the DISK POOL clause so that the table will
be placed on a random disk pool.
SQL 3420
3420 Illegal size value num for the number of disk pools in the DISK
POOL OF clause.
num
is the specified disk pool number.
Cause Number of disk pools specified in DISK POOL OF clause must be greater than 0.
Effect The operation fails.
Recovery Retry the query and use a valid number of disk pools. The number of disk pools
must be greater than 0 and a multiple of 2 power times the number of disks per node and less
than or equal to the number of disks on the cluster. Alternatively, to pick the default number
of disk pools, ignore the DISK POOL OF clause.
SQL 3421
3421 Duplicate NO PARTITION clauses were specified.
Cause The NO PARTITION clause was specified more than once.
Effect The operation fails.
Recovery Retry the query by specifying only a single NO PARTITION clause.
SQL 3422
3422 Duplicate DISK POOL clauses were specified.
Cause The DISK POOL clause was specified more than once.
Effect The operation fails.
Recovery Retry the query by specifying only a single DISK POOL clause.
SQL 3423
3423 Duplicate NUMBER OF PARTITIONS clause specified or NO PARTITION
and NUMBER OF PARTITIONS clauses specified together.
Cause Either the NUMBER OF PARTITIONS clause was specified more than once, or both
the NO PARTITION clause and NUMBER OF PARTITIONS clause were specified for the same
DDL operation.
Effect The operation fails.
Recovery Retry the query by using either a single NUMBER OF PARTITIONS clause or a
NO PARTITION clause.
SQL 3424
3424 NO PARTITION, MAX TABLE SIZE, DISK POOL clauses are not supported
for Materialized Views
Cause The NO PARTITION clause, DISK POOL clause, or MAX TABLE SIZE clause was
specified as part of the CREATE MATERIALIZED VIEW statement.
Effect The operation fails.
Recovery These clauses are not supported for materialized views. The materialized view is
partitioned the same way as the underlying base table. Remove the clauses and retry the
statement.
127