I'm a DB2 for z/OS DBA - what does Data Studio do for me?
IBM_Optim 27000269HS Visits (3460)
Well, I guess this is a good question for me, since I'm responsible for the administrative tooling strategy for the Data Studio portfolio, and most of my career at IBM has been closely tied to DB2 for z/OS.
As you know, our initial focus so far has been on application development and optimizing access to DB2 from your Java applications. So, if you're a DBA who is pretty close to the application, there is a lot to care about. Some of you may already be using some of the capabilities of Data Studio Developer because some of the tools are available to you at no charge in the Data Studio workbench provided with your DB2 for z/OS license (you need to order the DB2 Accessories Suite for z/OS). Basically, the workbench provides an Eclipse-based environment for SQL development and debugging, Visual Explain, Web services development, and object management capabilities.
Data Studio Developer provides added capability. Primarily, it provides pureQuery technology to make Java data access development a lot easier while giving you, the DBA, more control over how that code is executed. You see, with pureQuery, the choice to run statically or dynamically is made at execution time. Application developers can take advantage of this great tooling to build and test their applications dynamically and then when they are ready to hand it over to you, you can take it and bind it with a simple click. Now you, as the DBA, have all the advantages of static execution including reduced CPU costs (no more prepares!), more predictable performance, and better problem determination because all the SQL is in easily identifiable packages. The control is in your hands now. Check out this article for more on the advantages of using pureQuery to develop Java data access applications that run using static SQL execution.
Of course, you need the Data Studio pureQuery Runtime product to take advantage of that static execution. Right now, the runtime is available for those applications that run on *IX and Windows platforms accessing DB2 for z/OS as the data vault. But, stay tuned for when pureQuery Runtime will be available for Java applications running on z/OS.
And there's more to come. Look for more administrative tooling to come out this year and next year that supports DB2 for z/OS. If you saw the presentation Torsten Steinbach and I gave at IOD EMEA in June 2008, you already have a sneak peek. If I can get that presentation available more widely, I will post the url here. And we just recently announced the latest release of the DB2 Accessories Suite for z/OS that includes the complimentary Web-based administration console feature of Data studio. I'll post more on the administration console as we get a bit closer to GA. I'll be sure to post more information here as we roll out administrative capabilities on DB2 for z/OS. Talk with you soon.