Troubleshooting Guide

Using the pstat Command

The pstat command returns information on which processes are running, and which threads within each process are running. This information includes current status (ready, blocked, and so on), and current priorities.

This command helps you determine:

• Which threads are suspended or waiting on a system event
• Which threads currently have lower priority compared to other threads (this may indicate poor performance)

For information on DB2 processes and threads, see Chapter 14, The DB2 Process Model.

The pstat command displays the process ID that has been assigned for tracing on a per-process basis and that is used to get global system information.

Use the pstat command from the OS/2 command prompt. Its syntax is as follows:

                                  .-----------------.
                                  V                 |
>>-+--------+---+------+---pstat-----+-----------+--+----------><
   '-drive:-'   '-path-'             +-/c--------+
                                     +-/s--------+
                                     +-/l--------+
                                     +-/m--------+
                                     '-/p:--pid--'
 

Parameters

If you use the pstat command without specifying any options, all process information will be displayed. If you want particular information only, use one or more of the following parameters:

/C

This switch displays the current process- and thread-related information on the system. It returns the following information for each process:

• Process ID
• Parent process ID
• Session ID
• Process name

It returns the following information for each thread:

• Thread ID
• Thread priority
• Block ID
• Thread state (ready, blocked)

/S

This switch displays system semaphore information for each thread on the system. It displays the following information for each thread:

• Process name
• Process ID
• Session ID
• Index
• Number of references
• Number of requests
• Flag
• System semaphore name

/L

This switch displays the run-time libraries that are linked for each process on the system. It returns the following information for each process:

• Process name
• Process ID
• Session ID
• Library list

/M

This switch displays the named shared-memory information for each process on the system:

• Handle
• Selector
• Number of references
• Shared memory name

/P: pid

(where pid is the hexadecimal process ID to be displayed) This switch displays information related to the specified process. It returns the following information for the specified process ID:

• Process ID
• Parent process ID
• Session ID
• Process name
• Run-time link libraries
• Shared memory names

It returns the following information for each thread of the specified process ID:

• Thread ID
• Thread priority
• Thread state (ready, blocked)
• Block ID
• Owned semaphores

The following sample shows an example of pstat output:

Process and Thread Information Parent Process Process Session Process Thread ID ID ID Name ID Priority Block ID State 0279 000A 12 E:\SQLLIB\BIN\DB2SYSC.EXE 01 0200 FE11E6C4 Block 02 0200 FDFE7870 Block 03 0200 FE11E544 Block 04 0200 FE1191D8 Block 05 0200 FDF58ECC Block 06 0200 FE034B24 Block 07 0200 FE11DA34 Block 08 0200 FE11DA24 Block 09 0200 FE11DA58 Block 0A 0200 FE11DA14 Block