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






footer




 

 

 

 

 Home | About Us | Network | Services | Support | FAQ | Control Panel | Order Online | Sitemap | Contact

san diego web hosting

 

Our partners: PHP: Hypertext Preprocessor Cheap Web Hosting JSP Web Hosting Ontario Web Hosting  Jsp Web Hosting

Cheapest Web Hosting Java Hosting Cheapest Hosting

Visionwebhosting.net Business web hosting division of Vision Web Hosting Inc.. All rights reserved