Thread Activity windows
You can access several windows from the Thread Detail panel. To reach a window, type any character in the space beside the desired heading. Several windows can be accessed simultaneously. The windows are overlaid in the Thread Detail panel. To leave the current window and proceed with the next window, press F3 (Exit). To cancel all windows and return to the Thread Detail panel, press F12 (Cancel).
- Thread Identification window
Use the Thread Identification window to examine the identification data about the thread being monitored. - Current Package/DBRM window
To display this window, select Current Package or Current DBRM from the Thread Detail panel. One of two possible windows is displayed depending on whether the thread currently uses a package or a DBRM. - Thread Times window
Use the Thread Times window to investigate the response times of different actions performed by the thread. - Locking (IRLM) Activity window
Use the Locking (IRLM) Activity window to view information about locking activity for the thread being monitored. - Locked Resources window
Use the Locked Resources window to view the list of thread resources that are either locked by or, if they are locked by another thread, unavailable to, the monitored thread. If many resources are listed, you can use the scrolling keys F7 (Up) and F8 (Down) to browse the list. - RID List Processing window
Use the RID List Processing window to view information about the number of successful and unsuccessful RID (Record ID) list processing operations performed. This information can help you determine the maximum number of RID blocks to allocate for optimum system performance. - SQL Activity window
Use the SQL Activity window to view the number of executions of SQL statements during the processing of a DB2 application, for the monitored thread. - Buffer Manager Activity window
Use the Buffer Manager Activity window to view all buffer pools used by the thread. - SQL Statement and Program window
Use the SQL Statement and Package window to view information about the current SQL statement being executed or the last SQL statement that was executed by the thread. - Distributed Data window
Use the Distributed Data window to view a list of serving locations that are communicating with the thread. If many locations are listed, you can use the scrolling keys F7 (Up) and F8 (Down) to browse the list. - IFI (Class 5) and Data Capture window
Use the IFI (Class 5) and Data Capture window to view the number of IFI calls made, the CPU time spent processing these calls, and to examine statistics on data capture activity for the thread. - Query Parallelism Data window
Use the Query Parallelism Data window to view information about the number of parallel groups executed for the thread and to find out whether the type or degree of parallelism was changed at run time. - Data Sharing Locking Activity window
Use the Data Sharing Locking Activity window to view information about data sharing locking activity for the monitored thread. - Group Buffer Pools Activity window
Use the Group Buffer Pools Activity window to view all group buffer pools used by the thread. If many group buffer pools are listed, you can use the scrolling keys F7 (Up) and F8 (Down) to browse the list. - Stored Procedures window
Use the Stored Procedures window to view the stored procedures activity for the thread being monitored.
Parent topic: Displaying thread activity