In this post, you’ll learn about the error message -623 a clustering index already exists on table table name in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-623 a clustering index already exists on table table name
Reason for the Error
The CREATE INDEX statement would create a second cluster index on the specified table.� A given table can have only one cluster index.
Solution
Check to determine the identity and validity of the existing cluster index on the object table.� Alternatively, consider creating the index without the CLUSTER attribute.
