Taming the Dynamic SQL Beast

Presented by Saghi Amirsoleymani, Florence Dubois, and Adrian Burke, IBM

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.