-627   THE ALTER STATEMENT IS INVALID BECAUSE THE TABLE SPACE OR INDEX HAS USER-MANAGED DATA SETS

Explanation

This error is issued for the following reasons:
  • a CREATE or ALTER statement specified a PRIQTY, SECQTY, or ERASE clause, USING STOGROUP was not specified, and the table space or index has user-managed data sets. The primary and secondary space allocation of a user-managed data set cannot be altered by means of an ALTER statement.
  • an ALTER statement attempted to define a clone table for a base table that is in a table space that has user-managed data sets. A clone table cannot be defined for a base table that is in a table space that has user-managed data sets.

System action

The statement cannot be processed.

Programmer response

Verify that the correct table, index, or partition is specified.

SQLSTATE

55016