Tuning Java Applications for DB2

Objectives
On successful completion of this course, attendees will be able to:

• describe the integrity control aspects of Java DB2 programs
• explain how SQL requests and their result sets are processed by DB2
• use trace facilities to detect how the system works in any situation
• solve also problems in more specific or exceptional situations.

Who Should Attend
Application developers, technical analysts and database administrators who are involved in the development and tuning of Java applications that access DB2 databases.
Prerequisites
Attendees should have experience with Java database programming (see course Programming with JDBC) and a good knowledge of DB2 (see DB2 Foundation Skills course).
Duration
2 days
Course Code
JADB
Contents
Connecting to DB2
JDBC vs SQLJ; unit-of-work specification; locking options; BIND parameters.


Modifying tables
Access paths and transmission; select for update; mass inserts; locking problems.


Using (scrollable) cursors
Internal processing; access paths and transmission; impact on availability; uncommitted read; influence of related updates; influence of updates by others.


Using TRACE facilities
Overview; DRDA trace; CLI/ODBC/JDBC trace; understanding trace information.


Alternative scenarios
Using temporary tables; stored procedures; staging tables with trigger definitions.