Articles & Content

Archives

Static Access Paths - Pushing the Support Envelope (Part 1 of 2) (F04)

Topic: DB2 for z/OS

Subtopic: 2006



DATE: 2006-10-3 (09:00 - 10:00)
SPEAKERS: Terry Berman (DST Systems Inc.)

To keep programmed Static SQL at peak performance and avoid damaging switches, we need "good health" maintenance practices for our access paths (regular REBINDs with complete STATS) enabled by: "Power Solutions" (effective switch reporting, an Optimizer Test Bed, OPTHINT) and an "SQL Repository" (Explain and per-SQL performance integrated via an "SQLKEY" ID) along with exploitation of ALL the V8 Explain information.

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

A customerís viewpoint on the DB2 Optimizer

Full exploitation of new V8 Explain information

The best DB2 Statistics & simulations

SQL performance-driven: filtering the important

Go Further: interventions, fundamental issues



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.