Release Notes

|42.3 Reading Message Text Online

|It is assumed that you are familiar with the functions of the operating |system where DB2 is installed.

|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

|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: |

• |db2 "? SQL0000N"
• |db2 "? sql0000"
• |db2 "? SQL0000n" |

|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).