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 E are error messages and those that end with W are warning messages.

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

  Use this information to learn about SQL statements that Db2 Big SQL supports.

• Db2 messages

  Use this information to resolve errors that are returned when you run SQL statements.