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.

System and SQL Performance for DB2 main menu

The System and SQL Performance for DB2 main menu provides access to all major System and SQL Performance product functions.

Related topic

Getting-started-with-SQL-Performance

Warning

Important

The following figure is only displayed when you have installed both the SQL Performance for DB2 and BMC System Performance for Db2 solutions.

DOMESELT/I            System and SQL Performance for DB2              21:17:10
Command ====> ________________________________________________________________
                                                                             
Current Data Collector :         Status :                                     
                                                                             
  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      

The main menu contains the following options:

  • Use System Performance Solution to access the features and functions of the System Performance solution components.
  • Use the options under SQL Performance Solution to access the features and functions of the SQL Performance solution components.
  • Use DOMPLEXes to select a DOMPLEX for monitoring Db2 or to change from one active DOMPLEX to another.
  • Use Session Status to view information about the status of the currently-active Db2 subsystems.
  • Use User Options to view and modify the options used to tailor your session to your needs.
  • Use Log Operations to create and modify user-defined collections of plans, programs, correlation IDs, and users representing the workload associated with a specific business function or individual.

  • Use Administration to modify user profiles and option sets and to view zap maintenance.

    Warning

    Important

    This option is displayed on your menu only if you have administration authority.

  • Use Help to learn about the online Help facility, to see an overview of the System and SQL Performance products, and to explore online Help topics.

    Warning

    Important

    This applies to the online Help system used by all System and SQL Performance products except OPERTUNE for DB2 and BMC AMI SQL Explorer for Db2.

  • Use Exit to terminate your session.
  • Use About the System and SQL Performance Products to view copyright and trademark information about System and SQL Performance and to obtain Internet and e-mail addresses for BMC Software Sales and Customer Support.

The main menu that is displayed depends on the System and SQL Performance for DB2 products and solutions that are installed and active at your site. If multiple products or solutions are installed, the main menu displayed reflects the active product mix. The preceding figure is an example of the main menu that is displayed when all System and SQL Performance products for Db2 are installed.


 

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

SQL Performance for DB2 13.1