In this post, you’ll learn about the error message -603 a unique index cannot be created because the table contains rows which are duplicates with respect to the values of the identified columns in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-603 a unique index cannot be created because the table contains rows which are duplicates with respect to the values of the identified columns
Reason for the Error
The index defined in the CREATE INDEX statement could not be created as unique because the specified table already contains rows that are duplicates with respect to the values of the identified columns.
Solution
Examine the data to ascertain whether or not the duplicate data is valid.� Alternatively, consider creating a nonunique index.
