User's Guide

Diagnostic Tools

When you encounter a problem, you can use the following:

• The first failure service log, where diagnostic information is consolidated and stored in a readable format. For more information, see the Troubleshooting Guide. For information about messages found in the log, see the Message Reference.

• db2diag.log

  This file is located in /u/db2/sqllib/db2dump/db2diag.log on UNIX systems, where db2 is the instance name.

  This file is located in x:\sqllib\db2\db2diag.log on Intel systems, where x: is the logical drive, and db2 is the instance name.

• db2alert.log (Same file locations as db2diag.log).

• The trace utility, as described in "Trace Utility (ddcstrc)".

• For UNIX-based systems, the ps command, which returns process status information about active processes to standard output.

• For UNIX-based systems, the core file that is created in the current directory when severe errors occur. It contains a memory image of the terminated process, and can be used to determine what function caused the error.

• For Windows NT systems, use the Event Viewer.

For more information on troubleshooting TCP/IP connections (or other topics), please refer to Troubleshooting Guide, or search for "Technotes" on the DB2 Product and Service Technical Library (see "Using the World Wide Web".

[ DB2 List of Books | Search the DB2 Books ]