Articles & Content
Topic: 2007 NA
Subtopic: DB2 for z/OS
DATE: 2007-5-8 (01:40 PM - 02:40 PM)
SPEAKERS: Ed Woods (IBM)
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.