Meeting Agenda – May 15, 2019
Db2 for z/OS Program
8:45- 9:15
Registration – Coffee, juice and rolls
9:15 - 10:30
Tablespace Evolvement – PBR2 is the new kid on the block
David Simpson - Themis, Inc
Abstract : The tablespace design has been through many changes and enhancements. This presentation will cover each of the tablespace types including pro’s and con’s and limitations as well as best practices. The emphasis will be on the new tablespace type (Relative Addressing) introduced in Db2 12.
- Tablespace types since the early days of Db2 and their pro’s and con’s.
- Table Controlled Partitioning
- Partition By Growth
- Relative Byte Addressing
10:30 - 10:45
Break
10:45 - 12:00
What’s new in the TEMPORAL world of Db2
Patrick Pitre - Analytics Client Architect, IBM
Abstract : The Temporal Table design was introduced in Db2 10 and there were quite a few restrictions. Some of these were lifted in Db2 11 and Db2 12 has lifted more – but the temporal design has really started to be adopted by Db2 itself, so we will cover the restrictions removed using live examples as well as a detailed walkthrough of how the Db2 engine itself is starting to offer this functionality and predictions for the future.
- Basics before news
- Include / Exclude / Include
- Referential Integrity - how does it all work
- RTS autonomics - No more need to offload RTS on a periodic basis
- Catalog prep for autonomic auditing
12:00 - 1:15
Lunch - Hotel lunch buffet is available: $7 for members, $9 for non-members. Cutoff for registration including the lunch buffet is Friday, May 10th.
1:15 – 2:30
Why does the Db2 for z/OS Optimizer need a Data Scientist?
Sheryl M. Larsen - BMC
Abstract : To sum up the past 30 years of Db2 access path optimization – good for many, great for few. Come find out what IBM is doing about this and how the solution will fit in your DevOps environment. There are four 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, || FOR STATIC, Sort
-
What does the VDS provide your Db2 environment?\
-
What lies next in the VDS roadmap?
2:30-2:45
Break
2:45 - 4:00
An Audit A Day Keeps the Lawyers at Bay
Roy Boxwell - SEGUS
Abstract :
Audit and Compliance is one of the big challenges companies are facing these days. With GDPR and a bunch of other laws either in force or "coming soon to an auditor near you" it is time to bite the bullet and start working with the auditor not against. This presentation shows how you can answer Who did What When ‐ whenever needed.
