Articles & Content

Archives

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

Topic: 2006 EU

Subtopic: DB2 for z/OS



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



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!

Download File
Click to Download

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