View Printable Version

E13 - Db2 Application Development for Performance: Be Early and Be Informed

Session Number: 5028
Track: Application Development
Session Type: Podium Presentation
Primary Presenter: Craig Mullins [Mullins Consulting, Inc.]

Congress B => Wed, May 02, 2018 (03:40 PM - 04:40 PM)

Session Code: E13
Speaker Bio: Craig S. Mullins is a data management strategist, researcher, and consultant. He is president and principal consultant of Mullins Consulting, Inc. and has been named by IBM as a Gold Consultant and an IBM Champion for Analytics. Craig has over three decades of experience in all facets of database systems development and has worked with DB2 since V1. You may know Craig from his popular books: "DB2 Developer's Guide, 6th edition" the most popular book on DB2 for z/OS... and "Database Administration: The Complete Guide to DBA Practices and Procedures, 2nd edition" the industry's only comprehensive guide to heterogeneous database administration.

Audience experience level: Beginner, Intermediate
Presentation Category: Managing Performance
Presentation Platform: Cross Platform
Audiences this presentation will apply to: Application Developers, New Users
Technical areas this presentation will apply to: Database Performance (DB2 for LUW), Database Performance (DB2 for z/OS)
Objective 1: Define database performance and understand each of the components of the definition
Objective 2: Examine the three aspects of database performance tuning and how they impact performance of Db2 applications
Objective 3: Discuss effective ways of designing applications when database access is involved including programming techniques and database indexing
Objective 4: Review several SQL tuning techniques including the many different ways that SQL can be written and how that can impact performance
Objective 5: Provide a high-level overview of the types of access paths available and when each one makes sense

Abstract:  Assuring the performance of Db2 applications is a very time-consuming management aspect of IT. End users and developers experiences performance pains sometimes daily and DBAs continually struggle to adjust parameters, code and database design to improve and tune things. But the cause of most database application performance issues is the SQL and code. If developers better understood how to code for Db2 performance from the outset, a lot of pain and suffering could be eliminated.
In this presentation we will look at performance basics, coding techniques, SQL issues, indexing, and more, with an eye toward helping you to build more efficient Db2 applications

For questions or concerns about your event registration, please contact