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 a SQL 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
The MainView for DB2 - Data Collector component provides access to Administration functions of the System and SQL Performance products environment by a hyperlink from a MainView for DB2 Easy Menu. For more information, see the .
The following topics describe additional customization tasks that are specific for the System and SQL Performance products: