DB2 Duplicate Key Debugging

SQL0803N One or more values in the INSERT statement, UPDATE statement,
or foreign key update caused by a DELETE statement are not valid because
the primary key, unique constraint or unique index identified by "1"
constrains table "XX.TABLE_NAME" from having duplicate values for
the index key. SQLSTATE=23505

You may be asking yourself, but exactly which unique index is causing the problem?