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:
- MainView for DB2 trace logs, such as THRDHIST, which generally cover a relatively short interval
- MainView for DB2 - Data Collector trace data sets, which could have a day or more of compressed data
- (PTF BPD4948 applied) MainView 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
- Thread History Traces - Hide Header
Row Hyperlinks
Number Records >> Thread Query / Time Drilldown
Type >> MVDB2DC Package Reports
End Number DB2
End Date Time Trace Id Type Trace Title State Records Target
N/A N/A THRDHIST Sum THREAD HISTORY Curr 1 WTNDEEO
N/A N/A THRDHIST Sum THREAD HISTORY Curr 2 WTNDEHF
N/A N/A BIGELAP Sum LARGE ELAPSED TIMES Curr WTNDEEO
N/A N/A BIGELAP Sum LARGE ELAPSED TIMES Curr WTNDEHF
N/A N/A THRDHIST Sum THREAD HISTORY Curr JXODEEO
N/A N/A THRDHIST Sum THREAD HISTORY Curr JXODEHF
N/A N/A BIGELAP Sum LARGE ELAPSED TIMES Curr JXODEHF
N/A N/A BIGELAP Sum LARGE ELAPSED TIMES Curr JXODEEO
13JUN2016 14:12 T121608 Det DTL SQL TRACE=BOLJXO1 Hist 2 JXODEHF
09JUN2016 22:08 TRCJXOZZ I/O demo jxo trace Hist 2 JXODEEO
09JUN2016 18:27 THRDHIST Sum THREAD HISTORY Hist WTNDEEO
09JUN2016 16:53 THRDHIST Sum THREAD HISTORY Hist 4 WTNDEEO
09JUN2016 15:37 THRDHIST Sum THREAD HISTORY Hist 13 WTNDEEO
09JUN2016 15:29 TR34JXO I/O Demo trace jxo Hist JXODEHF
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 MainView for DB2 - Data Collector active logs selected by date, and (PTF BPD4948 applied) 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 MainView for DB2 - 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 similiar 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 MainView 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