DATE: 2010-11-11 (11:15 - 12:15)SPEAKERS: Stewart Smith (Standard Life)I don't have a presentation ready on this topic but I have just completed an evaluation of the tool and I am now in the middle of having it packaged and distributed to our development teams where it will be used mainly on DB2 zOS servers, but also on DB2 LUW> to build & debug SQL Stored Procedures > to interrogate DB2 catalogs> to construct and analyse SQLI think other DB2 shops will be keen to understand > what is free and chargable across portfolio> what is free and chargable in Query Tuning area> what has to be done to configure systems for tool> general aspects of deploying this toolLet me know if you think this is worth taking forward.EXP. LEVEL: BeginnerOBJECTIVES:To Clarify!Clarification of where IBM Data Studio sits within the Optim portfolio of products.Clarification around the IDE and Standlone IBM Data Studio downloads.Clarification of Query Tuner functionality what's free and what requires a chargable upgrade.To describe how we configured our DB2 zOS environment to support debugging and query tuning function, in particular the management of explain tables.To demonstrate some of the functionality around SP building, SQL building, catalog querying and Query Tuning.To demonstrate some of the functionality around Query Tuning, and to discuss some of the stratagies we adopted to cope with large developer audiences and ageing plan table structuresTo discuss some aspects of packaging the product for deployment within our shop and providing ongoing support for a tool that has so much potential.