Message Reference

Information Available Online

The following DB2 messages are accessible from the operating system command line:

Prefix
Description

ASN
messages generated by DB2 Replication

CCA
messages generated by the Client Configuration Assistant

CLI
messages generated by Call Level Interface

DBA
messages generated by the Control Center and the Database Administration Utility

DBI
messages generated by installation and configuration

DB2
messages generated by the command line processor

DWC
messages generated by the Data Warehouse Center

FLG
messages and reason codes generated by the Information Catalog Manager

GSE
messages generated by the DB2 Spatial Extender

SAT
messages generated by DB2 Satellite Edition

SPM
messages generated by the sync point manager

SQJ
messages generated by Embedded SQL in Java (SQLJ)

SQL
messages generated by the database manager when a warning or error condition has been detected.

As well, the message text associated with SQLSTATE values is available on-line.

Message identifiers consist of a three character message prefix (see above list), followed by a four or five digit message number. The single digit letter at the end which describes the severity of the error message is optional.

To access help on these error messages, enter the following at the operating system command prompt: 

db2 "? XXXnnnnn"
 
where XXX represents the message prefix
and where nnnnn represents the message number.
Note:The message identifier accepted as a parameter of the db2 command is not case sensitive, and the terminating letter is not required.

Therefore, the following commands will produce the same result:

If the message text is too long for your screen, use the following command (on unix-based systems and others which support 'more'): 

db2 "? XXXnnnnn" | more

Help can also invoked in the interactive input mode. To enter the interactive input mode, enter the following at the operating system command prompt: 

db2

Once in the interactive input mode, you can enter commands at the following command prompt: 

db2 =>

To get DB2 message help in this mode, type the following at the command prompt: 

? XXXnnnnn
Note:If the message text exceeds the length of the screen, users with non-graphical workstations can pipe the output to the 'more' (on unix-based systems) program or redirect the output to a file which can then be browsed.

The message text associated with a given SQLSTATE value can be retrieved by issuing: 

db2 "? nnnnn"
 
  or
 
db2 "? nn"

where nnnnn is a five digit SQLSTATE (alphanumeric) and nn is the two digit SQLSTATE class code (first two digits of the SQLSTATE value).

Other DB2 Messages

Some DB2 components return messages that are not described in this manual, or online. Some of the message prefixes may include:

AUD
messages generated by the DB2 Audit facility.

DIA
diagnostics messages generated by many DB2 components. These messages are written in the diagnostics log file db2diag.log, and are intended to provide additional information for users and DB2 service personnel when investigating errors.

GOV
messages generated by the DB2 governor utility.

In most cases, these messages provide sufficient information to determine the cause of the warning or error. For more information on the command or utility that generated the messages, please refer to the appropriate manual where the command or utility is documented.

Other Message Sources

When running other programs on the system, you may receive messages with prefixes other than those mentioned in this reference.

For information on these messages, refer to the publications that you received for that program product.

[ Top of Page | Previous Page | Next Page ]