.
Thread interval history
Views for thread interval history analysis are organized into the following groups:
- Thread interval history summary views
- Thread interval history detail views
The thread interval history views show short-term history, performance data, and exceptions for your Db2 workloads. They display summary data by both time and connection type. The data can be collected from the following sources:
- BMC AMI Ops Monitor for Db2 trace logs, such as THRDHIST, which generally cover a relatively short interval
- BMC AMI OpsM for Db2 - Data Collector trace data sets, which could have a day or more of compressed data
- BMC AMI OpsM for Db2 current traces
You can access all the views for thread interval history analysis from the Thread History Trace Log List view (HTLOGS).
- Thread History Traces - Hide Header
Row Hyperlinks
Number Records >> Thread Query / Time Drilldown
Type >> MVDB2DC Package Reports
State >> TRLTRAC / Non-MVDB2DC Current Trace
End Number DB2
End Date Time Trace Id Type Trace Title State Records Target
01JUN2020 N/A MVDB2DC Sum ROLLUP SUMMARY Curr 9067 DEHL
N/A N/A THRDHIST Sum THREAD HISTORY Curr SMDEHL
N/A N/A BIGELAP Sum LARGE ELAPSED TIMES Curr SMDEHL
22MAY2020 01:25 THRDHIST Sum THREAD HISTORY Hist 2 SMDEHL
22MAY2020 01:05 THRDHIST Sum THREAD HISTORY Hist 2 SMDEHL
22MAY2020 23:53 THRDHIST Sum THREAD HISTORY Hist 2 SMDEHL
22MAY2020 22:05 THRDHIST Sum THREAD HISTORY Hist 2 SMDEHL
22MAY2020 13:52 THRDHIST Sum THREAD HISTORY Hist 14 SMDEHL
For information about hyperlinking from HTLOGS, see Accessing-thread-history-data. You can also view the Quick Course Retrieving thread history details.
The following table lists the views available for thread interval history:
View name | Group | Type | Description |
|---|---|---|---|
HTLOGS | Detail | Tabular | Thread History Traces Displays information about all available sources of thread accounting history This data includes each trace log data set (TLDS), data from the Data Collector active logs selected by date, and current traces. Use this view to review the sources of thread history data and select one for workload summary analysis by hour, interval, or connection type, or drill down to detail thread accounting data. |
HTCTYPI | Detail | Tabular | 1 Minute Summary - Connect Displays thread data for the selected connection type for all recorded intervals Use this view to determine when the selected connection type was experiencing problems. |
HTCTYPZ | Summary | Tabular Summary | Thread Summary by Connect Type Summarizes thread processing by connection type Use this view to determine which connection types were experiencing problems. You can sort by any of the columns to look for exceptions. A hyperlink from the Connect Type column displays the interval data for the selected connection type. |
HTDTLZ | Summary | Detail Summary | Thread Interval Summary Displays a detailed summary of all the thread data on the selected thread history source This data can consist of a trace log data set (TLDS) or data from the Data Collector active logs, selected by date. Use this view to get an overview of your Db2 workload for the selected time frame. It shows a thread summary, elapsed and CPU time analysis, key activity indicators (as totals, averages, and maximums), and a detailed breakdown of thread exceptions. It provides hyperlinks for further analysis by hour, interval, or connection type. |
HTHOURZ | Summary | Tabular Summary | Thread Summary by Hour Summarizes thread processing by hour Use this view to identify when workload processing problems or thread exceptions have occurred, and which connection types were affected. You can sort it by any of the columns to look for particular problems like high class 3 wait times or too many exceptions. Hyperlinks are provided to see a breakdown by interval and connection type. |
HTINTVL | Detail | Tabular | Thread History by Interval Displays thread history data for each 15-minute interval by connection type Use this view to identify when workload processing problems or thread exceptions have occurred, and which connection types were affected. You can sort it by any of the columns to look for particular problems like high class 3 wait times or too many exceptions. |
HTINTVLC | Detail | Tabular | Connect Summary - 1 Minute Displays thread data for the selected interval by connection type Use this view to determine which connection types were experiencing problems during a selected interval. |
HTINTVLD | Detail | Detail | Interval/Connect Detail Displays detailed information about the selected interval and connection type Use this view to see CPU and elapsed time analysis, activity counts (as totals, averages, maximums, and rates), and detailed exception counts. |
HTINTVLZ | Summary | Tabular Summary | Thread Summary by 15-Min Intvls Summarizes thread history data by interval Use this view to identify when workload processing problems or thread exceptions have occurred, and which connection types were affected. You can sort it by any of the columns to look for particular problems like high class 3 wait times or too many exceptions. A hyperlink is provided to see a breakdown by connection type. |
HTCONIZ | Tabular | Summary | Interval Summary - Connect Summarizes thread history data by 15-minute interval for the selected connection type |
HTINTCZ | Tabular | Summary | Connect Summary - Interval Summarizes thread history data by connection type for the selected 15-minute interval |
HTLIST | Detail | Tabular | Interval/Connect Summary Records Displays thread history data for each interval by connection type This view is similar to HTINTVL except it contains all available data elements. Customize this view to see only the data that you want or to display the columns in a different order. For instructions about customizing views, see Using BMC AMI Ops products. |
HTXCEPT | Detail | Detail | Thread Interval Exceptions Displays all recorded exception counts for the selected interval and connection type You can use this view to see what problems occurred during the interval for the connection type. |
For a list of thread history views, see Thread-history-analysis.
Related topics