DB2 SQL-Error: -20166
SQLState: 428FT
Short Description: C E SQL THE PARTITIONED ADD PARTITION ADD PARTITIONING KEY ALTER PARTITION ROTATE PARTITION OR PARTITION BY RANGE CLAUSE SPECIFIED ON CREATE OR ALTER FOR IS NOT VALID
The PARITIONED, ADD PARTITION, ADD PARTITIONING KEY, ALTER PARTITION, and ROTATE PARTITION clauses cannot be specified on ALTER TABLE, CREATE INDEX, or CREATE TABLE if: v The table is a non-partitioned table. v The table is a materialized query table. v A materialized query table is defined on this table. v The table is in a partition-by-growth table space. If a PARTITION BY clause was specified and the table is in a partition-by-growth, then the clause must be PARTITION BY GROWTH.Additionally: v The ADD PARTITIONING KEY clause cannot be specified if the table is already complete by having established either table-based partitioning or index-based partitioning. v The ROTATE PARTITION clause cannot be specified if: – The table definition is incomplete. – The table contains only one partition.System action: The statement cannot be executed.