Articles & Content

Archives

Efficient Monitoring of Dynamic SQL (A07)

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

OBJECTIVES:

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.