Skip to main content

skip to main content

developerWorks  >  Information Management  >

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

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

developerWorks
Page 1 of 11 Go to the next page

Document options
PDF format - Fits A4 and Letter

PDF - Fits A4 and Letter
914 KB (21 pages)

Get Adobe® Reader®

Discuss


My developerWorks needs you!

Connect to your technical community


Rate this tutorial

Help us improve this content


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.



Back to top


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



Back to top


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.



Back to top


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


Back to top



Page 1 of 11 Go to the next page