INDEX U2RPROCO RESTRICTS COLUMNS WITH SAME VALUES

mallikharjuna · Post by **mallikharjuna** » Mon Apr 12, 2010 2:57 pm

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

ray.wurlod · Post by **ray.wurlod** » Mon Apr 12, 2010 3:15 pm

The index believes that that value exists. Maybe you need to verify - even to re-build the index. Get your DBA involved.

chulett · Post by **chulett** » Mon Apr 12, 2010 8:32 pm

Verify that duplicates do not exist in the data you are attempting to load.