SIRDUG meeting featuring Sheryl M. Larsen
SIRDUG Meeting October 26th, 2007
Featuring: Sheryl M. Larsen
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.
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
or
email registration@sirdug.org 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.
8361 Concord Mills Boulevard
Concord, NC
(704)979-1700
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 is president and founder of Sheryl M. Larsen,
Inc.(www.smlsql.com), 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 (www.mwdug.org), and a member of IBM's DB2 Gold Consultants
program.
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
released.
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
Misuse of GLOBAL TEMP TABLES
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.