Display Thread Activity overview

The Thread Summary panel shows a summary of all connected DB2® threads qualified and sorted as defined by the QUALIFY and SORT commands.

You can select individual threads for viewing from the Thread Summary panel, the Threads Holding Resource window, or the Periodic Exceptions List panel. Selecting a thread results in all currently displayed windows being removed and the Thread Detail panel being displayed for the newly selected thread. This thread then becomes the monitored thread for further examination using the Thread Activity panels. From the Thread Detail panel, you can view specific information about the monitored thread in greater detail. To do this, type any character in the selection field next to the corresponding headings and press Enter.

Data displayed in the current panel is refreshed whenever you press Enter without selecting a particular category to be displayed or executing a command.

Before you start displaying thread activity, ensure that the appropriate Db2 monitor trace classes are set on. At least monitor class 1 must be set on, but it is a good practice to also set on class 2 and class 3. If you also want to obtain class 5, 7, or 8 information, switch on the corresponding monitor trace class.

If display exception processing is active, any fields in exception status are shown in reverse video. If you are using a color terminal, fields in warning status are highlighted in yellow, while fields in problem status are highlighted in red. Furthermore, a pop-up window shows the number of display exceptions detected.

You can purge a thread currently processing in a Db2 subsystem from any Thread Activity panel using the PURGE command. You require the Db2 privilege to perform CANCEL THREAD. See PURGE command for more information about purging a thread.

For a Db2 thread that exploits parallelism, OMEGAMON® XE for Db2 PE reports aggregated values across all parallel tasks that are created to execute SQL statements within the thread. Therefore, and because of the nature of parallel work, some counters (particularly processor and suspension fields) can show unexpected large values, which do not necessarily indicate problems. Sometimes these values are even larger than the entire wall-clock elapsed time. Besides query parallelism OMEGAMON XE for Db2 PE also reports Db2 utility parallelism. Further details are described in the following paragraph.