IDUG DB2 Tech Conference in Denver, Colorado, USA 2012
Denver Colorado Convention Center, Denver, Colorado
May 14-18, 2012

View Printable Version

I Didn't Know DB2 did THAT!

Session Number: 2182
Track: Educational Seminars
Session Type: Podium Presentation
Primary Presenter: Bonnie Baker [Bonnie Baker Corp.]

Room 107 & 109 => Mon, May 14, 2012 (08:30 AM - 05:30 PM)

Speaker Bio: Bonnie Baker is a consultant and educator specializing in applications performance issues on the DB2 OS/390 and z/OS platforms. She is an IBM DB2 Gold Consultant, an IBM Data Champion, a five-time winner of the IDUG Overall Best Speaker award, and a member of the IDUG Speakers' Hall of Fame. She is best known for her series of seminars entitled "Things I Wish They'd Told Me 8 Years Ago"
Audience experience level: Beginner, Intermediate, Advanced
Presentation Category: Application Design
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), New Release (DB2 for z/OS)
Objective 1: Learn unusual details about DB2 internals
Objective 2: Find out what is in the DB2 Black Box
Objective 3: Gain insight into how DB2 works
Objective 4: Learn Optimizer, Internal, and SQL little know facts
Objective 5: Go away feeling like you learned a lot

Abstract:  Have you ever wondered what goes on inside DB2 when your SQL is being executed? This seminar is designed to answer exactly that question and more by taking a look at DB2 Components and the Optimizer's instructions for various SQL access paths. While simple paths will be reviewed, this class willalso focus on those difficult to understand access paths and answer questions like: Topics: 1. When does a RIDPOOL failure NOT result in a Tablespace Scan? 2. What happens during a Hybrid Join and what is a "Type C" Hybrid Join? 3. Why (today) do I need to code both a GROUP BY and an ORDER BY on the same columns to insure that my GROUPs are returned in ORDER? 4. How can a 64-partition DPSI be used for SORT Avoidance? 5. If DB2 does not lock indexes, how does DB2 know if Index-Only data is "clean" or "dirty"? 6. Exactly when are result sets built at OPEN CURSOR? 7. Which DSNZPARMs affect access path selection and operation? 8. And much, much more! With this advanced knowledge, designing indexes and tuning SQL will be a lot easier and a whole lot less confusing. Platform: DB2 for z/OS

For questions or concerns about your event registration, please contact