Features and Benefits
Are you interested in customizing and tuning your SQL workload and DB2 objects to make DB2 subsystems more effective?
Do you want more choices in determining what monitoring information to gather...and when to collect it?
Do you wish you could lower the overall cost of queries?
IBM DB2 Query Monitor gives you the ability to efficiently customize and tune your structured query language (SQL) workload and DB2 objects to ensure the effectiveness of your DB2 subsystems and improve overall performance. The tool offers you extensive choices so you can determine what monitoring information you will gather, and when.
ISPF view of Data Sharing Group allows users to view data from the perspective of a data sharing group. A drill-down in Activity Summaries by DB2 Data Sharing Group is available. When you view at the group level, all of the summarization is at the group level.
A series of sample batch reports are provided to assist Query Monitor users with identifying workloads that are potential candidates for tuning.
A full-featured CAE Web Client provides access through a Web browser to all functionality previously provided by the CAE Client. The CAE Web Client provides the ability for users to seamlessly browse Query Monitor data that has been offloaded to DB2 and to view pie charts of activity data. The CAE Web Client also provides data navigation that is easier for Query Monitor ISPF users to learn.
DB2 Query Monitor 3.1 supports Windows 7.
A number of changes to DDL are implemented in Version 3.1 to introduce new columns on existing tables.
DB2 Query Monitor's offload migration process offers paths for migrating V2.3 data to V3.1 DB2 offload tables.
Provides new metrics indicating the amount of zIIP processor usage, viewable in the Activity Summaries and Exceptions/Current Activity data. When a particular SQL ends and is seen by the CQM collector, the CPU will be examined and the amount of CPU will be added to the current DB2_CPU_TIME metrics fields and the new DB2_CPU_TIME_ZIIP field.
GUI-based reporting, viewing, and configuration capability enables you to access consolidated data and events for DB2 subsystems, whether within a single z/OS image or across multiple z/OS images independent of the existence of a coupling facility. You can also view and configure monitoring across your enterprise from a single console.
A consolidated view of data sharing group activity provides a view of SQL workload information from the perspective of a data sharing group as a whole.
Enables the collection of query activity information at increased levels of granularity, down to the level of the individual table and index and related back to the exact request or to the user who is requiring the access.
Autonomic capabilities, such as proactive event notification, provide alerts to exceptional events on a monitored DB2 subsystem in real time. Knowledge-based analysis examines exceptional events to determine underlying problems, such as lock delays or poor buffer pool hit ratio, and presents them to the user.
Additional autonomic functionality enables DB2 Query Monitor to execute user-configurable responses including e-mail notifications and corrective actions such as console commands and batch job submission when exceptional events occur.
An enterprise deployment option enables you to leverage the additional functionality provided by the open systems architecture and provides you with the information you need to accurately assess and manage your SQL workload.
Users can view all the SQL statements that are open in DB2 including queries in nested cursors which help debug solutions.
Interval-based VSAM backstores (VSAM data sets that hold information gathered by the collection points in DB2 Query Monitor) are created for each collection point on a per-interval basis for such data as SQL metrics, DB2 object access, SQL text, DB2 commands, and negative SLQCODES. Information about the exceptions and notifications that DB2 Query Monitor recognizes and sends are also written to backstore data sets on a per-interval basis.
Optional keys are controlled via the OPTKEYS parameter in the CQMPARMS data set. They enable the collection of additional information about query activity to help determine the origin of query activity and problems.
Collection and reduction of buffer pool statistics enable you to collect buffer pool usage information about SQL-related exceptional events.
Provides the ability to drill down into prior selections while navigating within the summary displays. A new KEYMAP command shows the navigation path you have selected. An almost anywhere to anywhere selection path within summaries is provided.
Interval Midnight allows you to align intervals so the first interval of each day starts at the midnight hour.
