Product integrations

Db2 Query Monitor integrates with these products to allow you to better analyze SQL performance and tune SQL queries.

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

Product description: Provides real-time and historical performance and availability management for IBM z/OS operating system, networks, storage subsystems.

Overview of integration: The CLIENT_ENDUSER column (in Db2 Query Monitor CQM_EXCEPTIONS performance history database table) enables you to join data offloaded from Db2 Query Monitor with data in IBM OMEGAMON for Db2 Performance Expert on z/OS tables. 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

Provides performance analysis of SQL queries before they are run to enable tuning and cost minimization.

Overview of integration

You can export SQL statements from Db2 Query Monitor to a data set that can be analyzed by IBM Db2 SQL Performance Analyzer for z/OS.

For more information, see:

Requirements

IBM Db2 SQL Performance Analyzer for z/OS V2.1 and higher

IBM Db2 Analytics Accelerator for z/OS

Product description

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 IBM Db2 Analytics Accelerator for z/OS 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 accelerator can be loaded to Db2 tables, offering possible integration of data.

Db2 Query Monitor reports whether or not a query ran in IBM Db2 Analytics Accelerator for z/OS. 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 accelerator as a source for an archive connection.

For more information, see:

IBM Db2 Analytics Accelerator Loader for z/OS

Product description: Provides ability to load data into Db2 for z/OS and IBM Db2 Analytics Accelerator for z/OS.

IBM Db2 Automation Tool for z/OS

Product description

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 and 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:

Requirements

See Prerequisites for information about the requirements for this integration.

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: See Requirements for query tuning integration for information about the requirements for this integration.

OMEGAMON Data Provider

Product description: OMEGAMON Data Provider (ODP) streams data to external analytics platforms, such as IBM® Instana, the Elastic Stack, Splunk, Apache Kafka, and Prometheus. OMEGAMON agents monitor performance, behavior, and resource usage metrics of systems and applications on z/OS®. OMEGAMON refers to these metrics as attributes.; OMEGAMON Data Provider uses Push and Pull output methods, which are designed to be easily ingested by destinations outside of OMEGAMON (such as analytics platforms). Some output methods are for a specific analytics platform. Others, such as JSON Lines over TCP, are generic, and can be ingested by various analytics platforms. Analytics platforms that can ingest JSON Lines over TCP include IBM Instana Observability on z/OS (Instana), the Elastic Stack, and Splunk.; Additionally, some analytics platforms support more than one output method from OMEGAMON Data Provider.; For information on the elements that can be streamed and their descriptions, see Performance History Database tables and column descriptions.
Overview of integration: Db2 Query Monitor integrates with OMEGAMON Data Provider (ODP) to use the unique features of ODP that involve streaming data to external analytics platforms, such as IBM® Instana, the Elastic Stack, Splunk, Apache Kafka, and Prometheus. For more information, see Db2 Query Monitor as a data source for OMEGAMON Data Provider.
Requirements: See Configuring Db2 Query Monitor for OMEGAMON Data Provider for information about the requirements for this integration.