logo  
Google
 

DB2 SQL-Error: -623

SQLState: 55012

Short Description: A CLUSTERING INDEX ALREADY EXISTS ON TABLE

A given table can have only one cluster index. This error can occur for the following reasons: v A CREATE INDEX statement would create a second cluster index on the specified table. v An ALTER INDEX statement specified the CLUSTER clause, but there is already a clustering index defined for the table.System action: The statement cannot be executed. Programmer response: 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.

 <-  BACK TO INDEX