.
Analyzing detailed thread history
Use the following procedure to analyze detailed thread history information.
- Access the HTLOGS view in target mode (not SSI mode) by setting the context to the desired Db2 subsystem. To do this, type the following on the COMMAND line:CON ssid
In HTLOGS, find a history trace entry and hyperlink on the Number Records field to access the HTIQZ view.HTIQZ provides summarized thread history data by 15-minute intervals. The header section provides additional navigation options. Scroll right to examine all of the data available for analysis, including totals, averages and exceptions. When you are done, scroll left.
The Thread Count field is the number of threads processed. The Record Count field indicates the number of accounting records. These counts differ for DDF/RRSAF rollup (multiple threads per accounting record) and parallelism rollup (one rollup record that does not represent a thread).
>W1 =HTIQZ=============DEFG=====*========07JUL2016==16:52:47====MVDB2====D==230
- Thread Analysis - Query / Drilldown - Hide Header
Trace ID/Title: MVDB2DC,173 ROLLUP SUMMARY
Hyperlinks Row Hyperlinks Total Records (at Entry): 77464
. THREAD QUERY End Time >> Thread Summary-5 Min.
. Trace Details Date MM-DD >> 15-Minute Details
. BBI2 LTRAC-MV Connect Type >> Thread Summary-Connect
. BBI2 TSTAT-MV Thread Count >> PACKAGE SUMMARY (15 Mins)
. TLDS All Recs Record Count >> THREAD LIST (15 Mins)
. TLDS All Pkgs 15M QRY >> THREAD QUERY (15 Mins)
End Date Connect Thread Record 15M Total Total Total TotInD
Time MM-DD Type Count Count QRY Elapsed CPU zIIP Elaps
14:45 03-03 CICS 767 767 * 1690.189 3.172 0.000 33.9
14:30 03-03 CICS 835 835 * 1790.337 3.364 0.000 29.0
14:15 03-03 CICS 831 831 * 1800.814 3.347 0.000 32.1
14:00 03-03 CICS 832 832 * 1801.821 3.409 0.000 29.5
13:45 03-03 CICS 823 823 * 1798.185 3.431 0.000 37.0
13:30 03-03 CICS 821 821 * 1798.729 3.369 0.000 40.2
13:15 03-03 CICS 817 817 * 1800.306 3.161 0.000 42.6
13:00 03-03 CICS 808 808 * 1800.283 3.275 0.000 43.7
12:45 03-03 CICS 817 817 * 1806.015 3.402 0.000 37.4
12:30 03-03 CICS 817 817 * 1792.930 3.399 0.000 36.4- Review the hyperlinks on the left side of the header section. They provide options that pertain to the entire trace:
- THREAD QUERY hyperlinks to the Select threads to display panel, see Analyzing-by-thread-query.
- Trace Details hyperlinks to a detail summary view of the entire trace (the HTDTLZ view shown in Analyzing-workload-interval-summaries.)
- BBI2 LTRAC-MV hyperlinks to the full-screen LTRAC display for a TLDS and is used primarily to analyze the events per thread in a detail trace.
- TLDS All Recs is valid only for TLDSs and hyperlinks to the TRLTRAC view to show all of the thread accounting records from the selected TLDS. This data is especially useful for exception traces, where only occasional threads are captured and might be in widely spaced, 15-minute intervals.
- Review the Row Hyperlinks that are available for thread history drill down. Find an interval with a fairly high record count, and hyperlink on the End Time field to drill down to a 5-minute summary in the HTI5Z view.
- Hyperlink again on End Time to display 1-minute intervals in the HTI1Z view.
- Press F3 until you return to HTIQZ.
Find an entry that has asterisks in the Connect Type field (indicating multiple connect types) and hyperlink on it.A 15-minute summary by connect type within the interval is displayed.
In each of the 15-, 5-, and 1-minute interval views, the Date field hyperlinks to a detail summary of the selected row. The format is similar to HTDTLZ, but the data is limited to a specific set of threads. You can easily determine whether the conditions you are looking for occurred during the selected time period. Alternatively, you can scroll right in the tabular views to compare multiple time periods more easily.
- Press F3 to return to HTIQZ.
Related topic