SIRDUG meeting featuring Sheryl M. Larsen

SIRDUG Meeting October 26th, 2007

Featuring: Sheryl M. Larsen

Meeting Details

WHEN? Friday, October 26, 2007

For detailed directions click here

Dave & Buster's
This is located in the Concord Mills Mall, right off I-85.

COST? $210 cash or check, in advance or at the door.
We do not accept credit cards.

Meeting Agenda

 8:00 -  8:50  -  Registration - Coffee, Danish, and Networking
 8:50 -  9:00  -  SIRDUG announcements and speaker introductions
 9:00 - 10:15  -  Sheryl Larsen "Top Application Impacts on Performance"
10:15 - 10:35  -  Mid-Morning Break
10:35 - 11:50  -  Sheryl Larsen  "Top Application Impacts on Performance"
11:50 -  1:00  -  Lunch
 1:00 -  2:00  -  Sheryl Larsen "Top Application Impacts on Performance"
 2:00 -  2:20  -  Mid-Afternoon Break and chat with Sheryl
 2:20 -  3:45  -  Sheryl Larsen "Top Application Impacts on Performance"
 3:45 -  4:00  -  Networking, Adjourn


To pre-register please use our new online registration form at:
meeting registration form
email and give us your name and company. If you are not already on our distribution list and wish to be, include your email address and phone number.

If you do not wish to continue receiving these occasional notices, please indicate that in your registration email.

Pre-registration must be completed by Midnight, Tuesday, October 16th. Please feel free to invite others from your company (just make sure they pre-register as well). If you know others in your company who are interested in attending future SIRDUG events, please encourage them to become members of our distribution list (we just need their names, email addresses and phone numbers).

Registration Note
SIRDUG will be calling or emailing a confirmation for each person who pre-registers by the deadline. If you have pre-registered and have not received a confirmation by the day after the deadline, please notify us as your registration may not have been received.

If you have not pre-registered by the deadline, you may pre-register after the deadline or register at the door, but the availability of presentation handouts and lunch can not be guaranteed and confirmations will not be sent.

Directions to Dave & Buster's:

8361 Concord Mills Boulevard
Concord, NC

I-85 to Exit 49
Concord Mills Blvd. 2 miles from Lowe's Motor Speedway,
10 miles north of downtown Charlotte, and 17 miles from Charlotte Douglas
International Airport.

You can get a better map at the Concord Mills Mall site.

Sheryl M. Larsen's Biography

Sheryl M. Larsen is president and founder of Sheryl M. Larsen, Inc.(, a firm specializing in Advanced DB2 Consulting and Education. She is an internationally recognized researcher, consultant and lecturer, specializing in DB2 and is known for her extensive expertise in SQL. Sheryl has over 20 years experience in DB2, has published many articles, several popular DB2 posters, and co-authored a book, DB2 Answers, Osborne-McGraw-Hill, 1999. She was selected as a keynote speaker for the IDUG Asia Pacific 2002 Conference and is frequently asked to keynote DB2 tool vendor's world wide events. She was voted into the IDUG "Speaker Hall of Fame" in 2001 and was the Executive Editor of the IDUG Solutions Journal magazine 1997-2000. Currently, she is President of the Midwest Database Users Group (, and a member of IBM's DB2 Gold Consultants program.

Title: "Top Application Impacts on Performance"

The past twenty years of DB2 has offered us many ways to architect an
application. SOA, web services, and the like, have changed our thinking, but
has SQL performance improved? Come find out what DB2 features impact
response time, throughput, peak response time, hits, and sessions per second
for the better, and for the worse. This seminar is packed with performance
hints and tips and even contains material about DB2 versions yet to be

Things that Impact Application Speed

  Query Vs. Prog.
  4K Page Processing
  Order of Index Columns - z/OS
  Order of Index Columns - LUW

Variations of Index Access

  DB2 z/OS Favorite Access: List Prefetch
  DB2 z/OS Favorite Join: Nested Loop Join

  DB2 LUW Favorite Access: Table Scan
  DB2 LUW Favorite Join:Hash Join

Other System Impacts

  Buffer Pool
  Total Buffer Pools
  Typical Schema &Index Design
  Optimal Schema &Index Design
  Performance Structure Impacts

Optimal Index Design

  Choose the Workload
  Table/Column Usage
  Final Ranking
  Grand Total

Optimal Materialized Query Tables

  To Build or not to Build
  Query Speed Up

Application Considerations

  Proper Use of SQL Clauses

  Over Use of LEFT JOIN
  SQL Performance Rules

  Between Clauses for DB2 z/OS

More SQL Performance Rules

  Aggravating Columns
  Indexable Stage 1 Predicates - z/OS
  Stage 1 Predicates - z/OS
  Stage 2 Predicates - z/OS
  Host Variable Impact - z/OS

SQL Review Checklist

SQL Skills Self Assessment

SQL Coding ""Best Practices""

DB2 Family SQL Compatibility

DB2 for LUW V8 vs. DB2 for z/OS V8

Best V8 SQL clauses

DB2 9 for LUW vs. DB2 9 for z/OS

Best DB2 9 SQL clauses

DB2 ? for LUW vs. DB2 ? for z/OS

    This is still a secret

SIRDUG Home Page

Last Update: September 17, 2007

Copyright 2007 SIRDUG Inc. All rights reserved.