Skip to Content

Default language.

Information
Space announcement The Using section of the MainView for DB2 documentation is now available in Japanese. The displayed language is dependent on your browser language. You can switch languages from the Language menu.

Accessing thread history data

Thread history overview data in both the MainView for DB2 TLDSs and MainView for DB2 Data Collector active trace data sets is accessible from the thread interval history views.

Thread history overview data from the following sources is accessible from the thread interval history views:

  • MainView for DB2 TLDSs 
  • MainView for DB2 Data Collector active trace data sets
  • (PTF BPD4948 applied) MainView for DB2 current traces

These views provide summary performance data and exception analysis of your DB2 workloads. They display summary data by 15-, 5-, and 1-minute time intervals and connection type, and they provide access to the detail thread accounting data.

To access the views for thread interval history analysis

Use one of the following methods:

  • On the EZDB2 easy menu, select Thrd Workload History and press Enter.
  • On EZDBA, select Thread History / Query and press Enter.

The Thread History Trace Log List view (HTLOGS) is displayed.

>W1 =HTLOGS===========(ALL======*=======)01JUN2020==01:35:58====MVDB2====D==231
-  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

>W1 =HTLOGS============DEHF=====*========04APR2018==06:30:54====MVDB2====D====3
-  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  
 04APR2018 N/A   MVDB2DC  Sum  ROLLUP SUMMARY           Curr       473 DEHF    
 N/A       N/A   BIGELAP  Sum  LARGE ELAPSED TIMES      Curr           DEHF    
 N/A       N/A   THRDHIST Sum  THREAD HISTORY           Curr         8 DEHF    

This view displays information about all available sources of thread accounting history. It includes each trace log data set (TLDS), data from the MainView for DB2 - Data Collector (MVDB2DC) active trace data sets, and (PTF BPD4948 applied) current traces. The entries are sorted by end date and time, so typically the MVDB2DC entry is at the top, followed by the most current THRDHIST TLDSs. TLDSs that are currently being updated are displayed in green.

On the HTLOGS view, you can hyperlink on the following columns:

Column name

To access

Type

(For MVDB2DC traces) panel displaying filtering options for the package summary report (THACPKGS), with a drill down to package details.

Filtering is enabled with package-level qualifiers (such as the package name and collection ID) and thread qualifiers.

Number Records

The following information depending on the selected trace:

  • (For trace logs with available TLDS data, and for MVDB2DC traces) the HTIQZ view displaying a summary of thread data in 15-minute intervals for all the thread accounting records in the active trace data sets.
    From HTIQZ, you can drill down to further interval details (5 minutes, 1 minute, or connect type) before selecting individual thread data, or to a thread query panel to further qualify your request. For more information about HTIQZ, see Analyzing-workload-interval-summaries.

    Warning

    Note

    For MVDB2DC history traces, this field displays zero (blank) if there has been no thread activity in last 7 days.

  • (For traces without logging) current trace data is displayed on the following view or service:
    • (PTF BPD4948 applied) TRLTRAC view
    • (PTF BPD4948 not applied) LTRAC fullscreen service

State

(PTF BPD4948 applied)

(When the value is Curr) current trace data is displayed on the TRLTRAC view.

Warning

Notes

Consider the following information:

  • To view additional information about a MainView for DB2 application trace in windows-mode views (HTIQZ, Thread Query, TRLTRAC, and TRSTRAC), trace logging must be active and trace data must be available in the TLDS.
  • TLDS is not required for MainView for DB2 Data Collector traces. Hyperlinks for Data Collector traces link to windows-mode views.


This section contains the following topic:

Related topic

Analyzing-recent-workload-history

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

MainView for DB2 6.1