25 Years of Missed Opportunities? SQL Tuning Revisited
Ulf Heinrich - SEGUS
Abstract:
"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.
Outlines
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
Bio:
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
Abstract:
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.
Bio:
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
Abstract:
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.
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.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Avoiding L2 Performance PMRs
Adrian Burke - IBM
Abstract:
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.
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.