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:
- Multi-temperature 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 well
- 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.
- pureScale – 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. .
- More 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.
- At-a-Glance performance overview and baseline – Finally, and for me the most exciting, is our introduction of baseline support. This is actually just 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 overall as well as within DB2, workload, and specific tabs for examining locking, I/O, and SQL processing. From here you can set baselines using the time 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 At-a-Glance view