pureQuery Saves CPU

Actions speak louder than words. So if you want to be appreciated as a DBA, save your company big bucks and CPU resources by improving DB2 performance.

These days it seems everyone is running out of CPU capacity on their UNIX machines and on the mainframe. With pureQuery you can provide a way to help your company save real money—potentially 20% of the CPU—by improving the DB2 performance of your dynamic SQL Java applications.

Saving CPU is never easy especially with all the new dynamic SQL Java applications. It is even tougher to tune these dynamic applications since there is either an ORM (object relationship mapping) layer in the middle or no other references back to the source Java modules. The dynamic SQL overhead of extra object verification, security re-validation and access path generation is tremendous if the module is not found in the cache.

The relatively new IBM pureQuery product is now available to eliminate these overhead issues by providing a way to capture the dynamic SQL Java application workload and produce a file that can then bind the various Java SQL modules within the system. This transforms the dynamic workload to a static SQL workload with hooks for debugging back to the source Java modules.

In working through the beta program and now implementing pureQuery with DB2 consulting clients, I’ve seen that the dynamic to static transformation can save up to 20% of these CPU workloads. This can dramatically reduce your software licensing MSUs and quickly bring down your company’s overall software costs, including costs for third party software licensing.

Another aspect is that pureQuery may already be licensed by your company through your enterprise DB2 Connect license agreement or may only require an upgrade fee to make it available. IBM is starting to aggressively price pureQuery, so you may be able to get it fairly inexpensively. You can start a trial and show how much CPU it will save your environment if your company spends a little money.

Saving 20% CPU can mean millions of dollars in some environments. How much would it in your DB2 environment? Tease your management with the potential dollar savings figures and then see if they pay attention and begin appreciating the DBAs again.

On June 29th I will be doing a DB2 training IDUG webcast entitled Boosting DB2 V9 for z/OS Performance which is all about getting the most out of the new version of DB2. This DB2 training presentation is designed to highlight all the new DB2 performance parameters and technical features to exploit them within your V9 implementation. The DB2 training presentation highlights the new DB2 9 features, along with all the current features, functions and techniques that impact your DB2 system and application performance.

This presentation also briefly discusses the new and existing architectural, database and application performance aspects along with tuning considerations so you can dramatically reduce your DB2 CPU and I/O costs. This presentation will discuss potential problem areas and the improvements that can be made in system configurations, database designs within batch, online and Java applications. You will learn the vital preparation activities and the best techniques to improve DB2 performance and fully exploit your DB2 z/OS Version 9 environments.

Sign up and look at the www.idug.org for the webcast sign-up information.

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>