.
Thread history analysis
Thread history for a Db2 subsystem accessed in target mode is available for trace log data sets (TLDSs),
BMC AMI Ops Monitor for Db2
- Data Collector active trace data sets, and current traces.
Both interval history and thread accounting data is available.
You can analyze a time period by using the summary drilldowns by 15-, 5-, or 1-minute intervals, or by connect type, drilling down to more detailed thread accounting records.
You can analyze a workload or an exception condition by performing a thread query to get a list of threads that meet your search criteria.
The following table lists the views available for analyzing thread history. Many of these views can be accessed from the HTLOGS view, shown in Thread-interval-history.
View name | Group | Type | Description |
|---|---|---|---|
HTIQZ | Summary | Tabular | Thread Analysis - Query/Drilldown Summarizes thread history data by 15-minute intervals and connection type Use this view to drill down to further summary views or to access a thread query panel to search for Db2 accounting records that meet your criteria. |
HTIQDZ | Summary | Detail | Thread 15-Min. Details Displays a detailed summary of all the thread data for the selected 15-minute interval by end date and time |
HTI5Z | Summary | Tabular | Thread Analysis 5-Min. Drilldown Summarizes thread history data by end time and date and shows up to three 5-minute rows for the selected 15-minute interval |
HTI5DZ | Summary | Detail | Thread 5-Min. Details Displays a detailed summary of all the thread data for the selected 5-minute interval |
HTI1Z | Summary | Tabular | Thread Analysis 1-Min. Drilldown Summarizes thread history data by end time and date and shows up to five 1-minute rows for the selected 5-minute interval |
HTI1DZ | Summary | Detail | Thread 1-Min. Details Displays a detailed summary of all the thread data for the selected 1-minute interval |
HTICZ | Summary | Tabular | Thread Analysis CTYP/15M Drilldown Summarizes thread history data for the selected 15-minute interval by connection type |
HTICDZ | Summary | Detail | Thread CTYP/15M Details Displays a detailed summary of all the thread data for the selected 15-minute interval and connection type |
PGKZ | Summary | Hybrid | Trace Package Analysis Summary This view is the main package view; it is the navigational entry-point into the Trace Package selector. The header section of the view provides hyperlinks to various package summaries which allow subsets of the package records to be processed to display further summary totals and package lists. The body of the view contains one row that summarizes the packages being processed. This row contains hyperlinks as well to provide navigation to overall summary totals as well as lists of and details for individual package records. |
PKGLIST | Tabular | Hybrid | Trace Package List Lists individual package records contained in the trace TRSTRAC may be invoked by hyperlinking on the Exec Count field. |
PKGDETL | Detail | Hybrid | Trace Package Detail Provides detailed information for a given Trace package record Hyperlinks to totals per execution, thread, or event are provided here. |
PKGTOTEZ | Summary | Hybrid Detail | Totals Per Execution Summary Displays overall and per execution totals for the packages being summarized Hyperlinks to totals per thread or event, and per execution minimums and maximums are provided as well. |
PKGTOTTZ | Summary | Hybrid Detail | Totals Per Thread Summary Displays overall and per thread totals for the packages being summarized Hyperlinks to totals per execution or event, and per thread min/max's are provided as well. |
PKGTOTVZ | Summary | Hybrid Detail | Totals Per Event Summary Displays overall and per event totals for the packages being summarized. A hyperlink to per thread min/max's is provided as well. |
PKGMINEZ | Summary | Hybrid Detail | Min/Max Per Execution Summary Displays per execution minimums and maximums for the packages being summarized Hyperlinks to per thread and per event min/max's are provided as well. |
PKGMINTZ | Summary | Hybrid Detail | Min/Max Per Thread Summary Displays per thread minimums and maximums for the packages being summarized Hyperlinks to per execution and per event min/max's are provided as well. |
PKGMINVZ | Summary | Hybrid Detail | Min/Max Per Event Summary Displays per event minimums and maximums for the packages being summarized |
PKGCOLLZ | Summary | Hybrid | Trace Package Summary By Package Summarizes packages by collection name and program name, which may then be listed or totaled |
PKGPGMZ | Summary | Hybrid | Trace Package Summary By Program Name Summarizes packages by program name, which may then be listed or totaled |
PKGACTZ | Summary | Hybrid | Trace Package Summary By Activity Name Summarizes packages by activity name and activity type, which may then be listed or totaled |
PKGATYPZ | Summary | Hybrid | Trace Package Summary By Activity Type Summarizes packages by activity type, which may then be listed or totaled |
TRLTRAC | Tabular | Hybrid | Trace Thread List Displays a scrollable list of selected threads from one of the following sources:
|
TRSTRAC | Free-form tabular | Hybrid | Thread Detail STRAC View Displays detailed thread accounting data for a completed thread record |
TRROLEZ | Summary | Thread Summary Displays a scrollable list of summarized threads sorted by role name | |
TRLTRACD | Detail | Thread Detail (Short) Provides a detail view of all the data in one of the TRLTRAC thread records TRLTRACD provides less detail than the TRSTRAC view, but TRLTRACD consolidates the identifiers and key indicators in a shorter format for a quick overview of thread execution characteristics. | |
TRTOTZ | Summary | Detail | Thread Totals Summary Displays a summary of thread totals and averages for the complete set of accounting records available in the TRLTRAC view If filters are in effect before the TRTOTZ view is selected, they are not applied to the data shown in TRTOTZ. Use this view to determine average utilization values, and to see how many records had exceptions of each type. |
TRAUTHZ | Summary | Tabular | Thread Authorization Summary Displays a scrollable list of summarized trace entries sorted by authorization ID |
TRCONNZ | Summary | Tabular | Thread Connect Summary Displays a scrollable list of summarized trace entries sorted by connect name |
TRCORNMZ | Summary | Tabular | Thread Correlation Name Summary Displays a scrollable list of summarized trace entries sorted by Db2 correlation name |
TRCORRZ | Summary | Tabular | Thread Correlation ID Summary Displays a scrollable list of summarized trace entries sorted by Db2 correlation ID |
TRCTYPZ | Summary | Tabular | Thread Connection Type Summary Displays a scrollable list of summarized trace entries sorted by connection type |
TREUIDZ | Summary | Tabular | Thread EU Wkst. ID Summary Displays a scrollable list of summarized trace entries sorted by workstation end user ID |
TREUTXZ | Summary | Tabular | Thread EU Wkst. Trans Summary Displays a scrollable list of summarized trace entries sorted by workstation transaction or application name |
TREUWNZ | Summary | Tabular | Thread EU Wkst. Name Summary Displays a scrollable list of summarized trace entries sorted by workstation name |
TRPLANZ | Summary | Tabular | Thread Plan Summary Displays a scrollable list of summarized thread accounting records sorted by plan name |
TRRQLOCZ | Summary | Tabular | Thread Requesting Location Summary Displays a scrollable list of summarized trace entries sorted by the first eight characters of the distributed thread requesting location name Local threads are summarized in an entry that has a blank location. |
Related topic