DB2 Error Code – -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 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.