Seminar Program

September 13, 2017

Location: The Crowne Plaza Hotel , Novi Michigan

        
  
8:15 am - 9:00 am Check In/Continental Breakfast
 
9:00 am - 10:00 am "Inline LOBs – Dare We Go There?”
Speaker: David Baldon (BMC)
Download "Inline LOBs – Dare We Go There?”
  
10:00 am - 10:15 am Break
  
10:15 am - 11:00 pm "What’s Log Got To Do, Got To Do With It?”
Speaker: David Baldon (BMC)
Download "What’s Log Got To Do, Got To Do With It?”
 
11:00 am - 11:15 am Break
  
11:15 am - 12:15 pm "Set up a Copy Process in Less Time Than it Takes to Make a Cup of Coffee"
Speaker: Kai Stroh (UBS Hainer)
Download "Set up a Copy Process in Less Time Than it Takes to Make a Cup of Coffee"
 
12:15 pm - 1:15 pm Lunch - included as part of the seminar
 
  
1:15 pm - 2:15 pm "Navigating the Pitfalls of Cross Platform Copying”
Speaker: Kai Stroh (UBS Hainer)
Download "Navigating the Pitfalls of Cross Platform Copying”
  
2:15 pm - 2:45 pm "MDUG Update: 2018 Plans and Financial Report"
     

 

Presentation Abstracts

Presentation #1:

Speaker: David Baldon (BMC) - "Inline LOBs – Dare We Go There?”

A Db2 large object (LOB) column definition initially stored a pointer in the base table to the value in an auxiliary table space. An inline LOB allows the table designer to store a portion of a LOB column in the base table space. For LOBs that are less than or equal to the size of the specified inline length, Db2 stores the complete LOB data in the base table space. This presentation gives an overview of using INLINE LOBs including how they work, how to create them, and how to configure them to maximize DASD and processing savings.

Presentation #2:

Speaker: David Baldon (BMC) – "What’s Log Got To Do, Got To Do With It?”

David will also present is a primer related the Db2 log and how to make use of it in ways you may not have considered. David will be giving this presentation at IDUG’s tech conference in Lisbon this October, so you will be privy to the latest research in this area.

Presentation #3:

Speaker: Kai Stroh (UBS Hainer) – "Set Up a Copy Process in Less Time Than it Takes to Make a Cup of Coffee"

Abstract:

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.

Presentation #4:

Speaker: Kai Stroh (UBS Hainer) – "Navigating the pitfalls of cross platform copying”

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.

 

Speaker Biographies

David Baldon (BMC)

David Baldon is a Solution Architect for Db2 backup and recovery at BMC. He has been writing applications for the IBM mainframe since 1985.

Kai Stroh (UBS Hainer)
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.