Customizing System and SQL Performance

The System and SQL Performance products and solutions for Db2 provide an integrated environment that allows you to use one performance product or solution alone or multiple products or solutions together.

Using products together saves time and further automates performance analysis functions. The integrated environment from which the products operate allows all products to operate concurrently without placing unnecessary burdens on system storage, resource use, or execution time.

When multiple System and SQL Performance products or solutions are installed and active, they share a common interface. If multiple products are installed but only one product is active, the product-specific main menu for the active product is displayed instead of a common main menu. The main menu that is displayed reflects the active product mix.

The following example shows the main menu for aSQL Explorer follows:

 DIY4 -------------------------- SQL EXPLORER vv.rr.mm -----------------------
Command ===>                                                                 
                                                                              
Option . .    0. Options                                                      
              1. Explain                                                      
              2. Explain and Compare                                          
              3. Compare                                                      
              4. Mismatch Analysis                                            
              5. Impact Analysis                                              
              6. DBRM / Load Compare                                          
              7. Migrate Access Path Statistics                               
              8. Declarations Generator                                       
              R. SQL Explorer Rules Help                                      
              M. Maintenance                                                  
                                                                              
SSID . . . . . DIY4                                                          
DDF Location

The following example shows the main menu that is displayed when all System and SQL Performance products and solutions are installed and active:

              DOMESELT/I            System and SQL Performance for DB2              18:17:00
Command ====> ________________________________________________________________
                                                                               
Current Data Collector : A62D    Status : ACTIVE                               
                                                                               
SELECT ONE OF THE FOLLOWING OPTIONS.  THEN PRESS ENTER.                     
                                                                              
_ D. SYSTEM PERFORMANCE SOLUTION - DB2 SUBSYSTEM AND STORAGE POOL ANALYSIS   
                                                                              
   --- SQL PERFORMANCE SOLUTION ---                                           
   Q. APPTUNE AND INDEX COMPONENT - DB2 APPLICATION AND INDEX ANALYSIS        
   S. SQL EXPLORER COMPONENT      - DB2 SQL ANALYSIS                          
   A. PERFORMANCE ADVISORS        - ADVICE AND RECOMMENDATIONS                
                                                                              
   1. DOMPLEXES                   - SELECT/CHANGE DOMPLEX CONNECTION          
   2. SESSION STATUS              - VIEW CURRENT SESSION RESOURCE USAGE       
   3. USER OPTIONS                - VIEW/MODIFY USER OPTIONS                  
   4. LOG OPERATIONS              - VIEW/PRINT LOGGED SCREENS AND REPORTS     
   5. ADMINISTRATION              - MANAGE PRODUCT AND USER PROFILES          
                                                                              
   H. HELP                                              
   X. EXIT               Z. ABOUT THE SYSTEM AND SQL PERFORMANCE PRODUCTS

Important

The

BMC AMI Ops Monitor for Db2

- Data Collector component provides access to Administration functions of the System and SQL Performance products environment by a hyperlink from a

BMC AMI Ops Monitor for Db2

Easy Menu. For more information, see the MainView for Db2 documentation Open link

.

The following topics describe additional customization tasks that are specific for the System and SQL Performance products:

Customizing System and SQL Performance

Comments