DB2 SQL error:sqlcode=-803, sqlstate=23505, sqlerrmc=2 (reprint)

http://blog.csdn.net/xiyuan1999/article/details/5706230

DB2 SQL error:sqlcode=-803, sqlstate=23505, sqlerrmc=2.

1, check the next, the general meaning is violated the uniqueness of the constraints Ah!

2, however, I db2 describe table XX found this table only ID is not empty Ah!

3, finally, directly write a SQL on the command line execution, the same error and code

Finally, I looked at the index of the following table and found that a composite index was built before it dawned.

Originally, the DBA built a unique constraint and index yesterday!

DB2 SQL error:sqlcode=-803, sqlstate=23505, sqlerrmc=2 (reprint)