Troubleshooting Guide

Diagnostic Tools for Windows NT

The following diagnostic tools are available for Windows NT systems:

Event log, performance monitor, and other administrative tools

The Windows NT Administrative Tools folder provides a variety of diagnostic information, including access to the event log and access to performance information. For more information, see Using Administrative Tools Provided by Windows NT.

Task Manager

Available for Version 4.0 of the Windows NT operating system, the Task Manager shows all of the processes running on the Windows NT server, along with details about memory usage. Use this tool to find out which DB2 processes are running, and to diagnose performance problems. Using this tool, you can determine memory usage, memory limits, swapper space used, and memory leakage for a process.

To use Task Manager, place the cursor over the task menu, click on mouse button 2, and select Task Manager from the pop-up menu.

Dr. Watson

The Dr. Watson utility is invoked in the event of a General Protection Fault (GPF). It logs data that may help in diagnosing a problem, and saves this information to a file. You must start this utility by typing drwatson on the command line.

DB2-supplied tools

DB2 supplies administrative and development tools to help you identify DB2 problems. For more information, see Using DB2-Supplied Tools.

ODBC/CLI traces

CLI traces help to identify problems in CLI and ODBC applications. For more information, see the CLI Guide and Reference manual.

SNA server tracing

If you have the SNA server installed, it provides a tracing facility. To use it, go to the SNA Server window.

SNMP

SNMP allows you to capture error data at the point of occurrence. For more information, see SNMP Alerts.

Using Administrative Tools Provided by Windows NT

The Windows NT operating system provides administrative tools that you can use for problem and performance diagnosis. For Version 4.0, these tools are available from the Administrative Tools menu, accessible from Programs in the Start menu. For Version 3.5.1, they are available from the Control Panel.

For information on:

• System errors, select Event Viewer.

  Severe DB2 errors are transmitted to the application event log, which is accessible from the event viewer. For more information, see Using the Windows NT Event Viewer.

• Performance statistics for the local machine and for remote connections, select Performance Monitor. Use this tool to find out and monitor information about connections, threads, and memory.
• User accounts, select User Manager.
• Diagnosing problems, select Windows NT Diagnostics. This tool provides information on the system and its resources, memory, network, and environment.
• Which version of the operating system you are using, select OS Version.
• The type of hardware your Windows NT session is operating on, select Hardware level.

Using the Windows NT Event Viewer

DB2 information is written to the Windows NT event log, which can be accessed by system administrators or other personnel. Because this information can be monitored remotely, critical errors can be detected earlier.

You can view the event log from the Event Viewer, accessible from the Administrative Tools menu. View the application log (rather than the security or system logs) to view DB2-related information.

Often, information in the event log will see the db2diag.log file. Therefore it is recommended that you save both files before you contact DB2 Customer Support.