Articles & Content
Topic: 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
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.