Exploiting the DB2 Optimizer

Audience:Database Administrators, System Administrators, Application Developers, Programmers and System Programmers.Prerequisites:A working knowledge of SQL predicate types, I/O types and SQL statements such as SELECTs, UPDATEs, JOINs, UNIONs, etc.Summary:This course uses information gained from our instructor's empirical knowledge coupled with that gained from a variety of IBM capacity planning and other publications to consolidate conclusions about the DB2 Optimizer. These conclusions, when observed, should assist those concerned with SQL and application performance in optimising the following:

• Use of filter factors
• I/O costs
• CPU costs
• Indexing
• Access path selection
• BIND/REBIND choices
• ZPARM choices
• IRLM choices

Objectives:Upon completion of this presentation, the participant should be conversant with how the DB2 Optimizer for z/OS chooses an access path, how the user can override the chosen access path, etc.