Using additional features

Find information about how to use Db2 Query Monitor's additional features.

Using smarter reorganization recommendations
Db2® index and table space reorganizations are frequently used to improve application performance, and real-time statistics can be useful in indicating whether a REORG is needed. However, there are times when real-time statistics might indicate that a REORG is needed, but the application is accessing data in a way that is not impacted by disorganized data. IBM® Db2 Automation Tool for z/OS® can work with Db2 Query Monitor to leverage the SQL performance data that Db2 Query Monitor collects on your application objects to determine if a reorganization is necessary. Using these products together helps your organization avoid unnecessary reorganizations, thereby reducing CPU cycles, memory use, disk space usage, and the impact on your applications.
Offloading data to the Performance History Database
Use the procedures in this section to offload data from your Performance History Files (VSAM files) to a Performance History Database. You can tailor this process to offload selected Performance History Files, intervals, time periods, or data types. The load process maintains data uniqueness across z/OS systems, Db2 subsystems, and Query Monitor Subsystems.
Offloading data to Analytics Accelerator
Use the procedures in this section to offload data from your Performance History Files (VSAM files) to IBM Db2 Analytics Accelerator for z/OS (Analytics Accelerator). You can load Db2 Query Monitor data to Analytics Accelerator in order to bypass Db2, reduce cost, and reduce the time that is required to make data available.
Configuring Query Monitor for OMEGAMON Data Provider
This section focuses on the configuration needs specific to Db2 Query Monitor when using OMEGAMON Data Provider (ODP) to stream data to external analytics platforms, such as IBM Instana, Splunk, Elastic, and Prometheus. It provides you information on Db2 Query Monitor unique configuration items for OMEGAMON Data Provider.
Detecting a loop in an application
You can use Db2 Query Monitor to detect a loop within an application that is running on a thread or a Db2 subsystem.
Using advanced functions to process SQL error alerts
This topic describes advanced features and techniques that you can use to process SQL error alerts captured by Db2 Query Monitor. SQL errors are captured by Db2 Query Monitor. However, determining the reason for such SQL errors has required a user to log in to one of the user interfaces to determine the root cause of the error.