DB2 SQL error: sqlcode = – 803, sqlstate = 23505, sqlerrmc = 2 [solution]

DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=2.
1, check under, probably means to violate the uniqueness constraints ah!
2. However, I found in DB2 DESCRIBE table XX that only ID of the table cannot be empty.
3, finally, directly wrote a SQL execution on the command line, the same error and code
Finally, I looked up the index in the following table and realized that a composite index had been created.
It turns out that the DBA created a unique constraint and index yesterday!
Although only ID cannot be null in a describe, the addition of a unique constraint and index results in the inability to insert data.
 

Read More: