DB2 Connect 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, refer to the Troubleshooting Guide. For information about messages found in the log, refer to the Message Reference.
• db2diag.log

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

  This file is located in x:\sqllib\db2\db2diag.log on Intel systems, where x: represents the logical drive, and db2 represents 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 and Windows 2000 systems, use the Event Viewer.

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