Product integrations

Db2® Query Monitor integrates with other tools to analyze SQL performance and tune SQL queries.

You can set up integrations between Db2 Query Monitor and the following tools:

IBM® OMEGAMON for Db2 Performance Expert on z/OS®

Product description: IBM OMEGAMON for Db2 Performance Expert on z/OS (OMEGAMON for Db2 PE) provides real-time and historical performance and availability management for individual z/OS systems, networks, and storage subsystems.
Overview of integration: In CAE, you can join data offloaded from Db2 Query Monitor with data in OMEGAMON for Db2 PE tables by using the CLIENT_ENDUSER column in the CQM_EXCEPTIONS performance history database table. For more information, see OMEGAMON integration.
Requirements: IBM OMEGAMON for Db2 Performance Expert on z/OS

IBM Db2 SQL Performance Analyzer for z/OS

Product description: IBM Db2 SQL Performance Analyzer for z/OS (SQL PA) provides a performance analysis of SQL queries before they are run so that you can tune them to minimize the performance cost.
Overview of integration: You can export SQL statements from Db2 Query Monitor to a data set that can be analyzed by SQL PA.
For more information, see Exporting SQL text to a data set.
Requirements: For information about the requirements for this integration, see Optional: Customization tasks for integration with SQL PA.

IBM Db2 Analytics Accelerator for z/OS

Product description

IBM Db2 Analytics Accelerator for z/OS (IDAA) enables you to query data at high speeds, extend the capabilities of Db2 for z/OS, and lower operating costs.

Overview of integration

Db2 Query Monitor provides information about accelerator-eligible SQL, such as estimates of CPU and elapsed time savings for queries that might be run on an IDAA appliance. Db2 Query Monitor reports the potential savings from the Db2 subsystem level down to the SQL statement level or call level.

Data from Db2 Query Monitor can be loaded to accelerator tables. Alternatively, data from both Db2 Query Monitor and an accelerator can be loaded to Db2 tables, offering possible integration of data.

Db2 Query Monitor reports whether a query ran in IDAA. Db2 Query Monitor also reports information about SQL workload that would have been accelerated, if an accelerator had been available and all tables had been loaded to the accelerator.

The CAE browser client can use Db2 Query Monitor offload tables with data that was loaded to an accelerator as a source for an archive connection.

For more information, see Displaying IBM Db2 Analytics Accelerator for z/OS information and Adding an archive connection.

IBM Db2 Analytics Accelerator Loader for z/OS

Product description: IBM Db2 Analytics Accelerator Loader for z/OS (Analytics Accelerator Loader) provides the ability to load data into Db2 for z/OS and IDAA.
Overview of integration: Analytics Accelerator Loader can be used to offload data from Db2 Query Monitor to IDAA. For details, see Offloading data to Analytics Accelerator.

IBM Db2 Automation Tool for z/OS

Product description

IBM Db2 Automation Tool for z/OS (Db2 Automation Tool) enables you to oversee routine database administration tasks without manual interventions and set up reoccurring utility jobs for conditional and routine Db2 maintenance tasks.

Overview of integration

Db2 Query Monitor integrates with Db2 Automation Tool to leverage the SQL performance data that Db2 Query Monitor collects on your application objects. Using these products together helps you avoid unnecessary reorganizations, thereby reducing CPU cycles, memory use, disk space usage, and the impact on your applications.

The Reorganization Recommendation Monitor component of the CAE browser client enables you to view reorganization recommendations and analyze performance windows that have been captured as potential candidates for reorganization analysis. You can also view information about the thresholds that are currently used to evaluate your data.

For more information, see Using smarter reorganization recommendations and Using the Reorganization Recommendation Monitor.

Requirements

For information about the requirements for this integration, see Prerequisites for the smarter reorganization recommendation feature.

Query workload tuning clients

Product description: Query tuning clients such as IBM Data Server Manager allow you to analyze and tune SQL queries.
Overview of integration: The query tuning options in the Application menu of the CAE browser client provide access to features such as query tuning, host variable collection, and staging tables. For more information, see Query tuning.
Requirements: For information about the requirements for this integration, see Requirements for query tuning integration.