Articles & Content

Archives

D08 - The Latest in Advanced Performance Diagnostics for SQL

Topic: DB2 for LUW

Subtopic: 2005



DB2 for LUW provides a number of important features for diagnosing and solving your SQL problems. Through a series of practical examples, this session will introduce you to 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.1.



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.