View Printable Version

B08 - A DB2 Performance Tuning Roadmap

Session Number: 2299
Track: DB2 z/OS - II
Session Type: Podium Presentation
Primary Presenter: Craig Mullins [President and Principal Consultant - Mullins Consulting, Inc.]

Grand Ballroom - North => Tue, May 05, 2015 (02:15 PM - 03:15 PM)

Speaker Bio: Craig S. Mullins is a data management strategist, researcher, and consultant. He is president and principal consultant of Mullins Consulting, Inc. and the publisher/editor for

Craig has over three decades of experience in all facets of database systems development and has worked with mainframe DB2 since V1. You may know Craig from his popular books:
- DB2 Developer's Guide, 6th edition – containing more than 1500 pages of in-depth technical information on DB2 for z/OS
- Database Administration: The Complete Guide to DBA Practices and Procedures, 2nd edition – the industry's only comprehensive guide to heterogeneous database administration.

Craig has been named by IBM as a Gold Consultant and an IBM Champion for Information Management. He was recently named one of the Top 200 Thought Leaders in Big Data & Analytics by AnalyticsWeek magazine. He is a former Gartner analyst, having covered the topic area of database administration as a research director.
Audience experience level: Intermediate
Presentation Category: Application Design, Managing Database Resources, Managing Performance
Presentation Platform: DB2 for z/OS
Audiences this presentation will apply to: Application Developers, Database Administrators
Technical areas this presentation will apply to: Database Performance (DB2 for z/OS)
Objective 1: Understand tuning basics and the "Tuning Progression"
Objective 2: Review and learn application development performance tuning guidelines: application code and SQL
Objective 3: Investigate and discover methods for optimizing database design and implementation: DDL, indexing, and organization
Objective 4: Delve into system tuning issues: DB2 subsystems
Objective 5: What else could go wrong? The Environment: OS, TP, Network

Abstract:  This presentation will discuss DB2 for z/OS performance management and tuning issues. It offers multiple guidelines and tips for achieving optimal performance broken down into 3 specific categories. The presentation will touch on many aspects of DB2 performance that span the application, the databases, and the DB2 subsystem. Refresh your knowledge of DB2 performance with these handy DB2 oppor-TUNE-ities.

For questions or concerns about your event registration, please contact