"I Didn't Know DB2 Did That!"

(Basic to Advanced)

Course: BB32

DB2 Application Developers

presented by

Bonnie K. Baker

 

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 an advanced look at DB2 Components and the Optimizer's instructions for various SQL access paths. While simple paths will be reviewed, this class will focus on those difficult to understand access paths and answer questions like:

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.