The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

Optimize your existing .NET applications using IBM Data Studio's pureQuery

Improve performance and security for existing .NET applications that access DB2

Patrick Titzler (ptitzler@us.ibm.com), Enablement Architect, IBM

Patrick Titzler is an engineer in the Data Studio Enablement team at IBM's Silicon Valley Lab in San Jose, CA, and focuses on the application development components of the Data Studio portfolio. Prior to joining this team, Patrick was a member of Data Warehousing and OLAP application development teams. Patrick holds a Master's degree in Computer Science from University of Rostock, Germany.

Summary: 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.

Date: 26 Mar 2009
Level: Introductory
PDF: A4 and Letter (914 KB | 21 pages)Get Adobe® Reader®

Activity: 18399 views
Comments:

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