17.3. DB2 Error Message Description

DB2 error messages are structured as follows:

CCCnnnnnS

where:

• CCC identifies the DB2 component returning the message. See Table 17.1 for a list of all components.

  Table 17.1. Error Message Component Description

  Component	Message Source
  ASN	Replication
  CCA	Configuration Assistant
  CLI	Call-level interface
  DB2	Command Line Processor
  DBA	Control Center and database administration utility
  DBI	Installation or configuration
  DWC	Data warehouse center
  FLG	Information catalog manager
  SAT	Satellite
  SPM	Synch point manager
  SQJ	Embedded SQLJ in Java
  SQL	Database manager

  
  

• nnnnn is a three- to five-digit error code.

• S is a severity indicator. When S has a value of W, it means a warning. When S has a value of N, it means it's an error (negative code).

To obtain more information about a code, you can use the help (?) command from the CLP as discussed in Chapter 4, Using the DB2 Tools. The help command lets you enter the error code in different ways. For example, if you want to get more information about SQLCODE -104, you can use any of the following:

					db2 ? SQL0104N
					db2 ? SQL104N
					db2 ? SQL-0104
					db2 ? SQL-104
					db2 ? SQL-104N
				

The component keyword, in this case SQL, needs to prefix the error code. Negative numbers can be suffixed with the letter n. Figure 17.4 shows the output that displays when you use any of the above help commands.

Figure 17.4. Using the help (?) command

[View full size image]