Articles & Content


Performance Analysis of Dynamic SQL in a Java Environment (E13)

Topic: 2007 EU

Subtopic: Cross Platform DB2 for z/OS & LUW

DATE: 2007-11-7 (17:30 - 18:30)
SPEAKERS: Roland Schwarz (BG-Phoenics)

Traditional db2 applications on a mainframe coming through an IMS or CICS monitor are usually running with static, well-tuned and controlled sql-statements.However, these old applications will more and more be replaced by java technology with tools and techniques (JDO, EJB) to implement mapping between relational data model and Java object model.This technique leads to tons of dynamic sql statements, which are often built immediately before their execution. Depending on the performance implementation, monitoring and summarizing of these sql statements can't often be done with available monitoring tools.Therefore, this presentation explains common problems, points out requirements for a analyze tool and demonstrates the analyze process on DB2 z/OS. Samples and experiences of common detected performance problems are included. The presentation also refers to some important DB2 installation parms for DDF communication.

EXP. LEVEL: Intermediate


problems coming up through the use of dynamic sql in a java environment

most common questions for sql performance analysis

tool requirements for sql analyze

analyze process

analysis and tuning experiences of various sql scenarios

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.