Filtering thread history by event counts and times

To identify threads with performance problems, you can filter your thread history by event counts and times.

Before you begin

To complete this task, the thread history data collector must be running.

Procedure

  1. From the KOBSEVTS panel, which appears when you log in, select Db2. The active Db2 subsystems are displayed.
  2. Enter R next to the Db2 subsystem you want to verify.
  3. Select the Counts/Times tab. From this tab, you can specify that you want to select threads based on a range of system usage counts and CPU and database elapsed times. The supported operators are EQ (Equal), NE (Not Equal), LT (Less Than), LE (Less Equal), GT (Greater Than), GE (Greater Equal).
  4. When you have specified the counts and times you want to monitor, select OK. The thread history summary is displayed.