|  | Level: Introductory Patrick Titzler (ptitzler@us.ibm.com), Enablement Architect, IBM
26 Mar 2009 IBM® Data Studio pureQuery Runtime 2.1 includes a new
feature, called client optimization, that enables database
administrators and developers to take advantage of the performance and
security benefits of static SQL execution against IBM DB2® databases
without having to modify their existing custom-developed or packaged .NET
applications. In this tutorial, learn how to enable this capability for an
existing .NET application.
Before you start
About this tutorial
In this tutorial, learn how to enable static SQL execution for an
existing .NET application (this tutorial uses the testconn20.exe
utility as the .NET application, which is included in DB2 client and
data server installations). You can also follow this tutorial using an
application of your choice that accesses DB2 data sources on any
platform.
Objectives
In
this tutorial, learn:
- How static SQL execution can provide improved problem
determination, performance, and security for your .NET
database applications
- How to enable the pureQuery functionality in the IBM Data
Server Provider for .NET that the application is using to
retrieve data from a DB2 database
- How to configure the IBM Data Server Provider for .NET to
capture the application's SQL
- How to configure the captured SQL and bind it to a database
package
- How to configure the IBM Data Server Provider for .NET to
statically execute the application's SQL
Prerequisites
This tutorial is written for DB2 database administrators and
application developers who would like to explore how they can optimize
their existing .NET applications to improve and stabilize database
access performance, to leverage workload management features, simplify
problem determination, and improve database access security.
System requirements
To follow this tutorial, you need:
- A simple .NET-based application of your choice that accesses a DB2
data server using the IBM Data Server Provider for .Net
- A pureQuery-enabled IBM Data Server Provider for .Net
- IBM Data Studio pureQuery Runtime, which is currently only
available as a licensed product that is part of the Data Studio
portfolio
- The authority to create a database package in the database that is
accessed by the .NET application of your choice
| |
|
