View Printable Version

EDS7 - The Best of Martin Hubel and Scott Hayes – their Greatest Wisdoms

Session Number: 3262
Track: Educational Seminar - II
Session Type: Educational Seminar
Primary Presenter: Martin Hubel [MHC Inc.]

Frio - Ed. Sems. => Wed, May 25, 2016 (01:00 PM - 04:30 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 several beta test programs for these platforms. He is an IBM Information Champion, and a member of the IDUG Volunteer Hall of Fame and currently on the IDUG Content Committee. He is a member of the DB2 LUW SAP Technical Leadership Exchange.
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, Data Architects, Database Administrators, Systems Programmers, New Users, IT Managers
Technical areas this presentation will apply to: Database Performance (DB2 for z/OS), New Release (DB2 for LUW), User Experiences
Objective 1: Objective 1: 1. Physical I/O
a. Synchronous and asynchronous I/O
b. Buffer pool configuration
c. I/O configuration parameters
Objective 2: Objective 2: 2. Logical I/O
a. Index design
b. Table design
c. DB2 10.5 BLU
d. Catalog queries for tuning
Objective 3: Objective 3: 3. SQL Tuning
a. Finding SQL to tune
b. Explain
c. Design advisor
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 half-day course, current to DB2 10.5, 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.

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