February 12, 2008 Meeting

Matthew A Rhea

February 12, 2008 Meeting

Hello, all.

We're planning our next meeting on February 12. (Location and time TBD.)
David Simpson, from Themis Training, will be presenting. This would be a
great topic for both developers and DBAs. Terry Purcell spoke on the
Optimizer last April, and this talk won't be a repeat; rather, David will
show us how to apply the information we get from DB2 to improve

SQL Optimization & Access Paths: What’s Old & New


David Simpson is currently a Senior Technical Advisor at Themis Inc. He
courses on SQL, Application Programming, DB2 Administration as well as
performance and tuning. He has supported transactional systems that use DB2
z/OS databases in excess of 10 terabytes. David has worked with DB2 for 14
as an application programmer, DBA and technical instructor. David is a
DB2 DBA on both z/OS and LUW. David was voted Best User Speaker and Best
Overall Speaker at IDUG North America 2006. He was also voted Best User
Speaker at IDUG Europe 2006.


Some things with SQL optimization have been the same for a long time.
Others change are changing rapidly with the introduction of Version 8 and
9. This presentation reviews the basics of access path analysis with
extended discussion of what’s new in the latest releases of DB2. The
appropriate place for Visual Explain and Optimization Service Center will
also be covered. Let’s talk about what’s old, what’s new and how to make
the optimizer work for you.

Topics Include:
Access path review
The difference between “what” and “why”
What’s new in V8
What’s new in V9
Visual Explain & Optimization Service Center

In addition, Themis is offering a three-day training course in
Indianapolis Feb 13-15 entitiled "Advanced SQL Optimization with Visual
Explain". I can send you the pdf flyer for that if you wish.

Advanced SQL Optimization with Visual Explain
February 13 – February 15, 2008
Indianapolis, IN
Standard price: $1425.00
INDUG member price: $1200.00

Matthew Rhea
Data Services IT Specialist
IBM Information Management
317-566-4608  T/L 554-4608
[login to unmask email]