Hello, everyone! Our next INDUG meeting will take place at Conseco
Conference Center on Tuesday, Feb 12 from 1 - 4. We are fortunate to have
David Simpson from Themis as our speaker. David is well known as a speaker
and teacher, and we're looking forward to having him at our meeting. He
will present two topics.
SQL Optimization & Access Paths: What’s Old & New
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.
Access path review
The difference between “what” and “why”
What’s new in V8
What’s new in V9
Visual Explain & Optimization Service Center
A peek into the 24x7 VLDB DBA’s Toolbox
Supporting very large DB2 databases provides unique challenges and
opportunities for DBAs. A mix of 3rd party tools and custom tools is
required to stay afloat in a 24x7 world supporting multi-billion row
tables. This presentation will share some tips and tricks for surviving and
thriving in this arena.
Running utilities 24x7
Performing table maintenance 24x7
Access Path Analysis
Automate DBA tasks with REXX
David Simpson is currently a Senior Technical Advisor at Themis Inc. He
teaches courses on SQL, Application Programming, DB2 Administration as well
as optimization, performance and tuning. He has supported transactional
systems that use DB2 for z/OS databases in excess of 10 terabytes. David
has worked with DB2 for 14 years as an application programmer, DBA and
technical instructor. David is a certified 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.
11825 N. Pennsylvania Street
Carmel, IN 46032
Directions from I-465 and Meridian Street (US 31) on the north side of
North on Meridian Street.
Turn right (east) on 116th Street.
Turn left (north) on Pennsylvania Street.
Turn right (east) on College Drive to Conseco conference center (Building
J),one-eighth mile on left.
Please send me (Matthew Rhea) an email if you plan to attend. Feel free to
pass this information along. Developers are welcome to attend, too!
Data Services IT Specialist
IBM Information Management
317-566-4608 T/L 554-4608
[login to unmask email]