In this post, you’ll learn about the error message -667 the clustering index for a partitioned tablespace cannot be explicitly dropped in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-667 the clustering index for a partitioned tablespace cannot be explicitly dropped
Reason for the Error
The DROP INDEX statement attempted to drop the cluster index for a table residing in a partitioned table space. The cluster index for such a table cannot be dropped explicitly with the DROP INDEX statement.
Solution
The statement cannot be executed.� The specified index was not dropped.