IDUG DB2 Tech Conference in Denver, Colorado, USA 2012
Denver Colorado Convention Center, Denver, Colorado
May 14-18, 2012

View Printable Version

New Ways to Tame your Database with DB2 Workload Management - H15

Session Number: 321
Track: DB2 10 for Linux, Unix, Windows
Session Type: Podium Presentation
Primary Presenter: David Kalmuk [IBM Canada]

Room 105 => Fri, May 18, 2012 (10:30 AM - 11:30 AM)

Audience experience level: Intermediate, Advanced
Presentation Category: Implementing New DB2 Releases and Features
Presentation Platform: DB2 for Linux, UNIX, Windows
Audiences this presentation will apply to: Data Architects, Database Administrators
Technical areas this presentation will apply to: New Release (DB2 for LUW)
Objective 1: Learn how to optimize your system resource usage by classifying your incoming work and applying query concurrency thresholds.
Objective 2: Learn how to detect and stop rogue queries before they impact your system.
Objective 3: Learn how to prioritize different workloads by provisioning your CPU using the new wlm dispatcher capabilities in DB2 10.
Objective 4: Learn how to use the wlm dispatcher to sandbox workloads without the use of an OS workload manager.
Objective 5: Take away practical examples you can try in your own environment.

Abstract:  Ensuring your database system always meets its business goals and avoids unexpected resource overload can be challenging when supporting a diverse set of workloads in your environment. DB2 Workload Management offers a powerful set of capabilities to allow you to manage and optimize your system but it can sometimes be difficult to know where to start. This session will bring you up to speed on the latest capabilities available for Workload Management in DB2 and through a series of practical examples will show you some of the current best practices for configuring and deploying WLM in your environment. You will learn how to optimize your system to avoid overload using query concurrency thresholds. You will also learn different methods to detect and block rogues queries. Finally we will introduce you to the new new wlm dispatcher capabilities in DB2 10, and show you how to use them both to provision your CPU resources for workload prioritization, and to sandbox specific workloads.

For questions or concerns about your event registration, please contact