Filtering threads

You can filter threads so that only those meeting your specifications are displayed. This minimizes network traffic and can decrease response times considerably. For example, if you suspect that threads with a certain CPU Class 1 are causing problems, you can specify your filter to display only threads within CPU Class 1. You can define a different filter for each DB2® subsystem.

You start filtering on the Thread Summary window. If you have large amounts of data, you can also set filter criteria in the System Overview window.

To filter threads:

1. Click View > Filter/Qualify.

   The Filter/Qualify window is displayed.

2. On the Identifier Type/Status page, under Column name, click the column name for which you want to specify one or more values.
3. Type a value in the Value field. You can use a wildcard character (*) in the value. For example, if you want to cover all values that start with PM, you would specify PM*. Characters following the wildcard are ignored.
4. Click Add ().

   The selected column name is displayed in the Filter table, with its value and the include () symbol.

   The include symbol means that all threads having the specified value for the selected column name are included in the list of threads.

5. At any time during or after your selection, you can change your criterion:
   • You can change the include symbol to an exclude () symbol for any previous specification in order to exclude threads having the specified value:

     Click the column name and then click Exclude under Qualifier criteria.

   • To narrow the filter, you can select the same column name several times to specify more values. For example, you might want all threads starting with PM but exclude those starting with PMD. Up to 10 values are allowed for the same column name.
6. You can continue specifying additional filter criteria. All criteria and values that you specify are evaluated in the sequence in which you specify them and are combined. This means, the more criteria you specify the narrower the filter and the fewer the threads that are displayed.
7. At any time during or after your selection, you can remove filter criteria from the table.

   In the Filter table, click the criterion to be removed and then Remove (). If you remove all criteria of a column name, this column name is removed from the Filter table.

8. Click the Additional Qualification tab to specify the thread status and type.

   On the Additional Qualification page:

   • By default, all check boxes are selected, except for the Exclude threads with no work in process check box.
   • If the In DB2 check box is selected, all items in the list are automatically selected. You can deselect the ones that you do not need.
   • If the In check box is selected, the field next to this check box and the check box of Exclude threads with no work in process can be selected. By default, Application is selected and the check box of Exclude threads with no work in process is not selected.
9. Click OK.

   The Thread Summary window is displayed, which is refreshed according to your specifications. The Filter/Qualify () icon is displayed in the right-hand corner of the status bar to show that your filter is active. The current filter remains valid until you change it again or disable it.

If you want to keep your filter but temporarily view the threads unfiltered, right-click the Filter () icon and then click Disable. The Filter () icon is dimmed and the data is displayed in the default order.

To make your filter active again, right-click the dimmed Filter () icon and then click Enable.

The window is refreshed according to your specifications.