Articles & Content
Topic: 2006 EU
Subtopic: DB2 for z/OS
DATE: 2006-10-3 (10:15 - 11:15)
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
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
This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.