Articles & Content

Archives

Efficient Monitoring of Dynamic SQL (E06)

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2011



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.



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.