Skip to Content
Information
Space announcement This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Viewing reports

The reporting process begins at the 

Apptune

 and Index Component Main Menu.

From the Apptune and Index Component Main Menu, invoke the SQL Workload Analysis Menu to specify data collection criteria.

Related topic

Index-component


Apptune and Index Component Main Menu

IODESELC/I           APPTUNE and Index Component Main Menu            14:34:38
Command ====> ________________________________________________________________
                                                                             
Current Data Collector : NC1J    Status : ACTIVE   Data Collection : READY    
                                                                             
Select one of the following options.  Then press Enter.                       
                                                                             
_  0. Statement Cache      - Analyze SQL statement cache statistics           
   1. SQL Workload         - Analyze current and historical SQL workloads     
                                                                             
   3. Explain Interface    - Explain an SQL statement                         
                                                                             
   4. Application Profiles - Create and maintain application groups           
   5. Command Interface    - Issue commands, view responses                   
                                                                             
   D. Archive Directory    - View/manage the directory of trace archives      
                                                                             
   Z. About APPTUNE

SQL Workload Analysis Menu

 ASQEWAM1/I               SQL Workload Analysis Menu                   03:56:11
Command ====>___________________________________________________________
                
Report Criteria:                                                              
 Source of data  . . . : Subsystem MB2D                                       
 For DB2 SSIDs . . . . : *                                                    
 Start time  . . . . . : 02/03/2022 03:00:00                                  
 Duration  . . . . . . : No time limit                                        
 Initial report  . . . : PLAN ANALYSIS (DATA)                                 
 Application profile . : DEFAULT             Owner :                          
 Workload focus  . . . : NONE                Qualified: N                     
                                                                             
Select one of the following options.                                          
                                                                             
_ 1. Workload analysis        - Begin workload reporting                      
  2. Initial report           - Select the initial report to be viewed        
  3. Report type              - Select the report type (data or graph)        
  4. Application profile      - Select the profile for group reporting        
  5. Time interval            - Specify the time frame for reporting          
  6. Data source, DB2(s)      - Select data source and DB2 subsystems         
  7. Workload focus           - Specify options for faster report access

This section contains the following topics:

 

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

SQL Performance for DB2 13.1