Articles & Content

Archives

Eliminating Key Performance Bottlenecks in DB2 9.7 (C12)

Topic: DB2 for LUW

Subtopic: 2010



DATE: 2010-11-10 (14:15 - 15:15)
SPEAKERS: David Kalmuk (IBM)

In order to maximize your database system performance you need to be able to identify the key performance bottlenecks that are preventing your system from running at its full capacity. To facilitate this process, DB2 9.7 puts a comprehensive new set of performance metrics at your disposal. These new "time spent" metrics allow you to break down where time is being spent on your database server, so that you can quickly identify and eliminate these bottlenecks. Through a series of practical examples, this session will introduce you to DB2's new "time spent" metrics and show you how you can leverage them in different scenarios to quickly diagnose and eliminate performance problems in your environment. You will learn ways to drill down into problem subsystems, how to use wait times to know what to tune, how to identify the connections and workloads consuming the most time in DB2, and much more.

EXP. LEVEL: Beginner,Intermediate

OBJECTIVES:

Review the new Performance Monitoring capabilities available in DB2 9.7

Learn about the new "time spent" metrics and how they allow you to determine where time is being spent in your database server

Learn how to leverage new row based monitoring functions in 9.7 FP1, to quickly identify and eliminate performance bottlenecks on your system

Learn how to identify which connections and workloads are consuming the most processing time in DB2.

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.