December 1, 2016

Old Sturbridge Village, 1 Old Sturbridge Village Road, Sturbridge, MA 01566
Sponsored By: 
BMC
Agenda: 
9:00
Opening Remarks
10:30
Break
10:45
zIIP Experiences: zIIP/zAAP Potato/Pototo Let's get the Work Offloaded
12:00
Lunch
1:00
Stored Procedures & SQL PL
2:15
Break
3:45
Wrap Up
Abstracts and Biographies: 
 
SQL Tuning in the Digital World

Sheryl M. Larsen - BMC

Abstract:

Mainframe Application Performance Management is more imperative today with processor speeds approaching the 7 GHZ limit.  Throwing hardware at performance issues is not enough anymore.  Application response
times and runtimes need to be tuned to run as efficiently as possible and often times when it’s DB2 in the application, most of the performance opportunities will be found there.  Various CICS, Batch, and DDF DB2 Version 10 tuning opportunities will be examined; analyzing SQL Text, DB2 Access Paths, and the DB2 Catalog Objects involved.
* What on Mainframe Applications are Using CPU and Causing Wait
* Analyzing Online and DDF SQL for Optimal Response Times
* Investigating DB2 Batch Jobs to Reduce Overall Runtimes
* Exploring Access Path Efficiency by Examining the Explain
* Scrutinizing Information Contained in the DB2 Catalog

Bio:

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 - www.mwdug.org, and a member of the Northern Illinois University Computer Science Alumni Council.

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

zIIP Experiences: zIIP/zAAP Potato/Pototo Let's get the Work Offloaded

Adrian Burke - IBM

Abstract:

With the constant focus on controlling MIPs consumption on today's mainframe, IT staffs are being pressed to get every cycle possible out of their System z Integrated Information Processor (zIIP) specialty engines and the now defunct System z Application Assist Processors (zAAP). DB2 for z/OS and related processes that run on System z can take advantage of these processors, and will be covered in depth during the presentation. There are two methodologies involved in maximizing off-load potential: 1) ensure everything that is currently eligible is getting access to zIIP cycles and tune appropriately 2) then look at other avenues to increase potential off-load. We will delve into both of these to investigate maximum zIIP exploitation and discuss the reality of current customer environments. We also need to understand what new functions are being offloaded in each release and what the demise of the zAAP means for us.

Bio:

Adrian Burke is an Open Group Master Certified IT Specialist on the DB2 SWAT team based out of the Silicon Valley Lab, lead by John Campbell. In this role as a technical advocate for DB2 for z/OS Adrian conducts consulting and educational workshops, DB2 health checks, and availability studies for DB2 for z/OS customers. Previously, as a DB2 Advisor, Adrian supported hundreds of DB2 for z/OS customers from a technical sales perspective delivering consultative and educational workshops. Adrian has spoken at numerous DB2 Regional User Groups both in the U.S. and abroad as well as presented at IDUG, SHARE, and IOD. He is also a published Redbook author on material dealing with DB2 performance.

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Stored Procedures & SQL PL

David Simpson - Themis

Abstract:

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.

Bio:

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.
 

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Fun with SQL

David Simpson & Billy Sundarrajan - Themis

Abstract:

A SQL Dojo is a meeting where a bunch of developers, DBA and SYSPROGS get together to work on a number of SQL challenges. They are there to have fun and to engage in a group effort in order to improve their skills in a non-competitive, collaborative, fun environment. The goal is to have practical hands-on experience within a group of peers, learning a specific technical skill.
The exercise is considered successful when it is completed within allocated time AND audience can repeat the exercise at home by themselves. At the end of the dojo the participants receive, a working solution by dojo leaders, which might not correspond to the solution the participants came up with, but is also working.

The Details
o   A list of SQL challenges is presented and when the first challenge is done, the participants group can move to the next challenge.
o   Of the groups there is always one group typing.
o   Each group each get 5 minutes on the keyboard.  (facilitators will keep time).
o   While on the keyboard the group can type whatever they want to try solving the challenge at hand.  
o   Other participants can point them to the right documentation (on the second projector screen or on the participants own laptops) or can help them out solving a challenge.  
o   After 5 minutes a buzzer goes (provided and monitored by the facilitators) and another group is chosen (by luck of the draw done by the facilitators) and the new group gets the keyboard and can continue working, where the previous group left off.
o   At the end of each challenge the lead speakers will provide a possible solution to the challenge to all participants of the TNO.
o   The speaker assigned to each group must make sure the group stays on topic and doesn't switch to the latest football.

o   At the end of the TNO the participants get the questions and possible solutions to take home for reference.
o   The challenges ideally would be increasingly more difficult, so the groups are on a learning curve and can take the knowledge of the previous challenge and add to it.
o   There will be a mix of small and big challenges, easier and more difficult.

Bio:

Billy Sundarrajan is a data management professional with over 25 years of experience in managing large data systems. He currently works as the Manager of the Database Administration team at Fifth Third Bank. Previously, he was a technology manager at Deloitte with a focus on delivering large scale public welfare systems.  He currently serves on the IDUG Board of Directors.