Troubleshooting Guide

Collecting Diagnostic Information

DB2 for OS/2 provides automatic collection of the files required by DB2 Customer Service to diagnose DB2 problems.

You must have a problem record open with DB2 Customer Service to use this tool. Ensure that you have the problem record number available.

To collect diagnostic information using this tool:

1. Go to the server or client on which you suspect the problem to occur.
2. Double-click on the Problem Determination Tools icon in the DB2 folder. The Problem Determination Tools folder appears.
3. Double-click on the Collect Diagnostic Information icon.
4. If you have more than one instance, select the instance you want to work with and click on OK.
5. Enter your problem record number. This is the number that is assigned to your problem when you open a problem with IBM.
6. Click on OK to proceed.
7. A panel with a default list of files appears. Click on Add to include more files to the list.
8. Click on Pack to collect and compress the files.
9. To transmit the file that you created, click on the Send push button. Alternatively, you can use the Send or Receive Information icon to send the file at a later time.

Files are collected and packed into one file. The name of this file is based on the problem record number.

The tool attempts to collect all items on the following list, which represents the diagnostic information most often needed by DB2 Customer Service. The list cannot be changed.

• All dump files contained under the instance directory. These files, when present, contain DB2 diagnostic information.
• All ndf files under the CMLIB directory. These files, when present, contain APPC configuration information.
• All trap files under the DB2 instance directory. These files, when present, contain system exception information such as access violations.
• CONFIG.SYS file. This file contains statements that set up the system configuration each time you restart the operating system.
• Database directory information.
• Database manager configuration information.
• The db2diag.log file. This file is used by DB2 to log diagnostic information.
• DCS directory information, if DB2 Connect is installed on this workstation.
• LANTRAN.LOG. This file contains diagnostic information when this workstation has communication problems with the LAN.
• LOG0001.DAT. This file is the general system log file for this workstation. It is located under your boot drive.
• Node directory information. This file contains information about the DB2 license of this workstation.
• PROTOCOL.INI. This file provides LAN protocol information about the workstation.
• PSTAT. This collects the process status information on this workstation.
• The services file. This file provides TCP/IP connection information.
• STARTUP.CMD. This file shows which programs are automatically started when you start the operating system.
• SYSLEVEL. This file shows all the software including version and level numbers installed on this workstation.

[ DB2 List of Books | Search the DB2 Books ]