-665   THE PARTITION CLAUSE OF AN ALTER STATEMENT IS OMITTED OR INVALID

Explanation

The ALTER statement is invalid for one of the following reasons:
  • The table space or index is not partitioned and the PARTITION clause is specified.
  • The table space is a partition-by-growth table space and the PARTITION clause is specified.
  • The table space or index is partitioned, a partition attribute (FREEPAGE or PCTFREE) is specified, and the PARTITION clause is not specified.
  • The integer specified in the PARTITION clause does not identify a partition of the table space or index.
  • A USING, PRIQTY, SECQTY, or ERASE clause is used to alter storage attributes, but the partition is not specified.
  • A GBPCACHE clause is used to alter the group buffer pool caching attributes, but the partition is not specified.
  • The PARTITION BY clause is specified without a PARTITION clause to specify the range for the partition. You must specify a PARTITION clause with a range to alter the PARTITION BY specification.
  • Using ALTER to change the attributes of a partition values is not allowed for an index on a partitioned base table with LOB columns, or the table itself.

System action

The statement cannot be processed.

Programmer response

Determine whether the table space or index you want to alter is partitioned. If it is partitioned, specify a PARTITION clause that identifies the partition you want to alter. If it is not partitioned, do not specify the PARTITION clause.

SQLSTATE

53039