View Printable Version

E05 - Coding Db2 for Performance...by the Book

Session Number: 6012
Track: Application Development
Session Type: Podium Presentation
Primary Presenter: Craig Mullins [Mullins Consulting, Inc.]
Room(s)/
Time(s):

Carolina D => Tue, Jun 04, 2019 (08:00 AM - 09:00 AM)

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. Today's poresentation is based on his newest book, A Guide to Db2 Application Performance for Developers.
Audience experience level: Beginner, Intermediate
Presentation Category: Managing Performance
Presentation Platform: Cross Platform
Audiences this presentation will apply to: Application Developers, New Users, IT Managers
Technical areas this presentation will apply to: Database Performance (DB2 for LUW), Database Performance (DB2 for z/OS), SQL and XML Features, SQL and XML Performance
Objective 1: Start at the beginning with a definition of database performance and a breakdown of the components of the definition
Objective 2: Provide effective ways for designing and developing applications when Db2 data must be accessed, including programming techniques, the importance of indexing, and to avoid
Objective 3: Review SQL coding and tuning techniques including the different ways that SQL can be written and how that can impact performance
Objective 4: Discuss static versus dynamic SQL and when it makes sense to choose one type over the other
Objective 5: Look at the important aspects of Db2 SQL development that programmers should know, including concurrency, date/time, filter factors, access paths, and more.

Abstract:  Writing Db2 programs that perform well can be a difficult task, especially when you are under pressure to deliver code quickly. The cause of most application performance problems can be tracked back to inefficient SQL and program 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 from the perspective of a programmer. It will cover coding techniques, SQL issues, indexing, and more. The presentation is based on my new book, A Guide to Db2 Application Performance for Developers.

For questions or concerns about your event registration, please contact support@idug.org