DB2 – error messages

01 February,2012 by Tom Collins

You can look up any error message from the command line with "db2 ? sqlxxxx" (where xxxx is the SQLCODE with no sign and leading 0 to make it 4 digits long)

You can also use   db2 “? SQLxxxx” | more

The Linux command – more – allows paging of text one screen at a time 

 An example   

DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002, SQLERRMC=NULLID.SYSLH203 0X5359534C564C3031, DRIVER=3.53.70

db2 ? SQL805

Returned 

SQL0805N  Package "" was not found.

 

With an in-depth explanation and User Response

See Also

DB2 error tips

Author: Rambler(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on DB2 – error messages

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright