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]
Time: Apr 29, 2013 (08:30 AM - 05:00 PM)
Room: Bonaire 5&6

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
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.