Articles & Content
Topic: 2008 EU
Subtopic: DB2 for LUW
DATE: 2008-10-16 (11:45 - 12:45)
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.