Using additional features Find information about how to use Db2® Query Monitor additional features. Using smarter reorganization recommendationsDb2 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 to leverage the SQL performance data that Db2 Query MonitorDb2 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 databaseYou can offload data from your Db2 Query Monitor VSAM performance history files to the Db2 tables in Db2 Query Monitor 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 AcceleratorUse 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 to bypass Db2, reduce cost, and reduce the time that is required to make data available.Db2 Query Monitor as a data source for OMEGAMON Data ProviderIBM Z OMEGAMON Data Provider takes z/OS® data, such as metrics and events, and makes it available to analytic platforms, such as IBM® Instana, Splunk, Elastic, and Prometheus. You can set up Db2 Query Monitor to be used by OMEGAMON Data Provider as a z/OS® data source. Detecting a loop in an applicationYou 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 alertsThis 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.