pureQuery is IBM's high-performance data access platform focused on simplifying, developing, securing, managing, and optimizing applications that access data. pureQuery provides access to data in databases and in-memory Java objects via its tools and APIs (delivered in IBM Data Studio Developer), and runtime environment ( IBM Data Studio pureQuery Runtime).

This article describes how pureQuery and Data Studio Developer can be used to optimize data access for DB2 LUW and z/OS with EGL Java applications. The article shows how EGL and Data Studio Developer can be installed in a shell-sharing mode, and then how pureQuery can be used with the EGL Java generated code to

• convert dynamic statements to static statements for the DB2 versions- the process of capture / bind and then re-run is described in this document in detail.
• change captured SQL statements with better performing SQL statements without having to change the application
• reduce SQL Injection risk
• look at execution times for the different SQL statements in special views provided in DataStudio

The attached tutorial provides step by step instructions to enable the optimization.

Contact gopalv@us.ibm.com or krzeide@us.ibm.com if you have any questions or need more details.