Integrating


This topic describes how you can integrate the different System and SQL Performance for DB2 products.

When a single product is enabled, the main menu for that product is displayed.

When multiple products or solutions are enabled, the main menu that is displayed reflects the active product mix. The following figure is an example of the main menu that is displayed when all System and SQL Performance for DB2 products are enabled.

System and SQL Performance for DB2 main menu

OMESELT/I            SYSTEM AND SQL PERFORMANCE FOR DB2              18:17:30
COMMAND ====> ________________________________________________________________
                                                                              
CURRENT DATA COLLECTOR : FM01    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

When multiple products share a product session, functions that are shared by all products are shown on the initial main menu. Select a product from the main menu to display the main menu for that product. Functions that are specific to each product are accessed through the product’s main menu.

All products share the same Data Collector and the same LOGFILES. If you select a different Data Collector in any product, the Data Collector is changed for all products.

 Note

Filters set in Apptune have no effect on Pool Advisor or System Performance reports, because those products do not support filtering.






 

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