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.

Using multiple System and SQL Performance for DB2 products

The 

System and SQL Performance for DB2

 products from BMC Software are a family of tightly integrated performance monitoring and management tools for Db2.

Most of the products share the same dialog architecture, enabling data sharing and exceptional ease of use across products. The following products can share the same started task and can be accessed through a common dialog:

  • BMC AMI Apptune for Db2—A tool for tuning SQL statements and troubleshooting Db2 application performance.
  • BMC AMI Pool Advisor for Db2— A tool for monitoring Db2 pools, identifying inefficient use, and suggesting and implementing modifications to gain maximum benefit from storage resources.
  • BMC AMI SQL Explorer for Db2—A tool for analyzing SQL statements and database structures to optimize application performance.

  • BMC AMI Ops Monitor for Db2 - Data Collector—A selectable component of the BMC AMI Ops Monitor for Db2 product that allows MainView users to share some functions of the Performance Activity products Data Collector.

    This component provides access to Db2 performance data that supplements the data already available via BMC AMI Ops Monitor for Db2.

  • BMC System Performance for Db2—A solution that combines the features and functions of BMC AMI Ops Monitor for Db2, OPERTUNE for DB2, and BMC AMI Pool Advisor for Db2 with a supplemental set of comprehensive reports on all aspects of Db2.
  • SQL Performance for DB2—A solution that combines the features and functions of the BMC AMI Apptune for Db2 and BMC AMI SQL Explorer for Db2 components with a comprehensive index reporting function that is available only with the solution.

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.

 DOMESELT/I            System and SQL Performance for Db2              01:55:40
 Command ====> ________________________________________________________________
                                                                               
 Current Data Collector : BC1D    Status : ACTIVE                               
                                                                               
   Select one of the following options.  Then press Enter.                      
                                                                               
 _  D. System Performance Solution  - Db2 subsystem and storage pool analysis   
                                                                               
    --- SQL Performance ---                                                     
    Q. BMC AMI Apptune for Db2      - Db2 application and index analysis        
    S. BMC AMI SQL Explorer for Db2 - 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 trace data sets. If you select a different Data Collector in any product, the Data Collector is switched in all products.

Important

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*