Troubleshooting Guide

Viewing System Threads and Processes

Some UNIX-based platforms (notably AIX) allow you to view the status of each DB2 process. Unfortunately, it is difficult to identify individual DB2 threads on the OS/2 and Windows platforms, because of the way threads are implemented on these operating systems. For these platforms, use the db2diag.log to diagnose if any parts of the database manager are failing. See First Failure Data Capture, for more information.

For a listing of threads/processes, use the following:

• On UNIX-based systems: the ps command. For more information, see Viewing Process Status Using the ps Command.
• On OS/2: the pstat command. For more information, see Using the pstat Command.
• On Windows NT Version 4.0: the Task Manager. For more information, see Using Administrative Tools Provided by Windows NT.
• On Windows 95 and Windows 98: the Performance Monitor for the Windows operating system, with the Process and ID Process variables. For more information, see Using DB2-Supplied Tools.