Articles & Content


Advanced Performance Diagnostics for SQL in DB2 9.7 and PureScale (C14)

Topic: DB2 for LUW

Subtopic: 2011

DB2 9.7 and PureScale present you with important new 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 use the new “time spent” capabilities to identify that you have an SQL problem on your system, and how to find your most expensive statements using the new package cache table functions. You will also learn how to use the new runtime explain capabilities to perform an explain using the actual compiled sections in the package cache or catalogs. Finally, you will be introduced to the new section actuals feature in DB2 9.7 FP1 and 9.8 FP2 that allows you to use the activity event monitor to capture the actual plan cardinalities for your statement executions, in addition to the statement execution metrics.

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.