November 19, 2015

Old Sturbridge Village, 1 Old Sturbridge Village Road, Sturbridge, MA 01566
Opening Remarks
25 Years of Missed Opportunities? SQL Tuning Revisited
IBM Capacity Management Analytics for z Systems (zCMA)
SQL Performance in 2016
Avoiding L2 Performance PMRs
Wrap Up
Abstracts and Biographies: 

25 Years of Missed Opportunities? SQL Tuning Revisited

Ulf Heinrich - SEGUS


"Nothing is more expensive than a missed opportunity" (H. Jackson Brown, Jr). This is especially true when it comes to SQL Tuning!

There are many low-hanging fruits within easy grasp of anyone tasked with tuning their systems. But how do you know what is dangling

within reach if you can't see it? Find out how a modern DB2 z/OS SQL warehouse can collect and store all executed static and

dynamic SQL (plex-wide) with basically no overhead. By comparing SQL statements side-by-side, the "easy pickings" will immediately

become apparent. But why stop there? Experts can effortlessly dig deeper and find the totally hidden gems: Disc Problem Detection,

Delay Detection, Never executed SQL, SQL Timeline. Precisely pinpoint specific areas to target and get the most out of your

DB2 system - while reducing costs.


1 - Tuning SQL - how we always done it

2 - Single SQL, package, application

3 - Tuning SQL - year 2004 - ACCESS PATH comparison and simulation

4 - Tuning SQL Revisited - A new methodology

5 - Harvesting the low hanging fruit


Ulf Heinrich is the Director of Solutions Delivery at SOFTWARE ENGINEERING GmbH. He specializes in DB2 recovery issues and database

maintenance, focusing on the growing requirement for cost reduction and 24x7 operations. As a consultant at large customer sites,

he has implemented database maintenance procedures and recovery strategies, and also experienced the pitfalls of recovery scenarios

under real-world recovery pressure. His activities cover EMEA, as well as North America through SE's U.S. subsidiary, SEGUS Inc.

He's involved in the development of SE's maintenance and recovery Solutions.


IBM Capacity Management Analytics for z Systems (zCMA)

Milan Babiak - IBM


The IBM z Analytics platform is transforming IT from technology implementers to business innovators by introducing solutions that can

more directly impact revenue growth, cost savings and risk reduction for a more competitive, high performance business.

To stay ahead of the competition, means being able to generate more rapid, data driven decisions out of the growing volumes of data coming

in to the business. When transactional data originates on z Systems, revolutionary software technologies like DB2 Analytics Accelerator,

Cognos BI and SPSS are creating new opportunities for IT to deliver right time analytics across the enterprise.


Milan Babiak works as Technical Sales Professional for IBM Analytics on z Systems, where he creates and presents product demonstrations.

His specialties are Cognos Business Intelligence and delivering Business Analytics on IBM Mainframe - System z.

He earned Master of Computer Science degree from Slovak Technical University Bratislava, Slovakia. When joining IBM in 2008,

Milan has brought more than 20 years of IT experience in various roles as Software Engineering, Quality Assurance, Performance,

Consulting, and Technical Sales across several industries - Government, Telecommunications, Banking, Aviation, and others.


SQL Performance in 2016

Sheryl Larsen - BMC


New access paths, size limits, and new features can change the way you look at tuning your DB2 workloads. Come hear about some old and

new techniques that can get you ahead of the learning curve.


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.


Avoiding L2 Performance PMRs

Adrian Burke - IBM


Root cause analysis of presumed, or actual DB2 performance issues can be quite tricky in today's diverse environments. Everything from

CEC capacity, LPAR utilization, real/virtual storage, WLM settings, PARMLIB members, and DB2 parameters can play a part in performance

degradation. Wouldn't it be nice if there were some tools (no-charge ones at that) which could quickly guide you in the direction of the

root cause? Not just in text format but with graphs and trending lines that can visually depict the bottle neck and help educate management

and colleagues. Many man hours have been wasted studying the effects of a system slowdown instead of the cause due to narrow scopes

of reference. This presentation will do through tools and methodologies to help you narrow down what is impacting the system so that you

can take action, or engage the resources needed to eliminate the issue. Actual customer performance data and scenarios from

international customers in the banking, insurance, energy, and retail industry are all shown and discussed. The resolution and measures

taken to avoid recreating these scenarios are key takeaways from this discussion.


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.