Skip to main content

By clicking Submit, you agree to the developerWorks terms of use.

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.

  • Close [x]

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.

By clicking Submit, you agree to the developerWorks terms of use.

All information submitted is secure.

  • Close [x]

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
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

1 of 10 | Next

Comments



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=378707
TutorialTitle=Optimize your existing .NET applications using IBM Data Studio's pureQuery
publish-date=03262009
author1-email=ptitzler@us.ibm.com
author1-email-cc=