September 29, 2022

Virtual
Sponsored By: 
NEDB2UG
Theme: 
Db2 13 topics
Agenda: 
9:00
Opening Remarks
9:15
Db2 Analytics Accelerator and Db2 Data Gate, Present and Future - The View from Development - Daniel Martin IBM
10:30
Getting Ready for DB2 13 - John Lyle, IBM
11:30
Virtual Lunch
12:30
MAXDBAT and CONDBAT, what is the best value I should set them to? Derek Tempongko, IBM
Abstracts and Biographies: 

 

Speaker Bios:

Daniel Martin, IBM

Daniel Martin is the development director and CTO for OpenPages, IDAA and Data Gate, and works out of IBM's Research & Development Lab in Boeblingen, Germany. Previous to this role, he was the lead technical architect of IDAA and Data Gate, and contributed to various parts of these products over the past 10 years. He even remembers the time of the humble beginnings of their predecessor product, then called the "Smart Analytics Optimizer for Db2/z" (ISAO). Daniel has spoken about these products at several conferences and briefings, and can be reached at https://www.linkedin.com/in/daniel-martin-4a3a0998/.

John Lyle, Senior Software Engineer and PDM Team Lead

Bio: John Lyle has worked for IBM at the Silicon Valley Laboratory in the Db2 organization since 1985. Joining Db2 development in 1995, he has worked in the RDS area focusing mostly on the Db2 system catalog, migration and fallback and the data definitional language (DDL) areas as well as the index manager area. He has been the lead designer and implementer of the catalog and fallback changes since V5 and has worked on numerous other development items over the years. John was the lead designer for Db2 9's Clone table function. In V8 - V11 John was the Utility lead for all of the ENFM changes that were made to the Db2 catalog and directory. In V12 John was a development leader and designer in the move to Db2's new continuous development process and also the new Online Migration capabilities. In Db2 13, John was the lead designer in the changes to the migration process. John is currently working in Db2's Provisioning-Deployment-Migration team as the team leader.     

Derek Tempongko, IBM

Derek Tempongko is Software Engineer in Db2 for z/OS development at the IBM Silicon Valley Laboratory.  His primary area of expertise is in Distributed Data Facility (DDF) component of Db2 for z/OS and System Profiles.  
 

 

Sessions and Abstracts:
 

Daniel Martin, IBM

The Db2 Analytics Accelerator for z/OS and Db2 for z/OS Data Gate are closely related IBM offerings that extend a Db2 for z/OS system's capabilities with respect to analytics and in-cloud provisioning of data. The two products, to a greater and greater extent, utilize common technologies to deliver on their functional objectives, and both offerings are key components of IBM's wider data fabric strategy as it relates to z/OS. In this session, Daniel Martin, leader of the IBM team that has development responsibility for the Accelerator and for Data Gate, will offer his perspective on recent significant enhancements of the respective products, and will provide a glimpse into the products' future direction.

John Lyle, IBM

Getting Ready for DB2 13

Abstract: The purpose of this presentation is to introduce the new migration process for the new Db2 13 for z/OS release. The Db2 13 release migration process is significantly different from any previous Db2 release migration. The changes are, in fact, revolutionary. We will detail the Db2 12 to Db2 13 migration process, the Db2 13 Installation process, and go into details regarding application compatibility and the Continuous Delivery process as it relates to Db2 13. Each release brings new migration processes and challenges we will detail the nuts and bolts of the significant Db2 13 process and procedure changes.   

Derek Tempongko, IBM

Title: MAXDBAT and CONDBAT, what is the best value I should set them to?

Abstract:

Db2 for z/OS system parameters MAXDBAT and CONDBAT determines the number of concurrent database access threads and connections that your Db2 system can handle. But how do we decide what is the best value to set this to? In this presentation we will look at some techniques and tools, best practices, to determine the best value to set these important DDF system parameters for your Db2 subsystem. A well-defined pair of MAXDBAT and CONDBAT system parameters in conjunction with Sysplex WLB are critical to how well your Db2 system can operate under peak periods.

The Db2 Analytics Accelerator for z/OS and Db2 for z/OS Data Gate are closely related IBM offerings that extend a Db2 for z/OS system's capabilities with respect to analytics and in-cloud provisioning of data. The two products, to a greater and greater extent, utilize common technologies to deliver on their functional objectives, and both offerings are key components of IBM's wider data fabric strategy as it relates to z/OS. In this session, Daniel Martin, leader of the IBM team that has development responsibility for the Accelerator and for Data Gate, will offer his perspective on recent significant enhancements of the respective products, and will provide a glimpse into the products' future direction.