The majority of SMLI’s
performance audits easily discover poorly coded or performing SQL.
These statements can easily add up to 25% total CPU utilization. If
your goal is optimizing IT, DB2 SQL education and tuning is a low
cost, immediate return, high ROI and low organizational blockade
solution.
Let SQL tuning expert
Sheryl M. Larsen with over 20 years of DB2 experience, award winning
lectures and course material, increase your developers’ SQL tuning
skills in as little as one day of education.
Access paths are a
significant factor of DB2® performance. DB2 chooses access paths,
but developers and DBAs need to understand how access paths affect
performance in certain situations. The class will concentrate on the
skills required to be competent at changing the DB2 optimizers mind.
Learn what each access
path is, when they are good, when they need to be altered, and when
to apply the optimal tuning techniques.
A workshop will follow to
reinforce these skills:
• Learn how DB2 executes index, table and join access paths
• Learn when each access path is optimal and non-optimal
• Learn recommended SQL tuning techniques for changing the DB2
optimizer’s mind
• Learn how to identify potential access path problems
Sheryl will lead students
with a comprehensive demo and workshop of a free and convenient
workstation tool for analyzing EXPLAIN output, IBM® Optimization
Service Center for DB2 for z/OS (DB2 OSC). This tool is compatible
with DB2 Version 8 and DB2 9 for z/OS - download:
http://www-306.ibm.com/software/data/db2/zos/downloads/osc.html(Installation
help will be provided on site) Bring your own laptops for the short
DB2 OSC workshop (sharing is allowed).
Learn how to navigate DB2
OSC to view access path graphs, EXPLAIN, and tune queries. Learn how
to identify and fix potential problems within a workload. Become
efficient at sourcing, reviewing and tuning SQL.
Sheryl M. Larsen is an
internationally recognized researcher, consultant, lecturer,
specializing in DB2, and owns Sheryl M. Larsen, Inc. (www.smlsql.com),
a firm specializing in Advanced DB2 Consulting and Education. She is
known for her extensive expertise in SQL and performs detailed DB2
Performance Health Checks for many clients. Sheryl has over 20 years
experience in DB2, has published many articles, and co-authored a
book, DB2 Answers, Osborne-McGraw-Hill, 1999. She was voted into
IBM’s inaugural Data Champion program 2009, the IDUG “Speaker Hall
of Fame” in 2001 and is a member of IBM’s DB2 Gold Consultants
program.
