DWC: Data Warehouse Center messages

FLG: Information Catalog Manager messages

SAT: Satellite messages

The three severity indicators are:

W: Indicates warning or informational messages

N: Indicates error messages

C: Indicates critical system errors

DB2 UDB also provides detailed information for each message. The full error 

message describes the nature of the problem in detail and the potential user 

responses. To display the DB2 UDB return code full message, you can use the 

DB2 command 

db2 ? error code

. In Linux or AIX, since 

?

 (question mark) is a 

special character; you need to separate the DB2 command and the error code 

with a double quote (

). See Example 9 7.

Example 9 7   Explaining error codes

db2 "? sql0289"

SQL0289N Unable to allocate new pages in tablespace

          "".

Explanation:

One of the following conditions is true:

1. One of the containers assigned to this SMS tablespace has

reached the maximum file size.  This is the likely cause of

the error.

2. All the containers assigned to this DMS tablespace are

full.  This is the likely cause of the error.

[...]

You can find full information about the DB2 message format, and a listing of all 

the messages in 

Messages Reference, 

Volumes 1 and 2, GC09 4840 00, and 

GC09 4841 00.

9.4.2  DB2 diagnostic logs

DB2 UDB logs every return code in diagnostic logs based on the diagnostic level 

set in the database manager configuration. When investigating DB2 problems, 

the essential information can be found in diagnostic log files generated by DB2 

UDB. These logs are:

db2diag.log

278 

MySQL to DB2 UDB Conversion Guide