PITT DUG - Today - Schedule Change

Chris Straub

PITT DUG - Today - Schedule Change

Good morning, I regret to inform everyone that one of our speakers had to
cancel. IT Gain couldn't get a flight out of Newark, so they will not be
able to attend. Therefore, we will be shortening our meeting to only a
half day.

Here is the revised agenda, sorry for the late notice:

Pittsburgh Regional DB2 User Group
Date: Tuesday, March 20th, 2007
Place: Blattner-Brunner Building (Multi-purpose room on the 8th floor)
Cost: FREE
Reservations: Email or call: [login to unmask email] 412.544.5352

Agenda for March 20th, 2007
8:30 - 9:00 Welcome/Breakfast, Compliments of IBM

9:00 - 10:15 Tuning Access Paths: Red Flags to Look for
Presenter: Joe Burns, Highmark (IDUG 2007 – session)
As DBAs and application developers we have all had to look at an access
path at one time or another. Sometimes a performance issue can be easily
seen in the access path, but other times it can be a little more difficult
to spot. This is especially true when dealing with explain output that
generates multiple query blocks. In this session, we will look at explain
output and highlight key areas that affect the performance of various SQL
statements such as joins, sorts and subqueries. The intent is to focus our
efforts on the pieces of the access path that have the most impact on the
performance of our SQL

10:15 - 10:30 Break

10:30 - 11:45 DB2 Application Development from the Programmer’s Point
of View
Presenter: Boris Ioffe, Highmark (IDUG 2007 – session)
A presentation designed for application developers by an application
developer. Some of the Topics to be covered are: How to use your business
knowledge to write efficient SQL before it's too late or too expensive.
What you need to know about the data to help DB2 choose the best path for
your query? How you can get all necessary information from the plan table
and DB2 catalog in a format you can read and understand.

11:45 - 12:00 Closing