Articles & Content


The Dynamics of Monitoring and Managing Dynamic SQL (A07)

Topic: DB2 for z/OS

Subtopic: 2007

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

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.