Here is my promised update on InfoSphere Optim Performance
Manager (OPM) 5.1.1 that will be available April 30th. As I
mentioned in my earlier posting Optim
Releases Support DB2 10, the majority of the enhancements are in support of
DB2 10 features, so let me go over those first:
support – DB2 10 multi-temperature data management allows you to store
different portions of your data on different classes (speed and cost) of
storage so that you can match access requirements to underlying storage
and non-disruptively change them over time as data ages and
as access requirements change. “Storage groups” are used to define the
different classes of storage and tables spaces are now defined within a
storage group. OPM adds monitoring
support for storage groups showing the table space to storage group
relationship on alerts and dashboards and provides a new storage group
report to understand utilization and growth. In addition, DB2 Workload Manager (WLM)
was enhanced to enable prioritization based on the storage group of the data
accessed. These features are enabled through the OPM user interface as
- Multiple HADR – DB2 10
supports configuring multiple standbys now. OPM has improved alerting for high
availability and disaster recovery (HADR) environments including additional
alerts regarding standby connection and readiness, alerts regarding logging
issues between the primary and standby, and distinguishing a single failed
standby from last remaining failed standby.
– DB2 10 continues to enhance the pureScale feature and OPM continues to
enhance its monitoring of pureScale deployments. New alerts recognize
cluster alerts failure, additional state changes in the cluster facility,
and threshold alerts on group buffer pool hit ratio and cluster cache
facility virtual memory, and page reclaim rate. DB2 10 enables WLM for use
with pureScale and OPM is enhanced to support that configuration as well.
- WLM Dispatcher – DB2 10 provides a new WLM dispatcher feature that allows you to manage what percentages of CPU resources are
assigned to service classes.
OPM surfaces the options for
dispatcher shares and limits in the OPM WLM configuration panels.
In addition, there are a few enhancements apart from DB2
10 support I want to mention that I think you’ll be excited about.
- User-defined Alerts – We get requests for additional alerts
that are beyond our ability to fit into plan in the short term. Thus we
are enabling user-defined alerts which will give you the ability to write your
own SQL or scripts to detect issues and link them into the OPM standard
alerting, notification, and blackout infrastructure. Now you can generate alerts for errors in db2diag.log, canary
queries, or other alerts important to your environment. We will have some sample scripts in the Information Center.
granular collection intervals – OPM configuration is based on
user-specified collections intervals. Now you can specify different
collection intervals for different kinds of data. For example you might
want to collect buffer pool information every minute but table space
information every hour.
performance overview and baseline – Finally, and for me the
exciting, is our introduction of baseline support. This is actually
the first step in a series of planned enhancements in this area.
The At-a-Glance view appears in the Overview dashboard as a new tab and
provides a higher level view of system activity: CPU distribution
as well as within DB2, workload, and specific tabs for examining
I/O, and SQL processing. From here you can set baselines using the
slider to select the baseline timeframe. Once a baseline is set,
the At-a-Glance values are automatically compared to the baseline and
significant deviations indicated. Here’s a simple example of the
More information, including the Information Center
updates, will be available with the general availability.
Holly Hayes, InfoSphere Optim Tools Product Manager