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 customize your filter to display only threads within CPU Class 1. You can define a different filter for each Db2® subsystem.

About this task

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.

Procedure

To filter threads, complete the following steps:
  1. Click View > Filter/Qualify. The Filter/Qualify window is displayed.
  2. Type a value in the Value field. You can specify a wildcard character (*) for the value. For example, if you want to cover all values that start with characters PM, you would specify PM*. Characters following the wildcard value are ignored.
  3. On the Identifier Type/Status tab, under Column name, click the column name for which you want to specify one or more values.
  4. Click the Add icon (Add).
    The selected column name is displayed in the Filter pane, with its value and the include symbol icon (Include symbol). The include symbol indicates that all threads having the specified value for the selected column name are included in the list of threads.
  5. Refine the filter criteria based on your requirements. At any time during or after your selection, you can change your criterion:
    1. Optionally, you can change the include symbol to an exclude symbol (Exclude symbol) for any previous specification in order to exclude threads having the specified value:
      1. Click the column name, and then click Exclude under the Qualifier criteria.
      2. To narrow the filter, you can select the same column name several times to specify more values. For example, you might want to display all threads starting with characters PM but exclude those threads starting with PMD. Up to 10 values are allowed for the same column name.
    2. At any time during or after your selection, you can remove filter criteria from the table.
      In the Filter pane, click the criterion to be removed, and then click the Remove icon (Remove). If you remove all criteria of a column name, this column name is removed from the Filter pane.
    Tip: 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.
  6. Click the Additional Qualification tab to specify the thread status and type.
    On the Additional Qualification tab:
    • 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, the application value is selected for In, and the Exclude threads with no work in process sheck box is not selected.
  7. Click OK.
    The Thread Summary window is displayed, which is refreshed according to your specifications. The Filter/Qualify icon (Qualify/Filter toolbar button) 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.

What to do next

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

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

The window is refreshed according to your custom specifications.