I'm excited to be co-presenting with one of our customers at IOD EMEA in May.  Roberta Barnabe, a DB2 Specialist for UGF (Unipol Gruppo Finanziario) Assicurazioni , will be sharing her experiences with IBM Optim Query Workload Tuner for DB2 for z/OS .  For any of you interested in z/OS query tuning and want to hear what someone besides we IBMers have to say, I encourage you to come hear what she has to say about: Statistics Advisor Dynamic statements analysis Access Plan Graph and Query Format What-if analysis Workload analysis Query... [More]

Tags:  iod smith query_tuner

 Hi, all. I am a developer on our Optim Query Tuner products. A new feature called ‘Compare Access Plan’ was shipped in Optim Query Tuner (for DB2 for z/OS) and Query Workload Tuner V2.2 fix pack 1 that allow DB2 for z/OS DBAs to compare the access path cost of SQL statements in packages between the latest two EXPLAIN versions. The tool generates a HTML report that provides high level package cost and individual package details. In this blog, I’ll describe how to launch the feature, and then I’ll describe some common scenarios. Launching the... [More]

Tags:  query_tuner fixpacks tuning prasad

We recently returned from IOD, which was quite an intense experience for those of you who have never been. We both gave lots of demos and talked to lots of customers about the Optim Query tuning solutions. And you can imagine that any session on query tuning, with or without a tools focus, was really packed. It seems as if people can never hear enough about query tuning, because it’s actually pretty interesting to do, and because it can have such an impact to the day to day life of a DBA (or whoever in your organization is tasked with reviewing... [More]

Tags:  query_tuner amirsoleymani webcast willoughby

It was just over a month ago that I posted the information about our new releases under the Optim name.  Today we announce the z/OS versions of some of those products. IBM Optim Query Tuner for DB2 for z/OS, V2.2 and IBM Optim Query Workload Tuner for DB2 for z/OS, V2.2 Optim Query Tuner is designed for single-query tuning, and Optim Query Workload Tuner provides both single query and workload tuning capability. Both offer seamless integration with Optim Development Studio . Optim Query Workload Tuner is a renamed enhancement of IBM... [More]

Tags:  announcements query_tuner purequery cotner z/os

Greetings from Berlin! I’m very pleased today to tell you about several new announcements we are making in the portfolio previously known as Data Studio.  With these new releases, we are taking great strides toward the vision of Integrated Data Management -- An integrated, modular environment to manage enterprise application data and optimize data-driven applications, from requirements to retirement across heterogeneous environments. While delivering on an Integrated Data Management vision is a very broad value proposition and one that... [More]

Tags:  query_tuner optim announcements cotner

…and at the same time maintain or improve query performance. Note from the editor: This blog entry has been updated to reflect the current product name, InfoSphere Optim Query Workload Tuner for DB2 for z/OS .   Previously I have blogged about how InfoSphere Optim Query Workload Tuner can help developers produce better performing queries early on during development.  So with good query tuning it should be possible to drive down CPU costs for database applications. However, there’s another way that this solution can help drive down CPU costs ,... [More]

Tags:  optimization_expert workload statistics willoughby runstats query_tuner cpu