-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