Articles & Content


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

Topic: 2011 EMEA

Subtopic: DB2 for LUW

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.