September 12, 2017 CODUG Meeting

The next Central Ohio DB2 User Group meeting will be September 12, 2017 at the IBM Sterling campus in Dublin, OH (Tuttle Crossing).

We are pleased to welcome Kai Stroh from UBS Hainer and Namik Hrle from IBM as our speakers.. This will be a half day, no-charge meeting.

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

Kai Stroh, UBS Hainer

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.

Bios:

Kai Stroh
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.

Namik Hrle

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.

LOCATION:

IBM/Sterling Campus Building One
6060 Britton Parkway
Dublin OH 43016
Meeting rooms - Auditorium B

Map to the address.

Driving Directions to IBM/Sterling Campus:

  • Hit the Columbus I-270 outerbelt and head to the northwest quadrant of greater Columbus, the suburb of Dublin.
  • Exit onto Tuttle Parkway.
  • Turn to the west ... away from the Tuttle Mall ... head outside the loop ... head towards the countryside
  • Once clear of the highway interchange, at the 1st big light turn right onto Emerald Parkway (turning left would be Britton Parkway)
  • After about 100 feet turn right again into the IBM Sterling Campus.
  • After about 100 feet (again) turn right into the parking lot that is adjacent to Building ONE (6060 Britton Parkway).
  • Enter the foyer of Building ONE and call the number delimited on a sign that will be posted (or call 717-557-9254) for entry assistance.

Register here.

Looking forward to seeing you there.

Registration: