New release of DB2 Optimization Expert for z/OS encourages developer collaboration
IBM_Optim 27000269HS Visits (2085)
Hi! It’s been a while since I posted an entry, and with the announcement of DB2 Optimization Expert for z/OS V2.1, I wanted to give you some highlights of what this release offers.
The biggest news about this release is the ability to run in an integrated desktop with IBM Data Studio, Rational, InfoSphere, and other products built on Eclipse V3.4.1, which includes products such as:
• IBM Data Studio Developer 2.1
• Rational Application Developer V18.104.22.168
• Rational Software Architect V22.214.171.124
• InfoSphere Data Architect V7.5.1
This integration is accomplished with shell sharing, and Michael Hsing has a recent entry on this topic, and it also includes links to other shell sharing articles.
So what does that integration provide? If you are a user of any of the above products, you can now invoke DB2 Optimization Expert without leaving the environment of those products. To me this is ideal for developers who want to perform query analysis on SQL contained within their code without leaving the IDE. My last blog entry provided information on those tools and advisors and can be reviewed here. You can also see the advisors in action in this demo that Thuan blogged about earlier.
One important note: The ability to shell-share with other Eclipse-based products such as Data Studio is only available with DB2 Optimization Expert. The Optimization Service Center included with the DB2 z/OS Accessories Suite does not include this capability.
For those of you who are DBAs and not developers, I encourage you to try DB2 Optimization Expert 2.1, since the integrated desktop is our stated direction. However, since this release contains the same features and functions as V1.2.2, you can continue using it and slowly migrate to the new release.
The primary focus of this release was shell sharing; our future release will focus on enhancements to our tools and advisors, as well as improved usability and workflow.
Stay tuned, more is coming.