Agenda - PITT DUG - October 7th - sign up now!!!

Chris Straub

Agenda - PITT DUG - October 7th - sign up now!!!
Here's the agenda for Pitt DUG (in less than 2 weeks). Sign up now by
sending me or Marlene Gaydos an email (see below for email addresses).

For those who don't know, the Blattner-Brunner Building is on the corner of
Ft. Pitt Boulevard and Stanwix Street. The address is 11 Stanwix Street,
Pittsburgh, PA 15222.

Pittsburgh Regional DB2 User Group

Date: Tuesday, October 7, 2008
Place: Blattner-Brunner Building (Multi-purpose room on the 8th floor)
Cost: FREE
Reservations: Email or call: [login to unmask email]
[login to unmask email] 412.544.7006

Agenda for Oct 7, 2008
8:45 – 9:00 Welcome – intro to PITT DUG website

9:00 - 10:15 How and When to change the DB2 Optimizer's Mind
Presenter: Sheryl M. Larsen, Sheryl M. Larsen, Inc.

This presentation will teach you what to do once you are inside an SQL
performance tuning tool. Traditional and extreme methods for altering
optimizer chosen access paths will be demonstrated. IBM warranted tuning
methods such as OPTIMIZE FOR 1 ROW, no operations, REOPT(VARS), as well as
additional methods, such as fake filtering and DISTINCT table expressions,
will be demonstrated. Extreme Cross Query Block Optimization techniques,
X2QBOPT will be demonstrated for extreme situations. The how to tune SQL is
usually easy; however, sometimes drastic situations demand extreme

10:15 - 10:30 Break

10:30 - 11:45 DB2 9 Performance Topics for Developers and Architects
Presenter: Sheryl M. Larsen, Sheryl M. Larsen, Inc.

DB2 9 for z/OS performance enhancements will be discussed in terms of
positive application impact.
Objective1: Understand DB2 9 Optimization enhancements
Objective2: Understand DB2 9 Index enhancements
Objective3: Understand DB2 9 Join enhancements
Objective4: Understand DB2 9 In Memory enhancements
Objective5: Understand Some DB2 9 SQL enhancements.

11:45 - 12:00 Closing

Welcome to the DB2 User Group - Pittsburgh list. To unsubscribe, go to the archives and home page at From that page select "Join or Leave the list". The IDUG Listserv FAQ is at The DB2 User Group - Pittsburgh List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at