Articles & Content

Archives

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

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2007



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

OBJECTIVES:

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



Click Here to Download

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