Following his successful hands-on IDAA class in Columbus, Frank Fillmore will be presenting on the IDAA at the September Baltimore/Washington Db2 Users Group, scheduled for Wednesday, September 12th. Frank’s presentation and bio are below – last, per his request – keep reading – !
If you are in the area September 12th please join us. If you have any questions on the upcoming meeting or are interested in presenting please contact me.
Date: Wednesday, September 12th, 2018
Time: 9:00 AM – 3:30 PM (registration at 8:30)
Location: Hilton Baltimore BWI Airport, 1739 W Nursery Road, 21090
Fees: Pre-registered members: $30, Pre-registered non-members: $40
At-the-door: Members: $40, non-members: $50
Schedule:
Registration
8:30 – 9:00
9:00 – 10:15: Copy Smarter – Unload/Load, DSN1COPY and Beyond
Kai Stroh, UBS Hainer
When you get tasked with setting up a refresh process for thousands of Db2 z/OS tables you probably have a few thoughts running through your head: How long does it take to create all the required jobs? How long for all the control cards? Do all the target tables exist, or are there any new tables in production? Have tables been changed? Better double check if the tables have grown or if Db2 has added more VSAMs so that you don’t run out of space halfway through like last time. Don’t forget catalog statistics and RTS. And those identity columns and sequences – they’re always trouble. What seems like little bits and pieces at first can really stretch your staff thin, which is why automation is key if you want to save time and energy. This presentation discusses advantages and disadvantages of different utilities that copy Db2 data, but the main focus is automating all the side tasks that DBAs usually need to do in addition to copying the data itself.
10:15 – 10:30: Break
10:30 – 11:45: Log Enhanced Copies for 24×7 DB2 Refresh/Migration
Kai Stroh, UBS Hainer
LOB compression is one of the more interesting features of Db2 12. It promises performance gains for your application that use LOB’s, coupled with disk savings! This presentation provides an overview of the feature, and discusses some of the performance characteristics. Then we move on to pros and cons, and a process for taking advantage of the feature.
11:45 – 12:45: Lunch
12:45 – 2:00: Machine Learning
Jonathan Sloan, IBM
Gain an overall understanding of Machine Learning for z/OS and its role in enabling advanced analytics on IBM Z. You will learn how this machine learning technology integrates with Db2 Analytics Accelerator and Db2 for z/OS to drive real-time insight on an enterprise scale.
2:00 – 2:15: Break
2:15 – 3:30: IBM Db2 Analytics Accelerator (IDAA) V7 had a Brain and Heart Transplant
Frank Fillmore, The Fillmore Group
IBM Db2 Analytics Accelerator (IDAA) v7 has been completely re-engineered. Previous IDAA versions were based on legacy Netezza technology including PostgreSQL (the “brain”) and Field Programmable Gate Arrays (FPGA – the “heart”). IDAA v7 – aka “Sailfish” – uses Db2 with BLU Acceleration and POWER processors. The benefits are greater compatibility between Db2 for z/OS and the IDAA, fewer hardware problems, improved Incremental Update latency, and lots more. If you are an existing IDAA shop considering migrating to v7 or have not previously considered IDAA, this presentation will cover what you need to know.
Speaker:
Kai Stroh earned a Computer Science degree from the University of Darmstadt and is a mainframe software developer specializing in Db2 utilities for z/OS. He designs and builds innovative Db2 applications and utilities often working onsite or remotely with UBS’ international clients. He easily navigates his way around Db2 dumps and knows how to move data and definitions across Db2 versions, and this includes the unique in-house Db2 subsystems which each have their own little technical adaptations.
Jonathan Sloan is a Senior Certified Executive Software IT Specialist, with more than two decades experience successfully leading, selling and implementing business analytic and data warehouse applications as a vendor as well as an implementer. He joined IBM in 2000 and specializes in helping customers understand the application of IBM Information management technology to business problems.
Frank C. Fillmore, Jr. is the Founder and President of The Fillmore Group, Inc., a Premier IBM Business Partner specializing in Hybrid Cloud and Analytics. Frank has been a Db2 Gold Consultant since 1998 and currently is an IBM Champion for both Analytics and System z. Frank has frequently presented on cutting-edge topics at regional and international Db2 Users Group meetings and the IBM Insight conference.
