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