Before you start
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.
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
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.
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