More news from Optim land to help you manage DB2 performance. We just announced and today released a new version of IBM InfoSphere Optim Performance Manager 5.1 (for DB2 for Linux, UNIX and Windows servers) and a new product offering IBM InfoSphere Optim Configuration Manager 2.1, which is available for both DB2 for z/OS and DB2 for Linux, UNIX and Windows servers.
InfoSphere Optim Performance Manager 5.1 is a major release in which we re-architected the server to take advantage of the DB2 9.7 state-of-the-art in-memory metrics monitoring capabilities. We significantly reduced monitoring overhead and increased scalability for monitoring partitioned systems, reduced disk footprint for performance data, and improved retrieval times. I encourage you to read about all the new features in the announcement letter, but here are a few of my favorites:
- All dashboards that use in-memory metrics data collection now feature the ability to display data collected at any point in time, whether now, yesterday, last week, or last year. I particularly like the ability to view trends instantly by just selecting the time frame.
- Performance history needed for need to detect trends, plan capacity and for service reporting now has automated rolling aggregation at 4 level with user-defined retention periods so you can keep data longer at lower cost.
- List, filter, sort, analyze, and report on database connections and
resource consumption across server, I/O, row, transaction, locking,
communication, and utilities.Pretty much anything you would want to see about connections.
- Lots of improvements in SQL dashboards that let you view top executions of SQL statements or aggregated metrics and integrate with InfoSphere Optim Query Workload Tuner 3.1 just released in October.
- Many new reports are available. My favorite is the SQL comparison report that makes it easy to find SQL performance improvements or regressions before and after changes.
- Dashboards now have enhanced analysis for database partitions and DB2 pureScale members.
- With a new best practices template for DB2 Workload Manager configuration, you can get up and running quickly with DB2 Workload Manager for warehouse environments.
For more detailed information, see the information center.
InfoSphere Optim Configuration Manager 2.1 is available for both DB2 for Linux, UNIX and Windows and DB2 for z/OS environments. It provides centralized management of database and client configurations to get insight into IT environments, reduce database outages, and improve compliance to enterprise standards. Top features enable DBAs and other staff to:
- Discover client information
for databases, such as host name, IP address, user ID, client version
information and track their access to data servers. Get a complete view of database client and DB2 server topology. Check whether your driver upgrade has been completed.
- Redirect clients from one database to another, one subsystem to another, or one member to another. This centralized management improves DBA control over staged migrations or lets them isolate poorly behaving applications to mitigate impact to others..
- Define and enforce official
connection definitions to support workload balancing and workload
management objectives. A disconnect between developers (who set connection properties) and DBAs or systems administrators (responsible for workload balancing and resource allocation) makes it hard to get the right level of control. Now you can push down the right properties to enable data sharing or Workload Manager to be more effective in workload balancing and resource allocation.
- Track database and client
configuration changes to help determine the root cause for performance
degradation. InfoSphere Optim Performance Manager also surfaces integration with Configuration Manager so you can see what changed while investigating performance issues.
Check out our Configuration Manager demo that highlights several of the features above. You can read more about InfoSphere Optim Configuration Manager in our announce letters for offerings on Linux, UNIX, and Windows or on z/OS
or in the information center.
If you have any feedback, please post here or to our Performance Management forum.