ANR0162W Supplemental database diagnostic information

Technote (troubleshooting)


Problem(Abstract)

If you receive the ANR0162W message, use the messages that display before and after this message, and the information included in the ANR0162W message, to help you diagnose the cause of the problem.

Cause

This message can occur when the server has an unexpected error in database operations. It can also occur when a SELECT command fails because of a syntax error.

Resolving the problem

  1. Check the messages that appear before or after the ANR0162W message. The messages that appear before or after the ANR0162W message might contain all the information that you need to correct the cause of the problem.

    For example, if the file system where the database or recovery log is located is full, you see the following series of messages:
    ANR0171I dbieval.c(754): Error detected on 16:3, database in evaluation mode.
    ANR0175E dbieval.c(832): Space exhausted for the server DB, LOG, or both.
    ANR0162W Supplemental database diagnostic information: -1:57011:-968 ([IBM][CLI Driver][DB2/AIX64] SQL0968C The file system is full. SQLSTATE=57011).

    In this example, message ANR0175E gives the cause of the problem. The additional diagnostic information in the ANR0162W message is not needed.

  2. If the messages that occur with ANR0162W do not contain enough information, you must use the diagnostic information in ANR0162W to help you determine the cause of the problem.

    For example, the ANR0162W message can occur with an ANR0516E message, when a SELECT command fails because of a syntax error. In that case, the information to help you correct the SELECT statement is in the ANR0162W message.

    The message has the form:
    ANR0162W: Supplemental database diagnostic information: dbReturnCode:dbState:dbCode (dbErrorMessage).

    For example, look at this message:
    ANR0162W Supplemental database diagnostic information: -1:57011:-968 ([IBM][CLI Driver][DB2/AIX64] SQL0968C The file system is full. SQLSTATE=57011).
    In this message, note the following items:

    • dbState, also known as the SQLSTATE, is 57011
    • dbCode is 968
    • SQL message identifier is SQL0968C

    Typically the SQL message identifier is the most useful item for problem diagnosis. Find the message help for the SQLxxxxx message for the database manager, DB2, by using one of the following methods. Read the information for the message, and take the recommended actions.


Methods for accessing DB2 message help
    Information center
    1. Go to the DB2 information center.
    2. In the Search field, enter the SQL message identifier, with or without wildcard characters, and click GO.
    3. Select topics from the search results to find more information.

    Command line processor
      AIX, HP-UX, Linux, or Solaris
      On the system where you have installed the server, log in with the user ID for the server instance. Open a command window, and issue one of the following commands:
        db2 ? SQL_message
        db2 ? dbState
      For example, to get information about the SQL0968C message, issue the command:
        db2 ? sql0968c
      Windows
      On the system where you have installed the server, open a command prompt window. First issue the command to start the command line processor:
        db2cmd
      Then issue one of the following commands:
        db2 ? SQL_message
        db2 ? dbState
    Publications

Related information

Tivoli Storage Manager V6.1 information center

Product Alias/Synonym

ITSM TSM ADSM

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Storage Manager
Server

Software version:

6.1, 6.2, 6.2.2, 6.2.3, 6.3, 6.4, 7.1

Operating system(s):

Platform Independent

Reference #:

1380038

Modified date:

2010-03-03

Translate my page

Machine Translation

Content navigation