New Demos for pureQuery and Optimization Expert on z/os
IBM_Optim 27000269HS Visits (2683)
Just want to let you know that we recently posted another demo for Data Studio on DemoZone. This is a two-part, scenario-based demo focused on a DB2 for z/OS environment. In part 1, we wanted to show some cool features available in DB2 Optimization Expert for z/OS for tuning and optimizing query performance. The second part is an extension to the previous demo set, with details of steps in setting up and using the client optimization feature in Data Studio Developer and pureQuery Runtime for performance stability. Let us know your comments on this video and what specific demos you’d like to see.
I found DB2 Optimization Expert for z/OS easy to use. Of course, when you’re trying to create a demo that shows off the features, it can be challenging. We wanted to come up with a query that would enable us to get tuning recommendations from all the advisors in the product to showcase its capabilities. That was a bit difficult but we managed to do it. You can read more about the various advisors in Ray’s blog entry.
DB2 Optimization Expert is currently available only for z/OS. As query tuning capabilities are a key skill for all database professionals, you might expect to see more database platforms supported in the future.
In addition to the demos on DemoZone, we are posting other less formal, more feature-oriented demos on Channel DB2. In particular, there is a series of demo for new features in Data Studio 2.1 including What’s New for Data Studio Developer and DB2 Performance Expert Extended Insight Feature.
We’re looking forward to hearing from you – just either add a comment to this blog or send an email to firstname.lastname@example.org.