DB2 Forum 2017 Fourth Quarter Meeting
Thursday, October 5 2017
08:30 - 12:30 p.m.
The Original Pancake House
5220 Beltline Road
Dallas, TX 75254
** Directions to The Original Pancake House **
The Original Pancake House is in Addison on Beltline just east of the North Dallas
Tollway and the Whole Foods.
Meeting Cost: $10 for non-members, free to members. Membership is $25 per
year per person --or-- $100 for 5 people in a company --or-- $350 for
unlimited people in a company. You can register at the meeting.
SQL Tuning in the Digital World
The Digital World includes all kinds of transactions most of which contain SQL. Trapping and
fixing nonperforming SQL has gotten more complicated, or has it? The speed at which SQL
performance problems need to be resolved has shrunken to .1ms or 0 – meaning that they should
never happen. Come learn tips and techniques that can assist you in today’s Digital World.
Objective 1: When your monitors find this, what should you do?
- Objective 2: What crazy SQL can do for you!
- Objective 3: Finding the most expensive query running in the peak
- Objective 4: Some old and new tuning techniques
- Objective 5: Monetize your MLC savings with compares
Sheryl M. Larsen is an internationally recognized researcher, consultant, lecturer, specializing in
DB2, and now works for BMC as a Sr. DB2 Product Specialist. Previously she worked for IBM,
Sheryl M. Larsen, Inc., and Platinum Technology. She is known for her extensive expertise in
SQL and has performed detailed DB2 Performance Health Checks for many fortune 500 clients.
Sheryl has over 25 years' experience in DB2, has published many articles, white papers and co-
authored a book, DB2 Answers, Osborne-McGraw-Hill, 1999. Currently she is the President of
the Midwest DB2 User Group - www.mwdug.org, and a member of the Northern Illinois
University Computer Science Alumni Council.
Sheryl Larsen - BMC
SQL Tuning in the Digital World (continues)
Continuation of the first topic