March 7, 2017 CODUG Meeting

We welcome David Simpson and Tony Andrews from Themis In and Sheryl Larsen from BMC to our next CODUG meeting which will be held on March 7, 2017 at the IBM Campus, in Dublin, OH. This will be an all day event including lunch! It's important that you register for this meeting so that we have an accurate count for lunch.

- Sheryl Larsen (BMC)
- David Simpson (Themis Inc)
- Tony Andrews (Themis Inc)

8:30 - 9:00 Registration
9:00 - 9:15 Welcome and Opening Remarks
9:15 - 10:30 SQL Performance in the Digital World Part 1, Speaker: Sheryl Larsen
10:30 - 10:45 Break
10:45 - 12:00 SQL Performance in the Digital World Part 2, Speaker: Sheryl Larsen
12:00 - 1:00 Lunch and Networking
1:00 - 2:15 Stored Procedures & SQL PL, Speaker: David Simpson
2:15 - 2:30 Break
2:30 - 3:45 Fun with SQL, Speakers: David Simpson and Tony Andrews
3:45 - 4:00 Closing Remarks

Presentation #1 & 2:
Sheryl Larsen (BMC) – "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 to 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

Presentation #3
David Simpson (Themis Inc) - "Stored Procedures & SQL PL"

Learn to code simple programs in the SQL Procedure Language (SQL PL). This is the language used by most stored procedures being written today on DB2 for LUW and z/OS. We’ll see the basics of the syntax and discover just how easy it is to code stored procedures using this language.

Presentation #4:
David Simpson and Tony Andrews (Themis Inc) - "Fun with SQL"

This session is an interactive, hands-on, fun way to learn more about the SQL language. Operating as a SQL Dojo, attendees will work in groups to solve a series of SQL challenges provided by the session leaders. Groups will alternate and share time on the keyboard in five minute segments. Each group will try to solve the challenge and can accept suggestions from other participants. Session leaders will provide possible solutions at the end. There will be a mix of small and big challenges - some easier, some more difficult. Show off your SQL mojo while enjoying this SQL dojo.

Here is a link to a video about Fun with SQL

Speaker Biographies

Sheryl Larsen (BMC)

Sheryl M. Larsen is a Sr. DB2 Product Specialist at BMC. Previously she worked for IBM, Sheryl M. Larsen, Inc., and Platinum Technology. She is known for her extensive expertise in SQL Tuning 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 -, and a member of the Northern Illinois University Computer Science Alumni Council.

David Simpson (Themis Inc)

David Simpson is currently Vice President at Themis Inc. He teaches courses on SQL, Application Programming, Database Administration as well as optimization, performance and tuning. He also installs and maintains the database systems used for training at Themis. Since 1993 David has worked as a developer and DBA in support of very large transactional and business intelligence systems. David is a certified DB2 DBA on both z/OS and LUW. David was voted Best User Speaker and Best Overall Speaker at IDUG North America 2006. He was also voted Best User Speaker at IDUG Europe 2006 and is a member of the IDUG Speakers Hall of Fame.

Tony Andrews (Themis Inc)

Tony Andrews has more than 25 years’ experience in the development of relational database applications. Most of this time, he has provided development and consulting services to Fortune 500 companies and government agencies. Tony has written literally thousands of queries and programs during his development years, and has also served as a database analyst. For the last 10 years, Tony has been splitting his time between performance and tuning consulting engagements along with training. His main focus is to teach today’s developers the ways of RDBMS application design, development and SQL programming -- always with a special emphasis on improving performance. He is a current IBM Champion, and regular speaker at many regional user groups, IDUG NA, and IDUG EMEA. He is also the author of a book for developers titled ‘DB2 SQL Tuning Tips for z/OS Developers’.


IBM/Sterling Campus Building One
6060 Britton Parkway
Dublin OH 43016
Meeting rooms - Auditorium A & B

Map to the address.

Driving Directions to IBM/Sterling Campus:

  • Hit the Columbus I-270 outerbelt and head to the northwest quadrant of greater Columbus, the suburb of Dublin.
  • Exit onto Tuttle Parkway.
  • Turn to the west ... away from the Tuttle Mall ... head outside the loop ... head towards the countryside
  • Once clear of the highway interchange, at the 1st big light turn right onto Emerald Parkway (turning left would be Britton Parkway)
  • After about 100 feet turn right again into the IBM Sterling Campus.
  • After about 100 feet (again) turn right into the parking lot that is adjacent to Building ONE (6060 Britton Parkway).
  • Enter the foyer of Building ONE and call the number delimited on a sign that will be posted (or call 717-557-9254) for entry assistance.

Register here.

Looking forward to seeing you there.