DB2 Error Code – -627 the alter statement is invalid because the pageset has user managed data sets

In this post, you’ll learn about the error message -627 the alter statement is invalid because the pageset has user managed data sets in the IBM DB2 database , the reason why it occurs along with the solution to fix it

IBM DB2 Error Message

-627 the alter statement is invalid because the pageset has user managed data sets

Reason for the Error

This code is used if a PRIQTY, SECQTY, or ERASE clause is specified, USING STOGROUP is not specified, and the pageset has user managed data sets.

Solution

Verify that the correct table or partition is specified. The primary and secondary space allocation of a user managed data set cannot be altered by means of an ALTER statement.