with Tags:
query_tuner
X

Server-side installation of Optim Query Workload Tuner for z/OS
Hi, my name is Leif Pedersen, and one of my responsibilities is helping customers learn about and use Optim products, including Optim Query Workload Tuner for DB2 for z/OS . This week I received many
emails about how-to install the server side of Optim Query Workload
Tuner for DB2 for z/OS. I have collected some links with some of the information that
is needed to be able to set up Optim Query Worload
Tuner on DB2 for z/OS on the server. All of these links are within the Optim Query Tuner Information Center . Release Notes Installation... [More]
Tags:  query_tuner pedersen |
Sneak peek at customer prez for Optim Query Workload tuner (IOD EMEA)
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 |
Compare access plan costs for DB2 for z/OS Optim Query Tuner Fix Pack 1
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 |
Can you ever know too much about query tuning? Probably not! Join our Virtual tech briefing
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 |
New announcements for Z: Optim Query Tuner, Optim Query Workload Tuner, and Optim pureQuery Runtime for z/OS
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 |
Announcing new releases (and a new product!) for Integrated Data Management
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 |
Did you know….. you can reduce the CPU consumption of RUNSTATS by using the Statistics Advisor of InfoSphere Optim Query Workload Tuner for DB2 for z/OS
…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 query_tuner runstats willoughby cpu |