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(s)/
    Time(s):

    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 support@idug.org


    Copyright © 2014 IDUG. All Rights Reserved

    All material, files, logos and trademarks within this site are properties of their respective organizations.

    Terms of Service - Privacy Policy - Contact