View Printable Version

DB2 V10+ for LUW Top Gun Performance Workshop

Session Number: 1009
Track: Educational Seminars
Session Type: Podium Presentation
Primary Presenter: Martin Hubel [President - MHC Inc.]

Ahwatukee => Mon, May 12, 2014 (08:30 AM - 05:00 PM)

Session Code: 1336
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: Select a Value
Presentation Category: Managing Performance
Presentation Platform: DB2 for Linux, UNIX, Windows
Audiences this presentation will apply to: Application Developers, Data Architects, Database Administrators, Systems Programmers, New Users, IT Managers
Technical areas this presentation will apply to: Database Performance (DB2 for LUW), New Release (DB2 for LUW), SQL and XML Performance
Objective 1: 1. Key System Parameters
a. Heaps and memory areas in DB2 10 and vNext
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.  It is current to DB2 10 and DB2 vNext.

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