Articles & Content

Archives

Eliminating Key Performance Bottlenecks in DB2 9.7 (C12)

Topic: 2010 EMEA

Subtopic: DB2 for LUW



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.



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.