Updated on December 15th to correct announcement letter URLs.
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
- 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
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.
Holly Hayes, Optim Tools Product Manager