Topic: 2011 NA
Subtopic: Cross Platform DB2 for z/OS & LUW
DATE: 2011-5-4 (11:00 AM - 12:00 PM)
SPEAKERS: Namik Hrle (IBM )
Dynamic SQL dominates modern applications and ensuring its optimal execution is very high on the list of DBA tasks. Of course, successful tuning of dynamic SQL depends on efficient monitoring. This presentation provides a deep insight into available monitoring techniques offered across DB2 V8, 9 and 10. The attendees will learn numerous hints and tips about how to monitor dynamic SQL, what are the most relevant performance indicators and how to collect them in the most efficient way.
EXP. LEVEL: Intermediate,Advanced
Understand the key execution characteristics of dynamic SQL
Learn how to monitor dynamic SQL operating environment
Get familiar with the new EXPLAIN monitoring features
Learn how to monitor individual SQL statements
Learn the key performance indicators relevant to dynamic SQL
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.