Filtering thread history by thread IDs

To identify threads with performance problems, you can filter your thread history by thread IDs.

Before you begin

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

From the KOBSEVTS panel, which appears when you log in, select Db2. The active Db2 subsystems are displayed.
Enter R next to the Db2 subsystem you want to use.
From the Thread ID tab, you can select threads by ID, using criteria such as Plan Name, Auth ID, Connect, Con Type, Correlation ID, CICS TX, and IMS PSB. Note that Correlation ID is case sensitive. You can use the EQ ("equal") or NE ("not equal") operators to specify that you want to see results that match, or results that do not match, the string you enter. The question mark (?) wildcard can be used to represent one character in a string. For example, you might specify TS12?4 to see threads with Auth IDs such as TS1234 or TS1244.

The asterisk (*) wildcard can be used to specify that you want to see any string. For example, you might specify OMPE* to see threads with Auth IDs such as OMPEADMIN or OMPETEST. When you use the asterisk wildcard, any characters you enter after the asterisk will be ignored. For example, OMPE*TEST would be treated the same as OMPE*. You cannot use the asterisk at the beginning of a string, for example *ABC. This would be treated as just a wildcard, with the ABC being ignored.

Figure 1. Thread ID
When you have specified the selection criteria you want to use, select OK. The thread history summary is displayed.