Understanding DB2: Learning Visually with Examples (2nd Edition)

17.3. DB2 Error Message Description

DB2 error messages are structured as follows:

CCCnnnnnS

where:

  • CCC identifies the DB2 component returning the message. See Table 17.1 for a list of all components.

    Table 17.1. Error Message Component Description

    Component

    Message Source

    ASN

    Replication

    CCA

    Configuration Assistant

    CLI

    Call-level interface

    DB2

    Command Line Processor

    DBA

    Control Center and database administration utility

    DBI

    Installation or configuration

    DWC

    Data warehouse center

    FLG

    Information catalog manager

    SAT

    Satellite

    SPM

    Synch point manager

    SQJ

    Embedded SQLJ in Java

    SQL

    Database manager

  • nnnnn is a three- to five-digit error code.

  • S is a severity indicator. When S has a value of W, it means a warning. When S has a value of N, it means it's an error (negative code).

To obtain more information about a code, you can use the help (?) command from the CLP as discussed in Chapter 4, Using the DB2 Tools. The help command lets you enter the error code in different ways. For example, if you want to get more information about SQLCODE -104, you can use any of the following:

db2 ? SQL0104N db2 ? SQL104N db2 ? SQL-0104 db2 ? SQL-104 db2 ? SQL-104N

The component keyword, in this case SQL, needs to prefix the error code. Negative numbers can be suffixed with the letter n. Figure 17.4 shows the output that displays when you use any of the above help commands.

Figure 17.4. Using the help (?) command

Related

Категории