Articles & Content
Topic: 2005 EU
Subtopic: Cross Platform DB2 for z/OS & LUW
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
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
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.