Articles & Content

Archives

When Static SQL goes down the wrong (access) path (F01)

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2005



DATE: 2005-10-24 (09:30 - 11:00)
SPEAKERS: Terry Berman (DST Systems Inc.)

Static SQL presents special issues for Optimization (different from Dynamic!) To manage the few (but significant) DB2 access paths that perform badly, DST relies on an "SQL Repository", integrating per-SQL performance data with package TEXT and EXPLAIN. This enables a meaningful access path switch report for REBINDs. Longer-term, we are escalating persistent issues such as range predicates and "unstable" access paths.

EXP. LEVEL: Intermediate

OBJECTIVES:

Those (?) static host variables: Optimizer trouble

Per-SQL performance, key to an "SQL Repository"

How to rebind, safely (OPTCCOS1 as example)

Optimizer Issues: Data skew, range predicates

Unstable access paths (switches), V8 help



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.