Error types

A method, a function, or a stored procedure might stop with an error or a warning. If this happens, the error or the warning is written to a file. In addition, it is returned by the method, the function, or the stored procedure. If you use IBM® Intelligent Miner®, the error is also written to the error message table (EMT).

Note:

For DB2®, the length of the returned messages is limited to 70 bytes. However, because DB2 adds control information to the beginning of this message, the message that is actually returned is shorter than 70 bytes. This means that the full message usually does not appear. However, the full message appears in the error file or the EMT.

The following types of errors are generated:

DB2 SQL states
Identified by a five-digit error event code
Intelligent Miner error events
Identified by a four-digit error event code
If a reason code is not documented, follow these steps:
  1. Check that there is enough disk space.
  2. Collect the error information that is available.
  3. Call your IBM service representative.