Articles & Content


D01 - Advanced Performance Diagnostics for SQL

Topic: 2015 EMEA

Subtopic: DB2 for LUW

DB2 for LUW provides a number of important features for analyzing and diagnosing your SQL problems. Through a series of practical examples, this session will bring you up to speed on the latest DB2 capabilities available for SQL diagnostics and show you how you can leverage them to solve query problems in your own environment. You will learn how to identify your most expensive SQL statements using the package cache table functions, and how to use DB2's "time spent" metrics to analyze where your problem queries are spending their time. You will also learn how to use the latest sort memory metrics in DB2 10.5 Cancun to analyze query memory consumption in order to tune your analytic workloads. Finally you will learn how to use the runtime explain capabilities in conjunction with the activity event monitor to capture actual plan cardinalities as well the new per object metrics available since DB2 10.

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.