Articles & Content

Archives

F20 - Taming the Dynamic SQL Beast

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2015



With the proliferation of the use of dynamic SQL, it has become more challenging for database professionals to manage performance. This presentation will look at ways to assist in meeting these challenges. First, it will introduce the principles of dynamic statement caching and provide general rules of thumbs for overall performance. It will then look into the DB2 trace and EXPLAIN support to collect and externalize statement-level statistics. Finally, it will show how IBM Data Studio can be used to simplify the end-to-end tuning process.



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.