DB2 for i5/OS On Demand Performance Center and Futures
Meeting will be held on March 21, 2007.
On Demand Performance Center is a new set of comprehensive performance
analysis and tuning tools provided in DB2 for i5/OS V5R4.
These tools have been designed to be On Demand. For example, index advice
is available instantly without having to run any type of monitoring or
analysis tool.
You can instantly view the most expensive queries (both static and dynamic)
and analyze them without having to run any type of monitoring or package
analysis tool.
And since DB2 for i5/OS is integrated into System i, the tools are provided
at no charge as a part of i5/OS Navigator on every System i V5R4 system.
Tools to Manage Indexes and MQTs
- Show Indexes (enhanced)
- Show Materialized Query Tables (new)
- Manage Index Rebuilds (new)
- Index Advisor (new)
Tools to Monitor and Analyze the SQL Plan Cache
- Filter and Show SQL Plan Cache (new)
- SQL Plan Cache Snapshots (new)
- Analyze (new)
Tools to Monitor and Analyze SQL Performance
- Performance monitor filtering (enhanced)
- Explainable Statement filters (enhanced)
- Analyze (enhanced)
- Compare monitors (new)
Tools to Control Resource Intensive Queries
- Resource Governor (new)
- Governor Exit Point (new)
Tools to Show Current Activity
- Statistics Requests (enhanced)
- Current SQL for a Job (enhanced)
Tools to Show Current Database Limits and Sizes
But we are not done yet...several additions to the On Demand Performance
Center have been designed for a future release of i5/OS.
Mark Anderson can be reached at mja@us.ibm.com