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.



An essay is a piece of writing.In order to write a successful essay,you must arranged your thoughts.Use an outline to write down your ideas and arrange them.To create an outline, write your topic in the middle of your page.All essays have manly three parts.They are introduction,body paragraphs and conclusion.Introductions and conclusions may be difficult to put in writing, but they’re really worth investing time in.The main points of the paragraphs are the main points outlined in the introduction. Draw three to five lines branching off from this topic and write down your main ideas at the ends of these lines.The body of your essay argues, explains or describes your topic.Draw extra lines off these essential thoughts and consist of any mind you can have on these ideas.Firstly you can select your favorite topics and then you can collect more information from online site.Many top essay writing service( sites are available in online. Reading other people’s essays can help you develop and build on your own essay-writing style.So you should refer some essay from online top essay writing service.You careful about selecting a genuine essay writing service.In a conclusion you can weigh up the different arguments and decide which are the strongest and most relevant.

Extremely details specifically the last part I care for such information and facts much. I was searching for this certain details for some time
Fashion Technology College in chandigarh
Best engineering college in Punjab
MBA College in chandigarh

Apple products are revered for its quality, precision and great design. SRSG started its operations as Apple technology partners in the year 1997.
Apple authorized service center Kolkata
Apple iphone 7 dealers in delhi
Apple ipad air dealers in Kolkata
Apple iphone 6S dealers in delhi
MacBook pro dealers in guwahati
Mac pro service center in Mumbai

I read that Post and got it fine and informative Nike Lunar Force 1 Duckboot Mænd Løbesko. Please share more like that…

Solutions Middle East, works to Envision, Execute and Empower our clients by offerings design, implementation and on-going support services.
Staff Outsourcing
Citrix Mobility Solutions
Online Faxing solutions
Bulk SMS solutions
SafeQ version
Print Management Solutions

DPS has a very good hostel for the students where they get homely environment. Students of various age groups and different places live in the hostel.
Best CBSE Boarding School NCR

Moonlight Films and Theatre Studio operates under the Moonlight Films and Theatre Society , a non-profit association whose goals are to spread knowledge of and interest in theatrical and media arts through education.
Theater classes in Delhi

From your post, I came to know about the CODUG meeting which is going to be conducted soon. I would like to know its time, date and venue so that I can attend it. Please update this information as early as tablets for sale

Very interesting blog. Air Max 360 Hombre I see these days don't really provide anything that I'm interested in, but I'm most definately interested in this one. Just thought that I would post and let you know.