View Printable Version

    DB2 for LUW Top Gun Performance Workshop

    Session Number: 327
    Track: Educational Seminars
    Session Type: Podium Presentation
    Primary Presenter: Martin Hubel [MHC Inc.]
    Co-Presenter: Scott Hayes [President & CEO - DBI Software]

    Bonaire 5&6 => Mon, Apr 29, 2013 (08:30 AM - 05:00 PM)

    Speaker Bio: Martin Hubel is an independent consultant and has worked extensively with DB2 since 1985. Martin develops and teaches DB2 advanced courses and is recognized as a leading authority in the field. He has been using DB2 Universal Database on Linux, Unix, and Windows since 1993 and has participated in all beta test programs for these platforms. He is an IBM Information Champion, and a member of the IDUG Volunteer Hall of Fame.
    Audience experience level: Beginner, Intermediate, Advanced
    Presentation Category: Managing Database Resources, Managing Performance
    Presentation Platform: DB2 for Linux, UNIX, Windows
    Audiences this presentation will apply to: Application Developers, Database Administrators, Systems Programmers, New Users
    Technical areas this presentation will apply to: Database Performance (DB2 for LUW)
    Objective 1: 1. Key System Parameters
    a. Heaps and memory areas in DB2 9.7 and DB2 10
    b. Autonomic and Automatic configuration
    c. Key Performance Indicator Measurements

    Objective 2: 2. Physical I/O
    a. Synchronous and asynchronous I/O
    b. Buffer pool configuration
    c. I/O configuration parameters
    d. Data compression
    e. Tablespace configuration

    Objective 3: 3. Logical I/O
    a. Index design
    b. Table design
    c. Catalog queries for tuning

    Objective 4: 4. SQL Tuning
    a. Finding SQL to tune
    b. Explain
    c. Design advisor

    Objective 5: 5. Brand new, advanced and cool DB2 facilities
    a. DB2CAEM
    b. db2pd
    c. Optimization profiles

    Co-speaker Name: Scott Hayes
    Co-speaker Bio: Scott Hayes is President & CEO of DBI Software, an IBM Information Champion, a DB2 blogger, tweeter, and Host of The DB2Night Show™ Edutainment Webinar Series. Scott has been a regular speaker and lecturer at worldwide IDUG conferences since 1996. He’s never met a DB2 LUW database that he could make run measurably faster in 60 minutes or less.

    Abstract:  This course will teach how to configure and tune DB2 LUW databases for maximum performance and availability. Included are strategies for memory and CPU optimization, techniques for speeding up I/O, and what and how to monitor and measure for most effective results, trend analysis, and capacity planning.

    Attendees will learn dozens of key metrics that must be regularly monitored, and what corrective action to take if metrics show substandard performance. Upon completion of this seminar, DBAs and Application Developers will have a template to follow to ensure that they have top performing databases and applications. SQL commands, scripts, and other electronic materials will be provided to attendees to enhance learning and productivity.

    For questions or concerns about your event registration, please contact

    Copyright © 2015 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