From the Atlanta Db2 Users Group: - 2018-12-07
Have you ever wondered about Data Virtualization, have you ever asked your self “why do we spend so much time coping data, why can we just read it in place?” Join us for an architectural look at Data Virtualization and then a demo of Data Virtualization Manger.
If you or developers at your company use Structured Query Language (SQL) then join us for Robert Catterall’s talk on SQL enhancements for Db2 12 for z/OS, all good tips and tricks to improve SQL running against your database.
A very hot topic is a machine learning (ML) and artificial intelligence (AI). IBM is actively integrating both of these into the Db2 12 for z/OS. Join us for Robert’s session on AI in the Db2 12 for z/OS optimizer and what is changing, come learn more with Robert and the group.
Please mark your calendars for our next meeting meeting of the Atlanta Db2 Users Group on the 7th of December, 2018. Our agenda is below.
We look forward to seeing you all there.
Rhonda, Susan, Stan, Robert, Rodger and Ted.
December 7th 2018 meeting:
What’s on the Agenda?
8:30 – 9:00 Greeting / Registration / Continental Breakfast
9:00 to 9:05 ADUG News – Ted Alexander/Susan Eisen
9:10 – 10:30.
Session 1: Enterprise Architecture and DVM
Speaker: Stan Muse – IBM
Description: Presenting a high-level enterprise data architecture model and integrating data virtualization concepts, while outlining how data virtualization can be used to simplify the enterprise data architecture while providing better access to real-time data, and lower costs. He will present IBM’s Data Virtualization Manager, some use cases for DVM, and how it works.
Mr. Muse has worked for IBM for over 40 years. During that time, he’s worked in the software development labs primarily on database products, various consulting organizations, and customer sales. Stan wrote many parts of the IMS Pointer Checker and supported the DB2 Utilities Suite. He worked with Ted Codd and Chris Date in the early days of DB2. He also consulted with Bill Inmon on data warehouse architectures, and was a reviewer on Dr. Tom Johnston’s books on data modeling. Stan was a Services Principal in the IBM Consulting Group, ISSC, GBS, and IBM Data Management Lab Services.He has architected and managed over 20 data warehouse projects for US IBM Finance Industry customers. He also has US and German patents on the IBM DB2 Analytics Accelerator (IDAA).Stan is currently a Senior System z Architect covering customers in the Finance Industry with IBM.And a long-time supporter of the Atlanta Db2 Users Group.
Morning Break around 10:30am – 10:40am (somewhere in there) then
Session2: SQL Enhancements Delivered with Db2 12 for z/OS
Speaker: Robert Catterall
Description: Every version of Db2 for z/OS introduces new SQL-related capabilities, and Db2 12 is no exception. In this session I will describe new SQL features delivered with Db2 12, including temporal enhancements, the native REST interface, the new-and-improved MERGE statement, piece-wise DELETE, result set pagination, advanced triggers, "real" Unicode columns in EBCDIC tables, global variable enhancements, new built-in functions, and more.
Robert Catterall is a DB2 for z/OS Specialist zChampion IBM. 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 IDUG, a member of IDUG’s Speakers Hall of Fame, and was one of IBM’s inaugural Information Champions.
He presents frequently at conferences, is a longtime columnist for IBM Data Magazine, and blogs about DB2 for z/OS at http://robertsdb2blog.blogspot.com/. Robert has been a long time supporter of The Atlanta Db2 Users Group, Thank you Robert for all your support for the ADUG group.
Break for Lunch around 12:Noon. For 30 minutes or so
Session 3: The Learning Optimizer: An Overview of IBM Db2 AI for z/OS
Speaker: Robert Catterall
Description: 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.
Afternoon Stretch Break: 2:15pm to 2:25pm
2:25pm to 3:40pm
Session 4: IBM Data Virtualization for the Enterprise
Speaker: Milan Babiak – IBM - Canada
Real-time universal access to mainframe and non-mainframe data
Description: Large amounts of data accumulated over decades on variety of data management system present a wealth of information for your enterprise analytics, but to satisfy current analytics needs - modern APIs, web services, mobile, real-time analytics, security - presents challenges. The concept of Data Virtualization addresses these challenges in three key areas:
1. Data Access Modernization for Business Intelligence and Data Science
2. Real Time Analytics
3. Data Access Optimization and Data Security
They provide a universal, transparent data access for modern application developers, data scientist, financial analysts and many other enterprise data consumers while saving time and ETL costs.
IBM Data Virtualization Manager for z/OS implements this concept on a highly secure, reliable mainframe platform, with the ability to access not only traditional mainframe data - IMS, VSAM, Db2 for z/OS, SMF, RMF, ... , but also non-mainframe data sources - Oracle, Microsoft SQL Server, Hadoop, and many other data sources
Milan is Client Technical Professional at IBM. He creates and presents solutions and product demonstrations for IBM clients. His specialty is Analytics on IBM Z Systems - Mainframe. He earned his Master of Computer Science degree from Slovak Technical University Bratislava, Slovakia. Milan is a regular presenter and motivational speaker at conferences, IBM educational seminars, customer workshops, and Toastmasters meetings in Canada, US and Europe. His passion is explaining complex technical topics in a simple, understandable language to wide audiences. He is also an active member and club executive at IBM Toastmasters in Ottawa, Ontario, Canada.
LinkedIn: https://www.linkedin.com/in/milanbabiak/ Twitter: https://twitter.com/BabiakMilan
DB2 versions, and this includes the unique in-house DB2 sub-systems which each have their own little technical adaptations.
Location: Welcome to IBM Barfield Road Technical Exploration Center (TEC)
IBM Barfield Road is located in the Sandy Springs area of Atlanta at 6303 Barfield Road. It is easily accessible from I-285 via the Glenridge Dr exit from the west and Peachtree – Dunwoody exit from the east. From the north, there is a convenient exit off GA 400 at Hammond Drive. There are multiple shopping and dining venues within close proximity to the site along with the Dunwoody MARTA station.
A multi-level parking deck is located directly behind buildings A & B. The main entrance to the facility can be accessed from level 4 of the deck. The IBM TEC facility is located on the first floor of Building A.
Location and Directions:
Meeting Location: (same location we have been meeting at)
IBM Corp (Building A)
6303 Barfield Rd., NE
Atlanta, GA 30328
Technical Exploration Center
Main Guard Desk: (404) 348-9004
Driving Directions To IBM:
From the NORTH:
Take GA 400 South and take Exit 5 (Dunwoody Sandy Springs). At the bottom of the exit ramp, turn right onto Abernathy Road. At the fist light turn left onto Barfield Road. Go through the next light (Mt. Vernon Highway) you will see the IBM campus on the left. Visitor Parking is behind the building, on Level 4.
From the SOUTH:
I-75 North and I-85 North converge south of Atlanta and stay together through downtown. Stay on I-85 North when I-75 splits off again north of downtown. Several miles later GA400 will exit off to the right. Follow GA400 North past I-285 and take Exit 5A (Dunwoody Sandy Springs). This will ramp you onto Abernathy Road. At the first light turn right onto Peachtree-Dunwoody Road, and then at the next light take another right onto Mt. Vernon Highway. Cross back over GA 400, and turn left onto Barfield Road. You will see the IBM campus on the left. Visitor Parking is behind the building, on Level 4.
From the EAST:
Take I-285 Westbound to GA 400 North and take Exit 5A (Dunwoody Sandy Springs). This will ramp you onto Abernathy Road. At the first light turn right onto Peachtree-Dunwoody Road, and then at the next light take another right onto Mt. Vernon Highway. Cross back over GA 400, and turn left onto Barfield Road. You will see the IBM campus on the left. Visitor Parking is behind the building, on Level 4.
From the WEST:
Take I-285 Eastbound to GA 400 North and take Exit 5A (Dunwoody Sandy Springs). This will ramp you onto Abernathy Road. At the first light turn right onto Peachtree-Dunwoody Road, and then at the next light take another right onto Mt. Vernon Highway. Cross back over GA 400, and turn left onto Barfield Road. You will see the IBM campus on the left. Visitor Parking is behind the building, on Level 4.
Payment for this meeting will be $45 (preregistration or at the door). IBM, is sponsoring this meeting, so many thanks to the them for helping keep cost low.. You can pay at the door, however, you still need pre-register by sending Rhonda, Susan or Ted an email or you can send it to:
Please put “ADUG 12-07-2018 Registration” in the subject line. Include your name and company name along with a phone number.
Please respond by Wednesday, December 5th, 2018, so we can accurately estimate the food.
Don’t let payment stop you from coming to the meeting. For some companies, it’s difficult to make this schedule, so attend, let Rhonda know to make a note by your name and send the payment when it has made it through your company’s steps.
Security Steps: We need you to pre-register for Security as well.
There will be a security check point and you need to be on the list that will be built from your emails. Please supply your name, company name and phone number in the email and bring a picture ID.
Last thing, if you have any events that you get in your email and think they could be of interest to others in the group, please forward them to me and I will at least get them up on the website. If there are enough of them I will send them out in a Newsletter like this one.
Thanks to Stan Muse, Roger Sanders, Robert Catterall all from IBM for helping with this meeting.
If you have other meetings, webinars or events, please send it my way.
Thanks, stay safe this summer;
President Atlanta DB2 Users Group