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.
Filters set in Apptune have no effect on Pool Advisor or System Performance reports, because those products do not support filtering.