December 5, 2019

Old Sturbridge Village, 1 Old Sturbridge Village Road, Sturbridge, MA 01566
Sponsored By: 
BMC
Theme: 
DB2 Behind The Curtain
Agenda: 
08:30
Continental Breakfast
9:00
Opening Remarks
9:15
Why does the DB2 optimizer need a data scientist - Sheryl Larsen
PDF icon Why does the Db2 Optimizer need a Data Scientist Chicago 2019.pdf
10:30
Break with Refreshments
10:45
Db2 12 for z/OS Update - Mark Rader
PDF icon Db2 12 for zOS Update for NEDB2UG.pdf
12:00
Buffet Lunch
01:00
What has the BMC Mainframe Team been up to Lately?- Sheryl Larsen
PDF icon BMC Future Vision and Roadmap as of 2019.pdf
02:15
Break with Refreshments
02:30
Db2 for z/OS Know your Limits! - Ulf Heinrich
PDF icon Db2 for zOS Know your Limits_Db2_Guide_Dec_2019.pdf
03:45
Wrap Up - Discuss March presentations
Abstracts and Biographies: 
Highlights
 
 
Speaker Bios:
Ulf Heinrich
Ulf Heinrich is the Director of Solutions Delivery at SOFTWARE ENGINEERING GmbH. He specializes in DB2 operations and performance tuning, 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 realworld recovery pressure. His activities cover EMEA, as well as North America through SE’s U.S. subsidiary, SEGUS Inc. As a member of SE’s Request Board he’s working closely with customers and the development labs.
Sheryl Larsen
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.
Mark Rader
Mark Rader is a Db2 for z/OS specialist in the IBM Washington Systems Center. He has over 35 years of technical experience with IBM, primarily with Db2 for z/OS. He has led many Db2 data sharing implementations and has presented a variety of topics at conferences, including IDUG and SHARE, and at regional Db2 user group meetings. He has worked closely with Db2 development in delivering the Early Support Programs for Db2 10, Db2 11, and Db2 12. He is an author of redbooks on Parallel Sysplex application considerations, Db2 data sharing, and Db2 for z/OS distributed function.
 
Sessions and Abstracts:
 
Why does the Db2 Optimizer need a Data Scientist?
Sheryl Larsen
 
IBM sums up the past 30 years of Db2 for z/OS access path optimization – good for many, great for few. Come find out what IBM is doing about this and how the Db2ZAI solution will fit in your DevOps environment. There are many specific uses cases discussed and time for some futures as this solution keeps on growing.
 
  • How is machine learning and AI infused in today’s Db2 Optimizer?
  • What is a Virtual Data Scientist and what does it eat?
  • Which scenarios are the VDS’s hot spot? i.e. :hv/?, FETCH FIRST/OPTIMIZE FOR n ROWS, more aggressive parallelism , Sort for DISTINCT/ORDER BY improvements
  • What does the VDS provide your Db2 environment?
  • What lies next in the VDS roadmap?
 
 
Db2 12 for z/OS Update
Mark Rader
 
Db2 12 for z/OS has been generally available for over three years and is in production in more and more shops. What are the recent enhancements? What are the recent experiences?
 
This session will review the features in the latest function levels and the other enhancements that are independent of function levels. Along the way, we will discuss how you can take advantage of what other customers have experienced to reduce your migration risk.
 
 
What has the BMC Mainframe Team been up to Lately?
Sheryl Larsen
 
The BMC mainframe team has been very busy since we met last year, receiving dozens of new patents and launching game-changing new solutions. We introduced our BMC Automated Mainframe Intelligence (BMC AMI) brand with BMC AMI for Security and BMC AMI DevOps for Db2®. Our roadmap for this product line continues to grow with two launches of new solutions coming next year. We launched BMC AMI to highlight how we help customers truly modernize the mainframe by infusing artificial intelligence and machine learning into mainframe technology.
 
These innovations build on our many years of domain expertise helping customers run their business efficiently while reinventing for the future. I am very excited to share and discuss these new solutions with you at the user group.
 
 
Db2 for z/OS Know your Limits! 
Ulf Heinrich
 
In this presentation I will show and explain the current number of limits within Db2 on z/OS, starting with relatively basic simple things like DSSIZE or PIECESIZE. Moving on to Linear Dataset limits (32 for Segmented spaces, 254 for LOB),we then will have a quick look at how the COPYPOOL is looking before diving off to the world of PBGs, where you must be aware of MAXPARTIONS among other things. Then we will review SEQUENCES and Numeric Primary Key usage before finally delving into the abstract limit of Db2 within the Db2 engine including DBATs etc.
 
Presentation points:
 
1. DSSIZE or PIECESIZE among other basic simple things
2. Linear Dataset limits (32 for segmented spaces, 254 for LOB)
3. COPYPOOL
4. PBGs & MAXPARTITIONS
5. SEQUENCES and Numeric Primary Key usage
6. Abstract limit of Db2 (DBATs etc.)