Articles & Content

Archives

Advanced performance diagnostics for SQL in DB2 9.7 (C14)

Topic: DB2 for LUW

Subtopic: 2010



DATE: 2010-11-10 (17:00 - 18:00)
SPEAKERS: David Kalmuk (IBM)

DB2 9.7 presents 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 that allows you to examine the actual plan cardinalities for your statement executions.

EXP. LEVEL: Beginner,Intermediate

OBJECTIVES:

Learn how to leverage the new DB2 9.7 performance monitoring features and time spent metrics to identify that you have an SQL problem.

Learn how to pinpoint your most expensive statements using the package cache table functions.

Learn about the new runtime explain capabilities and how you can perform an explain from the actual compiled section in the catalogs or the package cache to understand the query plan.

Learn how to leverage the new section actuals explain capabilities to examine the actual cardinalities from the execution of your problem queries.

Take away practical examples you can try out in your own environment.



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.