Baltimore / Washington DB2 Users Group
Archived
BWDB2UG LUW Educational Session

David Simpson

When? Wednesday, March 9th, 2011, 9:00AM-3:30PM (registration at 8:30)

Where? Sheraton Columbia Hotel, 10207 Wincopin Circle, Columbia, MD (410) 730-3900

Meeting Fees:
Pre-registered: $250 (lunch and break refreshments included)
At-the-door: $350 (lunch and break refreshments included)

Meeting Schedule:

  8:30 - 9:00 Registration
 
  9:00 - 10:15 Top 25+ DB2 SQL Tuning Tips for Developers
  David Simpson & Tony Andrews
 
 

Most relational tuning experts agree that the majority of performance problems with applications that access a relational database are caused by poorly coded programs or improperly coded SQL. Industry experts agree that poorly performing SQL is responsible for as much as 80 percent of response-time issues. SQL developers should be informed of the many performance issues associated with the SQL language and the way they design their programs. It would be especially helpful if more developers were educated in how to read and analyze DB2 Explain output. This presentation is complete with many of the DB2 Version 8 and V9 tips.

Agenda

  • Learn what makes queries, programs, and applications perform poorly
  • Learn what you can do in your IT shop to improve performance
  • Help developers better understand what SQL optimization is about
  • Teach developers what to do with table scans
  • Teach developers the fundamentals of the DB2 Explain tool
  • Teach developers the fundamentals of the Data Studio Visual Explain tool
  • Teach developers the difference between Stage 1 and Stage 2 predicates
  • Teach the developers the difference between indexable and non-indexable predicates
  • Learn why filter factors are so important to know
  • Learn about new features to assist Cursor Processing performance
  • Learn the top 10 steps to tuning a query or program
  • Learn about many of the V8 and V9 features specific to performance
 
  10:15 - 10:30 Coffee Break
 
  10:30 - 11:45 Top 25+ DB2 SQL Tuning Tips for Developers (cont.)
  David Simpson & Tony Andrews
 
  11:45 - 12:45 Lunch
 
  12:45 - 2:00 Top 25+ DB2 SQL Tuning Tips for Developers (cont.)
  David Simpson & Tony Andrews
 
  2:00 - 2:15 Break
 
  2:15 - 3:30 Top 25+ DB2 SQL Tuning Tips for Developers (cont.)
  David Simpson & Tony Andrews
 

To pre-register, you can 1) use PayPal or 2) mail a check.

1) To pay via PayPal, simply click the link below and follow the directions; then send us an email to let us know the names of everyone in your group who will be attending.

2) To pay by check, mail the check with attendee and company name to:

The Baltimore/Washington DB2 Users' Group
P.O. Box 18554
BWI Airport, Maryland 21240

All pre-registrations must be received by Friday, March 4th, 2011.

Please note: Refunds will not be granted for this seminar for cancellations after this date. However substitution of another person can be made up until the meeting.

Directions to the Sheraton Columbia Hotel
Generate directions via Google Maps
From Baltimore and North
Take I-95 South and exit Rt. 175 West (exit 41B). Travel 6 miles on 175 West. After crossing Rt. 29, go through 5 lights. After the 5th light, make first left onto Wincopin Circle. The Sheraton Columbia Hotel and Conference Center is located at the end of the Wincopin Circle, on the lake.
From Washington and South
Take I-495 East to I-95 to Rt. 32 West. Travel 3 miles North to Rt. 29 North. Travel 2 miles on Rt. 29 North to Broken Land Parkway (exit 18B). Follow signs for Columbia Town Center to Little Patuxent Parkway. Turn right and go through 3 lights. Wincopin Circle is on the right. Go to second entrance of Wincopin Circle and turn right. The Sheraton Columbia Hotel and Conference Center is located at the end of Wincopin Circle, on the lake.
Speaker Backgrounds
David Simpson is currently a Senior Technical Advisor at Themis Inc. He teaches courses on SQL, Application Programming, DB2 Administration as well as 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 17 years as an application programmer, DBA and technical instructor. David is a certified DB2 DBA on both z/OS and LUW. David is a frequent speaker at user groups and IDUG and 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.
Tony Andrews has more than 23 years' experience in the development of relational database applications. Most of this time, he has provided development and consulting services to Fortune 500 companies and government agencies. Tony has written literally thousands of queries and programs during his development years, and has also served as a database analyst. For the last 10 years, Tony has been splitting his time between performance and tuning consulting engagements along with training. His main focus is to teach today's developers the ways of RDMS application design, development and SQL programming -- always with a special emphasis on improving performance. He is a current IBM Champion, and regular speaker at many user groups, IDUG NA, and IDUG EMEA.
Have a topic?
The Baltimore/Washington DB2 Users' Group welcomes suggestions for topics of interest for future meetings. Drop us a line if you have a particular topic you feel would be of interest. If you would like to share, then volunteer as a speaker and gain the satisfaction of helping other DB2 professionals benefit from your experiences.