This workshop is aimed at Db2 Developers, DBAs and Systems Programmers who are interested in collecting performance data for SQL statements, and understanding and tuning access plans chosen by the Db2 for z/OS Optimizer.
Topics include: The Dynamic Statement Cache; EXPLAIN basics; Optimization Hints; Statement Level hints and The Access Path Repository; Catalog Statistics and The Db2 Optimizer; Walkthrough of Typical Access Path Problems.
The workshop also looks at the access path management enhancements introduced by Db2 12.
More information at http://l.spdug.org/foruminfows
Comments