Troubleshooting Db2 SQL messages

You can use the SQL message information to identify a problem and to resolve the problem by taking appropriate action.

Message identifiers consist of an alphabetic message prefix followed by a message number and a single letter suffix; for example, SQL0123N. The prefix identifies the component that generates the message. Db2 Big SQL messages have a prefix of SQL. The single letter suffix describes the severity of the message. Message identifiers that end with W are warning messages, those that end with N are error messages, and those that end with C are critical errors.

Some messages include tokens, or message variables. When a message that contains tokens is generated by Db2 Big SQL, each token is replaced by a value that is specific to the error condition that was encountered.

You can find detailed information about a specific SQL message in the following links.

• Db2 Big SQL SQL reference

  This information describes SQL statements that Db2 Big SQL supports.

• Db2 messages

  This information shows you how to resolve errors that are returned when you run SQL statements.