Filtering threads

To filter the threads shown in the Thread Summary panel, type QUALIFY followed by any parameters on the Thread Summary panel command line and press Enter. QUALIFY can be truncated to a minimum of QUA.

When qualify is active, the word QUALIFY is displayed in the Thread Summary panel header as shown in the following example:

Figure 1. Thread Summary panel showing qualify active

 DGOMTPLS 13:49               Thread Summary        QUALIFY     ROW 1 TO 1 OF 1

 PMO1DLOC           DSN1 V10   GROUP001 MEMBER01

When the QUALIFY command is issued without parameters, the DB2® Thread Qualification Parameters window is displayed. The content of the window differs depending on the version of Db2 in use.

Figure 2. Db2 Thread Qualification Parameters window

 DGOMTWQ5           DB2 Thread Qualification Parameters
 Command ===> ____________________________________________________________

 Change values as needed:

                                                                More:  - +
 Primary Authorization ID . . . . . . . . . u**r*
 Planname . . . . . . . . . . . . . . . . . planx

 Package/DBRM
   Location . . . . . . . . . . . . . . . . *
   Collection ID  . . . . . . . . . . . . . *
   Program name . . . . . . . . . . . . . . *

 Connection ID  . . . . . . . . . . . . . . *
 Correlation ID . . . . . . . . . . . . . . *
 Requesting location  . . . . . . . . . . . *
 Connection type  . . . . . . . . . . . . . *

 To include threads, place any nonblank character next to status and type.

 Thread Status:                  Thread Type:
 _  I/S                          /  Allied
 /  Queued                       _  Allied-distributed
 /  In application               _  Database access thread (DBAT)
    /  In stored procedure
 /  In DB2
    /  In lock wait
    /  In I/O
    /  In stored procedure
    /  In stored procedure wait
 /  In EOT
 /  RRS no TCB

  F1=Help     F2=Split    F3=Exit     F7=Up       F8=Down     F9=Swap
 F12=Cancel  F16=Look    F17=Collect

Parameters entered in the Db2 Thread Qualification Parameters window are saved for subsequent sessions. The saved values are used until they are changed.

You can qualify threads by entering any character string in one or more fields in the Db2 Thread Qualification Parameters window. Only threads that match the specified values are displayed in the Thread Summary panel.

You activate qualify from the Db2 Thread Qualification Parameters window by pressing F3 (Exit). To return to the Thread Summary panel without activating qualify, press F12 (Cancel).