Articles & Content

Archives

Problem determination in SQL Routines and Triggers using profiling (D03)

Topic: DB2 for LUW

Subtopic: 2011



In this presentation we will look at approaches to eliminate performance problems in SQL PL and PL/SQL objects such as triggers, procedures and functions. To this end we will introduce a simple profiler than exploits DB2' 9.7 new monitoring API and how to use it to find slow algorithms, bad plans, etc.



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.