Wouldn’t it be great to quickly and efficiently identify the SQL statements that are costing you the most, and only then invoke more costly collection activities to obtain the data you need to tune those statements?
As a Db2 DBA, you are responsible for maintaining the performance of SQL executed by all the applications that connect to Db2 for z/OS. But it can be frustrating to accommodate the costs of collecting all the necessary performance metrics. You end up collecting metrics for a large set of SQL statements, most of which are performing just fine, solely to ensure that you have the measurements you need for those few that are not.
BMC has solved these problems with innovative technology that we call “SmartTune” – part of our SQL Performance solution.
The idea is to rapidly identify the SQL statements that are costing the most to execute, and only then collect more performance metrics about only those statements. We have developed a less intrusive and much less expensive method to collect the cost of each statement, by exploiting the performance metrics found in the Db2 statement cache for both static and dynamic SQL. Customers will find that this is sufficient information to identify problem SQL, without collecting detailed (and expensive) data on ALL statements.
We plan to eventually automate the process of collecting detailed metrics for the statements identified by SmartTune, thus closing the tuning loop. You can limit detailed collection manually as soon as SmartTune is delivered, and find immediate savings in the costs of extracting SQL performance metrics.
SmartTune is planned to be included in SPE1811, our delivery of enhancements in the maintenance stream. BMC’s Continuous Delivery program continues to deliver a stream of meaningful enhancements to all our Db2 products. Please contact your Account Manager for more information.
Talk to your BMC account team or a BMC salesperson about the use of BMC SQL Performance tooling, and how that can help you avoid the costs associated with poorly performing SQL. Ask them about the “SmartTune” feature that will allow you to do this much more effectively and cheaply, making sure that the minimal costs of monitoring your SQL are focused on finding problem SQL.
These postings are my own and do not necessarily represent BMC's position, strategies, or opinion.