Google's daily error codes for SQL UDB and DB2. More often than not, I don't get a lot of garbage results. Is there a list of error codes that are complete and searchable that everyone knows about? This would help me a lot in handling SQL error codes in my programs and analysis.
Using this search string in google: site:ibm.com error codes DB2
site:ibm.com error codes DB2
I found: http://publib.boulder.ibm.com/infocenter/ratportm/v7r1m1/index.jsp?topic=/com.ibm.installwin.doc/rpm_install147.html
And using site:ibm.com +error +codes UDB (additional coaching required)
site:ibm.com +error +codes UDB
I got: http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/rzala/rzala.pdf
Does it help?
I use this code: SQL Error Codes for IBM UDB and DB2
but only when my DB2 administrator is unavailable. (It is much easier to understand than the IBM documentation.)
Alternatively, you can run the query:
values sqlerrm(<your error number goes here>);
And then you have no problem running the list.