IDUG DB2 Tech Conference EMEA 2011
Clarion Congress Hotel, Prague, Czech Republic
14 - 18 November, 2011

View Printable Version

Eliminating Performance Bottlenecks in DB2 9.7 and PureScale

Session Number: 2079
Track: DB2 for LUW Lessons Learned (D)
Session Type: Podium Presentation
Primary Presenter: Steve Rees [IBM]
Time: Nov 14, 2011 (01:30 PM - 02:30 PM)
Room: Aquarius

Speaker Bio: David Kalmuk is a technical lead and architect for the DB2 for LUW product, specializing in the process model, workload management, and monitoring areas. David has played a lead role in the design and architecture of numerous technologies in DB2 over the years including the new Performance Monitoring features in DB2 9.7 and PureScale, the threaded engine, DB2's cross node messaging architecture for partitioned environments, and the connection concentrator. Most recently he has been leading the development of new Workload Management features and technologies. David has been a member of the DB2 team since 2000.
Audience experience level: Select a Value
Presentation Category: Implementing New DB2 Releases and Features
Presentation Platform: Select a Value
Audiences this presentation will apply to: Application Developers, Database Administrators
Technical areas this presentation will apply to: Database Performance (DB2 for LUW), New Release (DB2 for LUW), pureScale, SQL and XML Performance
Objective 1: Review the new Performance Monitoring capabilities available in DB2 9.7 and DB2 PureScale.
Objective 2: Learn about the new "time spent" metrics and how they allow you to determine where time is being spent in your database server.
Objective 3: Learn how to leverage new row based monitoring functions introduced in 9.7 FP1 and 9.8 FP2, to quickly identify and eliminate performance bottlenecks on your system, no matter whether it's a single partition, multi-partition, or purescale environment.
Objective 4: Learn how to identify which connections and workloads are consuming the most processing time in DB2.
Objective 5: Take away practical examples you can try out in your own environment.

Abstract:  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. In DB2 9.7 and PureScale, we put a comprehensive new set of performance metrics at your disposal to facilitate this process. 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.

For questions or concerns about your event registration, please contact