Hello Pitt DUGgers!
Here's the agenda for the next Pittsburgh DB2 User Group on March 20th... I
hope to see everyone there.
Again, please note we'll be on the 8th floor of the Blattner-Brunner
Building (a.k.a. Old Westinghouse Building). This facility is located at
11 Stanwix Street. Call me or email with questions. Thanks.
Pittsburgh Regional DB2 User Group
Date: Tuesday, March 20th, 2007
Place: Blattner-Brunner Building (Multi-purpose room on the 8th floor)
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 Make Your Databases Fly
Presenter: Florian Boldt, IT Gain
Database tuning depends on efficient monitoring and analysis of monitor
output. Often DBAs and application programmers lack sufficient time for
efficient database design and tuning. Wouldn't it be great to just quickly
analyze key performance information that has been collected and organized
for you? This session will focus on performance data collection and Index
11:45 - 12:15 Lunch, Compliments of IT Gain
12:15 - 1:30 DB2 Application Development from the Programmer’s Point
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.
1:30 - 1:45 Closing