FASUG Application Development Day 2004

Track A Session 3

Optimize JDBC access to DB2 UDB for iSeries
Jarek Miszczyk


Optimize JDBC access to DB2 UDB for iSeries
This presentation provides implementation tips and coding examples that illustrate how to optimize the access to your DB2 UDB for an iSeries database client system by using various JDBC drivers. Currently, IBM offers several Power PC Linux-enabled JDBC drivers that support DB2 UDB for iSeries:

We will discuss several important aspects of efficient JDBC programming for DB2 UDB for iSeries:
  • Connection Pooling
  • Extended Dynamic SQL and Statement Caching
  • Reusable Open Data Paths (ODPs)
  • Block Insert
  • Massive Delete
We will also examine the tools and utilities that can be used to troubleshoot the JDBC connections to DB2.

Jarek Miszczyk   is a Senior Software Engineer at Solutions Enablement organization in Rochester, Minnesota. His mission is to provide consulting services to Independent Software Vendors, IBM Customers, and other IBM organizations on DB2 UDB for iSeries related issues. He also writes extensively and teaches IBM classes in all areas of the iSeries database. Before joining the Solutions Enablement, he has worked for three years at the ITSO Rochester, where he was the leading author of several popular database redbooks. Jarek has over 15 years experience in the computer field and his areas of expertise include cross-platform database programming, SQL, and database migration.


Web Page: Ashway Consulting, LLC.