Articles & Content


All about Perfect Tuning of Java Applications for DB2 (G07)

Topic: 2008 NA

Subtopic: Cross Platform DB2 for z/OS & LUW

DATE: 2008-05-20 (01:30 PM - 02:30 PM)
SPEAKERS: Bilung Lee (IBM)

The Java Common Client (JCC) driver enables Java access across DB2 product family. This presentation will offer tips and tricks to write Java applications using the driver to access DB2 servers with best performance and behavior. It will advise how to tune up driver properties to balance between flexibility and efficiency on data type setting, and will also show when to choose between the new streaming and the legacy locator mechanisms in the driver to achieve flow optimization of large objects. In addition, the presentation will cover driver-side autonomic intelligence, which enables automatic recovery from certain failures but may negatively impact performance underneath. Moreover, the presentation will visit those driver properties with performance impact on statement execution. Furthermore, an inside look will be provided on how to best utilize various XML interfaces in the driver. Come and take home this knowledge such that perfect tuning may not be as far-fetched as it appears.

EXP. LEVEL: Intermediate,Advanced


Learn how to balance between settings for data types

Learn when to choose a specific setting for large objects

Understand autonomic intelligence embedded in the driver

Learn what properties have impact on statement execution

Learn how to leverage various XML interfaces in the driver

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.