ANR0162W Supplemental database diagnostic information

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.

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.
   

Information center
1. Go to the DB2 information center.
   • For the V6.1 server, go to http://publib.boulder.ibm.com/infocenter/db2luw/v9r5
   • For V6.2 and V6.3 servers, go to http://publib.boulder.ibm.com/infocenter/db2luw/v9r7
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
SQL messages and SQLSTATE messages are available in DB2 publications, or from the DB2 information centers. See http://www.ibm.com/support/docview.wss?rs=71&uid=swg27009474 for how to download the documentation.
• For the V6.1 server, which includes DB2 V9.5 software:
  • Publication: DB2 Version 9.5 for Linux, UNIX, and Windows Message Reference, Volume 2, publication number GI11-7856
  • Information center: http://publib.boulder.ibm.com/infocenter/db2luw/v9r5
• For V6.2 and V6.3 servers, which include DB2 V9.7 software:
  • Publication: DB2 Version 9.7 for Linux, UNIX, and Windows Message Reference, Volume 2, publication number SC27-2451
  • Information center: http://publib.boulder.ibm.com/infocenter/db2luw/v9r7