Why does the Db2 Optimizer need a Data Scientist?
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
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?
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!
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.
1. DSSIZE or PIECESIZE among other basic simple things
2. Linear Dataset limits (32 for segmented spaces, 254 for LOB)
4. PBGs & MAXPARTITIONS
5. SEQUENCES and Numeric Primary Key usage
6. Abstract limit of Db2 (DBATs etc.)