Fall Meeting - Centrl Ohio Db2 Users Group September 12 Meeting Reminder

Tony Andrews

Fall Meeting - Centrl Ohio Db2 Users Group September 12 Meeting Reminder
There is still time to register!

We are honored to add Namik Hrle, IBM Fellow, to our line-up! Namik will be presenting updates on IBM Db2 Analytics Accelerator - News from the Developers!

Namik's Bio:

Namik Hrle is IBM Fellow and works in the IBM Boeblingen Laboratory in Germany. He is an IBM Master Inventor, a member of the IBM Academy of Technology and many other IBM's expert teams. He specializes in Analytics and Information Management technology and its use by the enterprise applications. Namik is currently leading the activities at intersection of System z and Analytics as well as creating synergy between System z and new data platform technologies. A prime example of this work is IBM DB2 Analytics Accelerator which augments DB2 with industry leading complex query performance and appliance simplicity.

AGENDA:
8:30 - 9:00 Registration
9:00 - 9:05 Welcome and Opening Remarks
9:05 - 10:00 Set up a copy process in less time than it takes to make a cup of coffee - Kai Stroh
10:00 - 10:15 Break
10:15 - 11:15 IBM DB2 Analytics Accelerator Update, News from the Developers - Namik Hrle
11:15 - 11:30 Break
11:30 - 12:30 Navigating The Pitfalls Of Cross Platform Copying - Kai Stroh
12:30 - 12:40 Closing Remarks


Registration link is open http://www.codug.org/events/september-12-2017-codug-meeting !


The Central Ohio DB2 User's Group (CODUG) announces its next meeting - Tuesday, September 12, 2017 at the IBM branch office in Dublin OH. This will be a morning meeting only!

We are pleased to welcome Kai Stroh from UBS/ESAi our speaker. Kai's topics will be:

Abstract: Set up a copy process in less time than it takes to make a cup of coffee

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.

Abstract: Navigating The Pitfalls Of Cross Platform Copying

Description: Copying tables between a mainframe and a distributed system using an ETL process is not as straightforward as it may seem. This presentation explains how to exchange data, including LOB and XML data, between z/OS and Unix / Windows.
Abstract: Copying tables between a mainframe and a distributed system using an ETL process is not as straightforward as it may seem. Data sets on z/OS and files on a Unix or Windows platform differ considerably with regard to both their file system level attributes and their internal structure and encoding. This presentation explains how to bridge these gaps and exchange data, including LOB and XML data, between both worlds.

Bio:

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.

Please visit our website for additional information at http://www.codug.org/


Tony Andrews