 | Level: Introductory Patrick Titzler (ptitzler@us.ibm.com), Enablement Engineer, IBM
Zeus Courtois (zocourto@us.ibm.com), Software Engineer,
IBM
21 Aug 2008
In Version 1.2, Data Studio Developer and Data Studio pureQuery Runtime
include a new feature called client optimization that enables DBAs and developers to
take advantage of the benefits of static SQL execution
without having to modify their
existing custom-developed, framework-based, or packaged
JDBC applications.
This tutorial shows you how to use the tooling provided by Data Studio Developer to
enable a JDBC application to use this new capability.
Objectives - Create a sample database and import the sample JDBC application into Data Studio Developer 1.2
- Run the application using one code path and capture its SQL
- Optionally, browse the sample application's SQL and its relationship
to the Java source code
- Configure and bind the captured SQL to a database package
- Run the sample application in static SQL execution mode, and validate its correct behavior
- Run the application using another code path to capture the remaining SQL; then rebind and re-run the application using static SQL execution
Prerequisites
This tutorial is written for application developers and DBAs who have
basic experience with Eclipse-based tooling.
System requirements
To run the examples in this tutorial, you should have Data Studio Developer 1.2 installed.
You will also need access to a DB2 data server.
Download the DB2 Express-C no-charge version of DB2 for the
community that offers the same core data features as DB2 LUW and provides a solid base to build and deploy applications.
Refer to the Resources section for download links.
Formats html, pdf
Tutorial overview
In this tutorial, learn how to use Data
Studio Developer to enable a simple custom-developed JDBC application that is included in this tutorial. However, you can also
follow this tutorial using an application of your choice that accesses DB2 data on any platform.
Access to source code is not required for client optimization, but
the steps in this tutorial assume you have such access.
| | | |
