Analyzing by thread query

The HTIQZ view provides two ways to access the thread query panel:

• The THREAD QUERY hyperlink in the header section lets you specify any time period in the trace. The trace start time is filled in as the start time of the query. The default duration is set to 15 minutes.
• The 15M QRY hyperlink for a particular interval sets the start time of the query to the start time of that interval. The default duration is set to 15 minutes. (There is also a 5M QRY hyperlink in the view HTI5Z. which sets the default duration to 5 minutes.)

To analyze by thread query

1. Select a 15M QRY hyperlink on HTIQZ to access the Thread Query panel.This panel is called a multiplatform dialog (MPD) because it can be used in both 3270 mode and in the MainView Explorer product. 

                             Select threads to display
   COMMAND ===>                                              SCROLL ===> PAGE  
                                                                      MORE: +  
    Trace ID     *            Trace Date                                       
    Record Count              Trace Time                                       
   Required Query Criteria:                                                    
    Start Date                (Local yyyy/mm/dd, default CURRENT)              
    Start Time                (Local hh:mm:ss, default 00:00:00)               
    Duration                  (hh:mm:ss, default 00:15:00)                     
    Package Query             (Select for Package Summary)                     
   Optional Package Qualifiers (Package Query only):                           
   Collection ID                                                               
   Program Name                                                                
   Activity Name                                                               
   Activity Type    (1=StorProc, 2=UDF, 3=Trigger, 4=NatvSQL, 5=Non-inln UDF)  
   Optional Qualifiers - all sources:                                          
   Authorization ID                                                            
   Plan                                                                        
   Connection Name                                                             
   Correlation ID                                                              
   Correlation Name                                                            
   Role                                                                        
   Remote Location                         
   End User Name                                                               
   End Workstation                                                             
   End Xact                                                                    
   Optional Qualifiers - TLDS only:                                            
   Job Step                                                                    
   Exception/Condition Filters - all sources:                                  
     Abnormal Terminations    Rollbacks                                        
     Deadlocks and Timeouts   Lock Escalations         Claim/Drain Failures    
     Incrmntl Bind Failures   RID Failures - Storage   RID Failures - Limit    
     Stored Proc Failures     UDF Failures             Trigger Failures        
     Parallel Fallbacks       Parallel Reduced         XML Storage Used        
     Parallelism Used         Nested Functions Used    LOB Storage Used        
     Accelerator Used         Accelerator Failures     Accelerator-eligible    
     Sparse Index Disabled    Sparse Index Workfile    Array Var Expand >32K   
     Fast INSERT used         zHyperlink Used          zHyperlink-eligible     
   Exception/Condition Filters - TLDS only:                                    
     Accelerator Rollbacks                                                     
2. Verify the time in the Required Query Criteria section. You can override both the Start Time and the Duration.
3. In the Optional Qualifiers section, specify one or more qualifiers, such as one or more plans, or a generic plan such as ABC*.Multiple qualifiers of one type are ORed. Multiple qualifiers of different types are ANDed, so that all conditions must be met.

4. In the Exception and Condition Filters section, specify at least one exception or condition filter that you know exists in your trace data.The Exception and Condition Filters include critical thread failures that are good indicators of potentially poor performance. Only threads that meet at least one of the filter criteria will be retrieved.

   Warning

   Note

   Specifying additional filters and qualifiers is highly recommended. If too many records meet your search criteria, only a subset of those records might be returned, along with a message that suggests specifying additional filters.

5. Scroll down to display the next screen of the panel. 

                              Select threads to display
    COMMAND ===>                                              SCROLL ===> CSR   
                                                                       MORE:-+  
    Value Filters - all sources:           Oper Value                  
    Get Pages - any/all BP                                             
    Synchronous Read I/O - any/all BP                                  
    Asynchronous Pages Read - any/all BP                               
    Lock Suspends - Local and Global                                   
    Insrt/Upd/Del/Mrg/Trunc SQL Statements                             
    DML SQL Statements                                                 
    DDL SQL Statements                                                 
    Commits                                                            
    Total Elapsed                                            (hh:mm:ss)
    Total CPU                                                (hh:mm:ss)
    In DB2 Elapsed                                           (hh:mm:ss)
    In DB2 CPU                                               (hh:mm:ss)
    Total Class 3 Wait                                       (hh:mm:ss)
    zIIP Total CPU                                           (hh:mm:ss)
    zIIP in-DB2 CPU                                          (hh:mm:ss)
    zIIP-eligible CPU on CP                                  (hh:mm:ss)
    Accelerator Elapsed - any/all Q8AC                       (hh:mm:ss)
    Accelerator CPU - any/all Q8AC                           (hh:mm:ss)
    Accelerator Wait - any/all Q8AC                          (hh:mm:ss)
    Accelerator-eligible Elapsed                             (hh:mm:ss)
    Accelerator-eligible CPU                                 (hh:mm:ss)
    Accelerator-eligible zIIP                                (hh:mm:ss)
    Accelerator Rows I/U/D - any/all Q8AC                              
    Accelerator I/U/D Stmts - any/all Q8AC                             
    Accelerator DML Stmts - any/all Q8AC                               
    Accelerator DDL Stmts - any/all Q8AC                               
    Value Filters - TLDS only:             Oper Value                  
    Accelerator Commits - all Q8AC                                     
    Value Filters - MVDB2DC only:          Oper Value                  
    Lock Suspends - Local                                              
    Lock Contention Wait                                     (hh:mm:ss)
    Latch Contention Wait                                    (hh:mm:ss)
    I/O Elapsed Wait                                         (hh:mm:ss)
    Other Read I/O Wait                                      (hh:mm:ss)
    Other Write I/O Wait                                     (hh:mm:ss)
    Page Latch Contention Wait                               (hh:mm:ss)
    Global Contention L-lock Wait                            (hh:mm:ss)
                                                                     
    END to exit saving changes                                         
    CANCEL to exit without saving changes
    HELP to view related help             
    RESET to reset to initial data

   For any of the value filters, you can specify the value of your choice and a logical operator, such as GT (greater than) or EQ (equal). For example, you might want to retrieve only the records that exceed 10 seconds of In-Db2 elapsed time.

   The filters are different for TLDSs and BMC AMI Ops Monitor for Db2 Data Collector trace data sets; these differences will be addressed in future releases of BMC AMI OpsM for Db2.

   For more information about the filters, see the online Help.

6. Specify a value filter in the In DB2 Elapsed field.
7. Review the values that you specified and then press F3 to submit the query.The thread records that meet your criteria are displayed in the TRLTRAC view. You can then use any of the thread analysis options discussed previously in this section.

8. After you complete your analysis of these threads, press F3 until you return to the HTLOGS view.

   Success

   Tip

   The previous scenarios described methods to analyze even very large thread volumes and drill down to detail data. However, to simplify access to specific threads or applications of interest, you might want to consider running one or more summary exception traces with TLDSs. These trace requests are fairly inexpensive to run, and you can filter the threads and store only those threads needed for later analysis, which will save storage, processing time to retrieve the records, and analysis time. For more information, see Overview-of-thread-history-collection-and-data-sources.