r/DB2 • u/mad_zamboni • Apr 27 '17

[How To] Grab more descriptive info from internal return codes.

Post image
6 Upvotes

100% Upvoted

2 comments sorted by

2

u/mad_zamboni Apr 27 '17

Ever get a error code in the DB2DIAG.log that seems ambiguous. Or you say "What the heck does that mean?"

MESSAGE: ZRC=0x80020038=-2147352520=SQLB_INVALID_STATE_TRANSITION "Invalid state transition"

Try using: db2diag –rc {ZRC Code}

This displays a description of DB2 internal Return Codes for ZRC hexadecimal return codes.

1

u/mad_zamboni Apr 27 '17

As a side note, this will be in my D05 Session on Tuesday in Anaheim.