It is assumed that you are familiar with the functions of the operating system where DB2 is installed. You can use the information contained in the following chapters to identify an error or problem and resolve the problem by using the appropriate recovery action. This information can also be used to understand where messages are generated and logged.
The following DB2 messages are accessible from the operating system command line:
As well, the message text associated with SQLSTATE values is available on-line.
Message identifiers consist of a three character message prefix (ASN, CCA, CLI, DBA, DBI, DB2, SPM, or SQL), 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 SQLSTATEs can be retrieved by issuing:
db2 ? nnnnn or db2 ? nnwhere nnnnn is a five digit SQLSTATE (alphanumeric) and nn is the two digit SQLSTATE class code (first two digits of the SQLSTATE value).
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, see the publications that you received for that program product.