|MWDUG Friday May 17, 2019
|8:45A - 9:00A
||Doors open / Coffee /Registration
|9:00A - 9:15A
||Introductions, Opening Remarks, IBM News
||Sheryl Larsen, BMC
Tadas Varan, IBM
|9:15A – 10:30A
||What’s new in the TEMPORAL world of Db2.
||Steen Rasmussen, Broadcom/CA
|10:30A – 10:45A
|10:45A - 11:45P
||Proactive Performance Management Using Analytics
||Steen Rasmussen, Broadcom/CA
|11:45P - 12:30P
||Lunch (provided by MWDUG)
|12:30P - 1:30P
||An Audit a Day Keeps the Lawyers at Bay.
||Ulf Heinrich, Segus Software
|1:30P – 1:45P
|1:45P – 2:45P
||Why does the Db2 for z/OS Optimizer need a Data Scientist?
||Sheryl Larsen, BMC
What’s new in the TEMPORAL world of Db2:
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
Proactive Performance Management Using Analytics
Understanding “the normal behavior” of the Db2 applications (static as well as dynamic SQL) can be a challenge but using existing performance metrics and baseline these could put you in a situation where you can act before the SLA’s are violated and even save you a lot of headaches in the “war room” finger pointing.
1) Is the Green Highway Really Green and what is it?
2) Why baselining?
3) Static versus dynamic baselines pros and cons.
4) Moving average and Electric Rules – what’s happening with Db2
5) Avoiding War Room meetings and finger pointing
Speaker Bio: Steen Rasmussen is a Customer Services Consultant currently instrumental in the ongoing development and support of the CA Technologies – A Broadcom Company Db2 solutions. In 1985 Steen started as an IMS/Db2 DBA at a major insurance company in Denmark working with all aspects of Db2 - like tuning, application design and implementation, education of developers, backup and recovery planning and automation of housekeeping processes. During this job, Steen also served as a member of the planning committee for Db2 GUIDE SHARE Nordic Region. In 1995 Steen became a technical manager at PLATINUM Technology managing technical support and presales for the Db2 products. Steen has been working with Db2 for z/OS Release 1.0 since 1985 and is always looking for new opportunities in the CA Db2 solutions which can help customers manage Db2 more efficiently. Besides from providing support to the teams in the field as well as internal groups at CA technologies working with Db2, Steen is also a frequent speaker at IDUG in North America, EMEA and Australia as well as local Db2 User Groups around the world. Since 2014 Steen has been an IBM Champion. Steen has also been the CA liaison for IDUG NA since 2013.
An Audit a Day Keeps the Lawyers at Bay
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. GDPR, GLB HIPAA PCI-DSS Basel III Sarbanes-Oxley CA SB1386 Federal Information Security Management Act “Red Flag” Rules (FRCA)5 are facing us with serious requirements to protect the data we're hosting and to be able to report on a variety of criteria the Auditors may ask for. There's different ways and tools that promise to be able to do it, but what can they really do and what are the associated costs? This presentation introduces Db2 technology exploitation that delivers DML, DDL, DCL activity in a Db2 environment along with identification details. This presentation helps you understanding the way Auditors look at Db2 and what they need to do their daily work. Learn how you can satisfy your Auditors’ needs, by interfacing with a SIEM system, like QRadar, Splunk, AlienVault, et al, combining the Db2 information with RACF, SMF and Master Log data.
Speaker Bio: 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 real-world 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.
Why does the Db2 for z/OS Optimizer need a Data Scientist?
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?
Speaker 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.