Articles & Content


The Dynamics of Monitoring and Managing Dynamic SQL (A07)

Topic: 2007 NA

Subtopic: DB2 for z/OS

DATE: 2007-5-8 (01:40 PM - 02:40 PM)

Dynamic SQL poses unique and increasingly more important DB2 performance management challenges. Application components such as WebSphere may make extensive use of dynamic SQL. Dynamic SQL offers important application capabilities, but these capabilities may come at a cost. These costs potentially impact the applications, and the DB2 subsystem as a whole. This presentation will cover the dynamics of how dynamic SQL functions. This presentation will discuss how to measure and understand the impact of dynamic SQL on the DB2 subsystem. Topics will include available trace information. The goal is to develop some recommendations on how to best monitor, assess, quantify, and manage dynamic SQL.

EXP. LEVEL: Intermediate


A review of dynamic SQL concepts

Examples of how applications use dynamic SQL

Understanding the cost of dynamic SQL

Performance and availability information available

Summary and conclusions

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.