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

NT Administrative Tools folder provides a variety of diagnostic information, including access to the event log and access to performance information. See "Using Administrative Tools Provided by Windows NT" for information.

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. For example, you can determine memory usage, memory limits, swapper space used, and memory leakage for a process.

To use it, 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 explicitly by typing drwatson on the command line.

DB2-supplied tools

DB2 supplies administrative and development tools to help you identify DB2 problems. See "Using DB2-Supplied Tools".

ODBC/CLI traces

CLI traces help to identify problems in CLI and ODBC applications. See "Taking a CLI/ODBC/JDBC Trace" for information.

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. 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. See "Using the Windows NT Event Viewer".

• Performance statistics for the local machine and for remote connections, select Performance Monitor. You can use this tool to find out and monitor information such as 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 remotely by system administrators or other personnel. Because this information can be monitored remotely, there is a better chance that critical errors can be caught as quickly as possible.

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 refer to the db2diag.log file. Therefore it is recommended that you save both files before you contact DB2 Customer Service.

[ DB2 List of Books | Search the DB2 Books ]