DB2 SQL-Error: -20182
SQLState: 530A2
Short Description: PARTITIONING CLAUSE ON STATEMENT FOR IS NOT VALID
The values PARTITIONING clause was not accepted on CREATE or ALTER INDEX statement for one of the following reasons: v On ALTER INDEX, if the table uses table-basedCONTROLLED partitioning, or if the index is a partitioning index created in Version 8 or later releases. v On CREATE INDEX, values partitioning attributes were specified on a previous CREATE or ALTER TABLE statement for the table. v On CREATE INDEX, if the partitioning scheme of the index is predetermined by that of the underlying data. v When altering partition limit key values, if there are any large object (LOB) columns in the table.System action: The statement cannot be executed. Programmer response: Change the name of the index to an index for which the values partitioning clause would be valid, and resubmit the statement.