Baltimore/Washington DB2 Users' Group - Special DB2 Course Offering - Wednesday, March

Henry Nalven

Baltimore/Washington DB2 Users' Group - Special DB2 Course Offering - Wednesday, March
HEADS UP!!! SPECIAL MARCH EDUCATIONAL SESSION!!!!

The Baltimore/Washington DB2 Users' Group
Special DB2 Course Offering - Wednesday, March 9, 2011
presenting...

David Simpson & Tony Andrews - THEMIS


BWDB2UG z/OS Educational Session


When?

Wednesday, March 9, 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, THEMIS

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, THEMIS

11:45 - 12:45 Lunch

12:45 - 2:00 Top 25+ DB2 SQL Tuning Tips for Developers (cont.)
David Simpson & Tony Andrews, THEMIS

2:00 - 2:15 Break

2:15 - 3:30 Top 25+ DB2 SQL Tuning Tips for Developers (cont.)
David Simpson & Tony Andrews, THEMIS


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


Visit our website, www.bwdb2ug.org, for more information.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv