Articles & Content


Efficient Monitoring and Tuning of Dynamic SQL in DB2 for z/OS

Topic: 2014 London

Subtopic: DB2 for z/OS

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 by DB2 for z/OS. 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.