Page 1 of 1

INDEX U2RPROCO RESTRICTS COLUMNS WITH SAME VALUES

Posted: Mon Apr 12, 2010 2:57 pm
by mallikharjuna
Hi All,

i have tried to insert records in DB2 TABLE,but the below warning message is coming

Ex:"INDEX U2RPROCO RESTRICTS COLUMNS WITH SAME VALUES. 0000083605"

No record exists with same value 0000083605 in DB2 table.

lot of warnings are same type,just given one for example.

please suggest how to sort out this problem.

Thanks
Malli

Posted: Mon Apr 12, 2010 3:15 pm
by ray.wurlod
The index believes that that value exists. Maybe you need to verify - even to re-build the index. Get your DBA involved.

Posted: Mon Apr 12, 2010 8:32 pm
by chulett
Verify that duplicates do not exist in the data you are attempting to load.