How to interpret code numbers

DB2® issues SQL execution codes, reason codes, abend reason codes, and DB2 instrumentation facility interface reason codes to communicate about normal and error situations. The format of the code numbers can help you understand what the code applies to.

SQL return codes have the following format:

-418

sign

With the exception of the return code 000, SQL return codes are prefixed with either a + or - sign. The sign represents either success (+) or error (-). The unsigned code 000 indicates success.

number

The numeric portion of an SQL return code is three to five digits long.

All DB2 reason codes, including subsystem termination reason codes, are four bytes long and have the following format:

00E50041

00

The first byte is always 00, which is the high-order byte.

E5

The second byte is the hexadecimal identifier (hex ID), which identifies the DB2 subcomponent. In this example, E5 identifies the DB2 agent services manager.

0041

The last two bytes are the numeric identifier, which is unique within the subcomponent.

The DB2 reason codes are grouped by hexadecimal identifier and listed in numeric order.