The Learning Optimizer: an Overview of IBM Db2 AI for z/OS - Robert Catterall - IBM
Abstract:
Choosing the optimal access path for a query, and doing that in a few milliseconds or less, is no easy task. Even with the most sophisticated query optimizer on the market (IBM invented cost-based SQL optimization), Db2 for z/OS doesn't always choose the best-performing access path for a query. Why? Largely because Db2 has had to act without information - specific to YOUR environment - that is critically important with regard to effective access path selection. Up until now, that is. The brand-new IBM Db2 AI for z/OS is going to fundamentally change the access path selection story in a positive way. This session will provide an overview of what IBM Db2 AI for z/OS is, how it does what it does, and its potential to substantially improve query execution performance in diverse Db2 for z/OS environments.
Bio:
Robert Catterall is an IBM Senior Consulting Db2 for z/OS specialist. He started his IT career with IBM in 1982, and worked throughout the 1990s as a member of the Company's Db2 for z/OS National Technical Support team. From 2000 to 2007, Robert worked as a database technology strategist for CheckFree (now part of Fiserv). After working for three years as an independent Db2 consultant, he rejoined IBM in 2010. Robert is a past President of the International Db2 Users Group (IDUG), and a member of IDUG's Speakers Hall of Fame. He presents frequently at conferences and user group meetings, and blogs about Db2 for z/OS at http://robertsdb2blog.blogspot.com/.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Revival Of The SQL Tuner - Sheryl Larsen - BMC
Abstract:
The pool of DBAs with SME knowledge of SQL tuning has shrunk dramatically while the number of SQL statements needing attention has grown and will continue to grow. Db2 performance tooling can help identify what needs to be tuned. But what do you do then? This presentation will help fill the skills gap by reviving the role of an SQL Tuner. Specifically, you will learn what access paths are good for what types of queries, what indexes are best, and how to change the Db2 optimizers mind.
Objective 1: Witness the access path choices with graphic animations and understand which paths are good/bad for certain queries
Objective 2: Learn how to read a visual EXPLAIN
Objective 3: Learn how to use traditional query tuning techniques
Objective 4: Learn how to experiment with more extreme tuning techniques
Objective 5: identify SQL tuning opportunities and fix them with confidence
Bio:
Sheryl M. Larsen represents Worldwide Db2 Z Solutions 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, an IBM Z Champion, and a member of the Northern Illinois University Computer Science Alumni Council.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
AMI (Automated Mainframe Intelligence) - Sheryl Larsen - BMC
Abstract:
Introducing AMI, the new face to BMC’s mainframe solutions. AMI enables you to automatically manage, diagnose, heal and optimize mainframe systems without manual intervention. AMI consists of modern analytics technology and built-in machine learning capabilities that will give you predictable and transparent insight into your mainframe environment. AMI is the autonomous driver you need for your mainframe.AMI can help you with the entire range of challenges you’re trying to tackle on the mainframe today. Imagine monitoring thousands of metrics and having the system make decisions in real-time to ensure your mainframe is always running at peak performance. Imagine automatically finding and fixing issuesbefore they become problems that impact your business. We’re here to help!
Bio:
Sheryl M. Larsen represents Worldwide Db2 Z Solutions 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, an IBM Z Champion, and a member of the Northern Illinois University Computer Science Alumni Council.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Let Me Make This Clear: Explaining Often-Misunderstood Db2 for z/OS Concepts and Facilities - Robert Catterall - IBM
Abstract:
Some aspects of Db2 for z/OS technology are plain as day; others, less so. Questions I get from Db2 users worldwide have highlighted for me things that a lot of folks - even very experienced Db2 people - get wrong. In this session, I'll try to bring clarity to often misunderstood areas of Db2 for z/OS technology, including SQL statement zIIP eligibility, table space partitioning, high-performance database access threads, page-fixed buffer pools, Db2-managed archiving, hard and soft data set open and close, thread reuse, and in-memory database objects.
Bio:
Robert Catterall is an IBM Senior Consulting Db2 for z/OS specialist. He started his IT career with IBM in 1982, and worked throughout the 1990s as a member of the Company's Db2 for z/OS National Technical Support team. From 2000 to 2007, Robert worked as a database technology strategist for CheckFree (now part of Fiserv). After working for three years as an independent Db2 consultant, he rejoined IBM in 2010. Robert is a past President of the International Db2 Users Group (IDUG), and a member of IDUG's Speakers Hall of Fame. He presents frequently at conferences and user group meetings, and blogs about Db2 for z/OS at http://robertsdb2blog.blogspot.com/.