Overview
The BMC System Performance for Db2 solution combines the features and functionality of a number of components to help you increase staff productivity and maintain performance consistency by tuning your Db2 system dynamically and automatically as workloads change.
The BMC System Performance for Db2 solution provides the following benefits:
- Improves application performance by providing intelligent real-time management and tuning of Db2 system resources and parameters that can adversely affect performance
- Reduces end-user response time
- Minimizes costs associated with Db2
- Optimizes the use of Db2 storage
- Increases staff productivity by providing advisor technology
- Avoids system problems and downtime by automatically detecting and correcting system problems
- Maintains performance consistency with constantly adjusting application workloads
BMC System Performance for Db2 includes the following components:
- BMC AMI Ops Monitor for Db2 (including BMC AMI Catalog Manager for Db2 (Browse only))
- BMC AMI Pool Advisor for Db2
- OPERTUNE for DB2
The solution comes with a comprehensive set of reports that lets you monitor all aspects of Db2 from one central report. You can quickly hyperlink from that report to other reports about specific data if an anomalous value is highlighted.
The System Performance report set combines the reporting abilities of the BMC AMI Ops Monitor for Db2 and BMC AMI Pool Advisor for Db2 components with a supplemental set of comprehensive reports on all aspects of Db2.
You can access all System Performance components through a common interface, and you don’t need to know which component to use to solve a problem. When it detects a problem, the solution guides you to the information you need to solve that problem, using the appropriate components to gather the information and make the needed changes.
BMC AMI Ops Monitor for Db2 component
The BMC AMI Ops Monitor for Db2 component is built to meet growing demands and continuous availability challenges.
It enables you to consolidate legacy and new technologies, turning information into the knowledge needed to manage business. It delivers new functionality to satisfy the needs of growing business demands for volume and availability. BMC AMI Ops Monitor for Db2 provides a variety of features including full data-sharing support, tuning wizards, customizable displays, multiple displays on one screen, and extended I/O analysis.
BMC AMI Ops Monitor for Db2 provides the most comprehensive, user-friendly set of monitoring and management tools that are available for Db2.
BMC AMI Pool Advisor for Db2 component
Pool Advisor provides a fast, accurate means of monitoring Db2 storage resources to help you identify and resolve problems as they occur.
Pool Advisor enables you to monitor the performance of Db2 activities in real time and to display data about the performance of the system in a readable, usable format.
Pool Advisor uses an advisor-driven system for retrieving pool-related data from Db2, reporting that data, detecting potential performance-related problems, and recommending actions to prevent those problems. Pool Advisor can operate under native TSO and ISPF.
OPERTUNE for DB2 component
The OPERTUNEcomponent allows you to modify Db2 subsystems to resolve performance tuning or operations management problems.
Using the simple OPERTUNE command syntax, you can change a DB2 ZPARM value dynamically. You can issue the commands by using the OPERTUNE ISPF interface, from a batch job step, or from the console. You can also define a set of ZPARM values to support a specific processing environment and then schedule the set to be issued to Db2 automatically. The schedule can be issued based on time of day and day of the week or on demand.
OPERTUNE performs these changes without bringing the Db2 subsystem down or logging users off the system. A RESET command can restore individual Db2 parameters to their original value or return all Db2 parameters that have been modified by OPERTUNE to their original values.