How to Interpret DB2 Error Codes
When DB2 dies, it'll dump its error codes into the SQL Exception:
DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505
You can find the meaning of the error code from the db2 command prompt with "? sqlxxxx" where xxxx is the SQLCODE from the error message:
[db2inst1@matilda db2inst1]$ db2 ? sql-803
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
"<index-id>" constrains table "<table-name>" from
having duplicate rows for those columns.
Explanation:
The INSERT or UPDATE object table "<table-name>" is constrained
by one or more UNIQUE indexes to have unique values in certain
columns or groups of columns. Alternatively, a DELETE statement
on a parent table caused the update of a foreign key in a...
(and so on for about three more pages of text...)
You may also like to use the SQL Message Finder to find information about iSeries SQL messages. You can search by message ID, SQLCODE, or SQLSTATE value. You can also select an SQLSTATE class code.
There is also an online reference for SQL Messages and Codes which is quite useful.
Last modified on Oct 7, 2015
Powered by Confluence and Scroll Viewport.