Loading…
Simple
Expanded
Grid
By Venue
Map
Sunday, October 27
 

TBA

IDUG Db2 Fundamentals for LUW
Sunday October 27, 2024 TBA
1 | Multi 1D
Sunday October 27, 2024 TBA
1 | Multi 1D
  IDUG Fundamentals

TBA

IDUG Db2 Fundamentals for z/OS
Sunday October 27, 2024 TBA
1 | Multi 1A
Sunday October 27, 2024 TBA
1 | Multi 1A
  IDUG Fundamentals

09:00 CET

A201 | Infusing Db2 for z/OS with AI: Hands-on lab with IBM Db2 AI 1.6 for z/OS
Sunday October 27, 2024 09:00 - 13:00 CET
1 | Breakout 1
Get hands-on experience with IBM Db2 AI for z/OS, a powerful new offering built on machine learning. Learn how Db2 AI can: optimize SQL statements, provide Db2 system assessments with expert guidance for tuning your subsystem, use the Distributed Connection Controller to learn remote workload traffic and generate Db2 profiles to monitor and control remote connection access of Db2's distributed server for location, user ID, and application name, and monitor system performance with a new performance insight visualization dashboard.
Speakers
avatar for Diego Cardalliaguet
avatar for Vincent Rabsatt
Sunday October 27, 2024 09:00 - 13:00 CET
1 | Breakout 1
  Hands-On Lab

09:00 CET

B201 | Hands-On: Build and Deploy AI Models with IBM Db2
Sunday October 27, 2024 09:00 - 13:00 CET
1 | Breakout 2
IBM Db2 offers a wide range of AI features, both built-in and external tools, for creating AI systems and solutions. These include over 200 built-in AI stored procedures and tools that work seamlessly with open-source AI ecosystems. In this workshop, participants will explore Db2’s AI support and use a selection of these features to implement practical AI models. The workshop consists of two parts. In the first module, participants will learn how to develop a supervised AI model using Db2’s built-in AI stored procedures. The entire model development and usage will be done using SQL within the database. In the second module, participants will learn how to create a Python model using popular Python packages outside of the database, and then deploy that model back into a Db2 database. By the end of the workshop, participants will have gained fundamental skills and hands-on experience in utilizing these AI capabilities. They will be able to apply these skills to their future AI projects. This workshop is designed to be beginner-friendly and does not require participants to have extensive knowledge in AI. Basic SQL skills and some Python programming skills are sufficient for attending and benefiting from this workshop.
Speakers
avatar for Shaikh Quader

Shaikh Quader

AI Architect, IBM Db2, IBM
Shaikh Quader is the AI architect at IBM Db2. His role involves developing product features to enhance database operations with AI and allow users in implementing AI solutions with Db2. Shaikh also manages research collaborations between IBM and Canadian universities. He and his team... Read More →
Sunday October 27, 2024 09:00 - 13:00 CET
1 | Breakout 2
  Hands-On Lab

09:00 CET

C201 | Using Ansible To Automate Db2 Schema Deployment
Sunday October 27, 2024 09:00 - 13:00 CET
1 | Breakout 3
Are you exploring how to exploit Ansible on your DevOps journey? Or, you may be well on your way towards standardizing on Ansible. Either way, our workshop will introduce you to a Broadcom developed Ansible collection that will empower you to automate your Db2 for z/OS Schema Management the Ansible way. This Ansible collection will be a powerful tool to enable a developer to provision the Db2 environment needed to test an application. It also has the necessary capabilities to automate deployment of any schema changes. In this workshop you will have the opportunity for an instructor-led hands on experience with the Broadcom DBM-Db2 Ansible collection. You will learn ways to use the collection in ad hoc mode as well as understand how to develop Ansible playbooks to achieve your goal.
Speakers
avatar for Toine Michielse

Toine Michielse

Solutions Architect, Broadcom
I have been working with Db2 for z/OS ever since V1. In my career I have worked as COBOL/IMS/DB2 programmer, IMS/DB2 DBA and DB2 system engineer. I have worked a number of years as a Db2 Lab advocate, supporting IBM customers worldwide. Before joining Broadcom I worked at SwissRe... Read More →
Sunday October 27, 2024 09:00 - 13:00 CET
1 | Breakout 3
  Hands-On Lab

09:00 CET

D201 | Cloud Pak for Data - A Short Introduction
Sunday October 27, 2024 09:00 - 13:00 CET
1 | Breakout 8
Cloud Pak for Data, we've all heard of it before, but what can it do? Which components are inside of this offering and why would we combine this with Db2? This presentation present some key takeaways on the IBM Data Fabric solution and zooms in on its functional and technical architecture.
First, the presentation will explain how the Cloud Pak sits within a typical data architecture, with special attention to the uses cases of Db2 Warehouse en Watsonx.data. Next, we will discuss the main components and how they differ from their non-Cloud Pak counterparts. Finally, we discuss the deployment and licensing on different platforms.
Speakers
avatar for Ludovic Janssens

Ludovic Janssens

Lead Architect, Infocura
I graduated as an Archaeologist. Although ancient times still fascinate me, I got involved in IT and learned about databases, rexx and cobol. In the past 20 years, I spent a lot of time being a Db2 for z/OS expert. I have been an IBM Champion for a few years and I presented on several... Read More →
Sunday October 27, 2024 09:00 - 13:00 CET
1 | Breakout 8
  Workshop

14:00 CET

A202 | Hands-on Lab: IBM Z Anomaly Analytics for Db2 Performance
Sunday October 27, 2024 14:00 - 18:00 CET
1 | Breakout 1
This lab session is provide the attendees the hands-on experience to explore how AI enabled monitoring solution, with a trained ML model, can help manage DB2 and z/OS performance to empower you to become more proactive before the problem damages the system.  The lab is hosted on an IBM live z/OS environment via internet.  The instructor will be on-site providing a lab guide and answering questions.  The lab guide gives step-by-step instructions to take you through Db2 problem solving scenarios with AI-ML scoring in action.  Bring your own laptop device, and we will set it up for you to login to this AI-ML lab on a live IBM Z system.
Speakers
avatar for Lih Wang

Lih Wang

Executive Client Technical Specialist, IBM
Lih M Wang is an Executive Client Technical Specialist at IBM Technology Software Group. She has over 30 years of experience in performance monitoring and tuning for IBM zSystems and Db2 in the software industry. For AI use cases, Lih has performed a variety of Proof-of-Concept projects... Read More →
Sunday October 27, 2024 14:00 - 18:00 CET
1 | Breakout 1
  Hands-On Lab

14:00 CET

B202 | Setting up a Secure Db2 LUW Environment
Sunday October 27, 2024 14:00 - 18:00 CET
1 | Breakout 2
A secure environment while operating Db2 has become of utmost importance as the cost of cyberattack and data breach increase year by year. The purpose of this hands on lab is to provide guidance on building a secure Db2 environment with some of Db2’s latest security features. In this hands-on workshop, participants will learn about Db2 security services including configuring TLS, Native Encryption, Row and Column Access Control, and the Db2 Audit Facility.
Speakers
avatar for Greg Stager

Greg Stager

Db2 LUW Security Architect, IBM Canada
Greg Stager is the security architect for Db2 LUW at the IBM Toronto Lab. Greg has been a member of the Db2 security development team since 2000, where he has worked on all aspects of security within Db2, including authentication, authorization, auditing and encryption.
Sunday October 27, 2024 14:00 - 18:00 CET
1 | Breakout 2
  Hands-On Lab

14:00 CET

C202 | The Building Blocks of Transformation: Bridging the Gap from the 3270 Terminal
Sunday October 27, 2024 14:00 - 18:00 CET
1 | Breakout 3
We hear a lot about the open mainframe, but what does it really mean?  Depending on your role and organization boundary, the definition of open mainframe can vary.  At Broadcom, our point of view on the open mainframe is essentially to enable those capabilities our customers need to effectively manage this critical component of their hybrid IT architecture, as services.  This is supported through our Database Management Data Service (DBM-DS) architecture built to be Zowe compliant, leveraging the many benefits provided by the Zowe API mediation layer (API-ML).  Come join our workshop to learn best practices for standing up a DBM-DS instance and API-ML which will then open the doors to many exciting use cases enabled through a web-based interactive user interface. 
Speakers
avatar for Andrew Badgley

Andrew Badgley

Lead Product Owner - Database Tools, Broadcom
avatar for Samantha Buhler

Samantha Buhler

Product Manager, Broadcom
Samantha Buhler has always worked in and around the mainframe, starting her mainframe career at IBM as a pricing and investment analyst for Db2 for z/OS and IMS.  In that capacity, she not only helped to deliver Db2 versions 8 and 9 to market but was also instrumental in making zIIP... Read More →
Sunday October 27, 2024 14:00 - 18:00 CET
1 | Breakout 3
  Workshop

14:00 CET

D202 | Db2 Data Sharing Locking - To care or not to care ?
Sunday October 27, 2024 14:00 - 18:00 CET
1 | Breakout 8

When running a DB2 data sharing system; understanding global locking is critical togood application and system performance.This double session will describe how DB2data sharing locking works under the covers. The session will also explain whatinformation you have at your disposal to understand the data sharing lockingcharacteristics of your system; and how to influence and tune your data sharing lockingbehavior for various types of problems that you may encounter.
Speakers
avatar for Bart Steegmans

Bart Steegmans

Db2 for z/OS Software Support - Performance, IBM
Bart Steegmans is a Consulting Db2 Product Support Specialist from IBM Belgium. He isworking remotely for the Silicon Valley Laboratory in San Jose and providing technicalsupport for Db2 for z/OS performance problems. He has 35 years of experience in Db2.Before joining IBM in 1997... Read More →
Sunday October 27, 2024 14:00 - 18:00 CET
1 | Breakout 8
  Workshop
 
Monday, October 28
 

TBA

z/OS Certification
Monday October 28, 2024 TBA
All onsite attendees at IDUG EMEA 2024 are eligible to receive a complimentary z/OS certification exam with their paid registration. If you have indicated z/OS as your primary platform in your registration form, you will be receiving an e-mail containing a voucher number and instructions before November 30. Questions? e-mail idug@idug.org.
Monday October 28, 2024 TBA
  Badging & Certification

08:45 CET

IDUG Opening Comments
Monday October 28, 2024 08:45 - 09:00 CET
0 | Auditorium 2
Monday October 28, 2024 08:45 - 09:00 CET
0 | Auditorium 2
  Opening Comments

09:00 CET

Keynote | What's Next in Computing and What it Means for your Data and AI Strategy
Monday October 28, 2024 09:00 - 10:00 CET
0 | Auditorium 2
Join Namik Hrle and Minaz Merali for an exclusive keynote session on technology trends in the market and how you can accelerate the impact of AI in your organization. The success of AI in business hinges on high-quality, secure data. Enterprises that double their ROI from AI have invested in trustworthy, governed data. Yet, data is rapidly expanding in volume and variety, challenging organizations to effectively manage and utilize diverse, unstructured and structured data sources in their AI. In this session, learn about the latest innovations in Db2 and how clients have achieved data-driven transformation within their organization.
Speakers
avatar for Namik Hrle

Namik Hrle

IBM Fellow and VP, Z Data Strategy, IBM
Namik Hrle is a Vice President of Development in IBM’s Software division and the Director of its development lab in Germany. He holds a title of IBM Fellow, the ultimate distinction of IBM technical career given to a small number of individuals who demonstrated the highest level... Read More →
avatar for Minaz Merali

Minaz Merali

Vice President, Product Management, Data & AI, IBM
Minaz Merali is the Vice President of Product Management for IBM’s multi-billion dollar Data Management portfolio where she is responsible for product strategy, innovation and strategic partnerships. She has been at IBM for over 20 years in the areas of Cloud, IBM Z and now Data... Read More →
Monday October 28, 2024 09:00 - 10:00 CET
0 | Auditorium 2
  Keynote, IDUG EMEA VIRTUAL SESSION

10:00 CET

Coffee Break
Monday October 28, 2024 10:00 - 10:20 CET
TBA
Monday October 28, 2024 10:00 - 10:20 CET
TBA
  Coffee Break

10:20 CET

A1 | Db2 for z/OS Spotlight: Trends and Directions from the Lab
Monday October 28, 2024 10:20 - 11:20 CET
0 | Auditorium 2
Over the past four decades, Db2 for z/OS has gained a reputation for rock solid stability and groundbreaking innovation. As a result it has come to underpin much of the world’s economy and is depended upon by many of the largest corporations, enterprises and government agencies across the world. This session will review development strategy and vision in an evolving world. We will assess where we are today with Db2 13 and look forward to maintain Db2 for z/OS as the system of record for the next forty years.
Speakers
avatar for Haakon Roberts

Haakon Roberts

Director, CTO, IBM
Haakon Roberts is an IBM Distinguished Engineer based at the Silicon Valley Laboratory in San Jose, California. He is the Director of the Db2 for z/OS and Tools organization and CTO of IBM z Data & AI. He holds several patents and is a leading expert in database management, data integrity... Read More →
Monday October 28, 2024 10:20 - 11:20 CET
0 | Auditorium 2
  Technical Session, IDUG EMEA VIRTUAL SESSION

10:20 CET

B1 | Db2 Latest from the Lab
Monday October 28, 2024 10:20 - 11:20 CET
0 | Auditorium 3A
Both an overview and a deep dive of recently shipped / announced Db2 content, and then a look into what is coming soon.
Speakers
avatar for Mike Springgay

Mike Springgay

Db2 Architect, IBM
Mike Springgay is the Db2 Architect. Prior to that he was responsible for architecting extensions to Db2’s Warehouse capabilities, SQL compatibility features, routine infrastructure and client server connectivity.
Monday October 28, 2024 10:20 - 11:20 CET
0 | Auditorium 3A
  Technical Session, IDUG EMEA VIRTUAL SESSION

10:20 CET

E1 | Recovery in Db2: The End-To-End Journey of Your Data
Monday October 28, 2024 10:20 - 11:20 CET
0 | Auditorium 3B
Join this session to learn all about optimizing recoverability for your Db2 subsystems. We will take a closer look into Db2 for z/OS, exploring its features from the basics of backup and recovery to advanced techniques, ensuring Data Compliance and Recovery Integrity. We also will navigate the end-to-end journey of your data, from creation to secure resting on a disk, emphasizing the critical role of compliance.
Speakers
avatar for Aysen Svoboda

Aysen Svoboda

Product Owner, Broadcom
With over 15 years of hands-on experience in mainframe technology, I've worn various hats as a DBA and System Programmer across different countries and organizations. Now, as a Product Owner, I focus on delivering top-notch solutions tailored to the needs of mainframe professionals... Read More →
Monday October 28, 2024 10:20 - 11:20 CET
0 | Auditorium 3B
  Technical Session, IDUG EMEA VIRTUAL SESSION

10:20 CET

F1 | Inside Db2 for z/OS Indexes: Structure Demystified
Monday October 28, 2024 10:20 - 11:20 CET
1 | Breakout 3 + 4
"Indexes play a pivotal role in optimizing the query performance and data retrieval." Getting tired of hearing this statement repeatedly and wondering about the magic behind database indexes?
In this session, we will be diving into the heart of it and will see about the internal structure of Db2 for z/OS indexes, how a balanced tree structure is used in index management, and walk through how to gain an understanding of the organization of index pages and its role in causing slow-performing queries. 
Taking a journey through Db2 for z/OS index pages and leaf nodes, we’ll get a comprehensive and detailed insight into the foundational elements that impact the efficiency and effectiveness of database operations, creating a compass for navigating the complex terrain of database performance.
Speakers
avatar for Karthikeyan Dhanapal

Karthikeyan Dhanapal

Lead Product Developer, BMC Software
I'm Karthikeyan Dhanapal, a Lead Product Developer at BMC Software with over 20 years of experience in distributed and z/OS platform. Throughout my career, I've led teams and worked in developing sub-systems, utilities, automation frameworks, and network stacks/protocols.
Monday October 28, 2024 10:20 - 11:20 CET
1 | Breakout 3 + 4
  Technical Session

11:20 CET

Break
Monday October 28, 2024 11:20 - 11:30 CET
TBA
Monday October 28, 2024 11:20 - 11:30 CET
TBA
  Break

11:30 CET

A2 | Db2 13 for z/OS : Performance Monitoring Updates
Monday October 28, 2024 11:30 - 12:30 CET
0 | Auditorium 2
Db2 for z/OS continues to improve the performance monitoring in various ways based on our customers’ needs. This session discusses the latest performance monitoring information on Db2 for z/OS that have been updated through Db2 13 and continuous deliveries.  It includes  the recommended set of data collections on the various situations,  updates on key performance metrics to monitor as well as performance diagnostic updates. 
Speakers
avatar for Akiko Hoshikawa

Akiko Hoshikawa

Db2 for z/OS Development, IBM
Akiko Hoshikawa is a Distinguished Engineer at IBM Silicon Valley Laboratory in San Jose. As a Db2 for z/OS architect she has overall responsibility for the performance and strategic integration of AI capability within IBM Db2 for z/OS, including the Db2 AI for z/OS product
Monday October 28, 2024 11:30 - 12:30 CET
0 | Auditorium 2
  Technical Session

11:30 CET

B2 | Introducing the Db2 AI Query Optimizer
Monday October 28, 2024 11:30 - 12:30 CET
0 | Auditorium 3A
Wouldn't it be great if Db2 could automatically determine ideal access plans based on hidden correlations discovered in your table data? That's the idea behind Db2's AI Query Optimizer, a key new feature in Db2 v12 for LUW. This talk will go through the basics of how the Db2 AI Query Optimizer automatically trains machine learning models that discover hidden data correlations. These machine learning models are later used at SQL query compilation time to generate better runtime access plans, making your queries run faster. All of this is done automatically, under the covers.
Speakers
avatar for Liam Finnie

Liam Finnie

Senior Software Developer, IBM
Liam joined IBM in 1999 as a software developer, and has been working in various parts of Db2 LUW since. He has been involved in the design and implementation of the Db2 Self-Tuning Memory Manager, Db2 pureScale, and columnar engine storage enhancements. Most recently, he has been... Read More →
Monday October 28, 2024 11:30 - 12:30 CET
0 | Auditorium 3A
  Technical Session

11:30 CET

C2 | Explain Essentials for Query Optimization
Monday October 28, 2024 11:30 - 12:30 CET
1 | Breakout 1 + 2
One of the most important factors in query performance is the access plan chosen by the Db2 query optimizer. Understanding the query access plan is essential to understanding query performance and the explain facility is the way to get the access plan. But SQL statements can be issued in different ways (dynamic, static, procedures, application programs) and access plans can exist in a variety of contexts (system catalogs, dynamic statement cache, monitoring tables), so getting the correct access plan for the correct statement can sometimes be a challenge. This presentation will cover the most important techniques for collecting and using explain information so that you can quickly and effectively understand your access plans to achieve and maintain the best possible query performance.
Speakers
avatar for John Hornibrook

John Hornibrook

Senior Technical Staff Member, IBM Canada
John is a Senior Technical Staff Member responsible for relational database query optimization on IBM's distributed platforms. This technology is part of Db2 for Linux, UNIX and Windows, Db2 Warehouse, Db2 on Cloud, IBM Integrated Analytics System (IIAS), IBM Db2 Analytics Accelerator... Read More →
Monday October 28, 2024 11:30 - 12:30 CET
1 | Breakout 1 + 2
  Technical Session

11:30 CET

D2 | Do you just reorg or do you Rock 'n Reorg
Monday October 28, 2024 11:30 - 12:30 CET
1 | Breakout 8
I have noticed that everybody knows the word Reorg, but not so many know what for it really is. And if we talk about the member cluster, I would bet that a huge number of tables has as cluster index, just the unique, primary key or just the first it was created.
I mean, if I sell books, why do I have my Cluster-Index by ISBN instead of having it by author for example. As it's most probably that people ask for books from an author or books by title. So let's try to related this, me going to a shelve an bringing to my desk all the books from an author or all the editions for the same Title instead of all the ISBN numbers from 1020202020 to 1020202040, with the pre-fetch and the bufferpools.
And explain about how you could query your db2 catalogue to be sure that everything it's been reorged, because some shops have tools to schedule the house keeping, but if some of the include ... or exclude .. they work with are not correctly set, it can be the case that some reorgs are not running or are running empty JCL's. I have had this problems.
If you are not very good with SQL or you just prefer it, you can play with the IBM DSNACCOX Store Procedure, and it will recommend you what to do, and not only for Reorg.
Also would like to talk about the other possibilities that it offers, as deleting data with the REORG ... DISCARDS ..., delete empty partitions with DROP_PART, REBALANCE, ... also that it's need to materialize pending changes or to encrypt/decrypt data.
And last but not least, the index reorg, this is a thing I have recently "discovered", because the house keeping that I had at my previous position, was always running at tablespace level, and sometimes just with reorging one or x indexes it's enough.
 
Speakers
avatar for Sole Martinez

Sole Martinez

Db2 for zOS System Programmer and DBA, Volkswagen Group Services
I am a pure IBM technology girl, started as AS/400 developer in Cobol and RPG, and at some point move to zOS as Database Admin for Db2 and later to System Programmer. I am a DB2 lover, willing to learn and pasionate to teach if possible what I already know.    
Monday October 28, 2024 11:30 - 12:30 CET
1 | Breakout 8
  Technical Session

11:30 CET

E2 | Db2 Analytics Accelerator – User Experiences from Garanti BBVA
Monday October 28, 2024 11:30 - 12:30 CET
0 | Auditorium 3B
Join us for an insightful session at IDUG EMEA 2024, where we delve into real-world user experiences with Db2 Analytics Accelerator. In this session, we'll provide an in-depth exploration of Garanti BBVA's implementation of Db2 Analytics Accelerator & Integrated Synchronization, highlighting the challenges encountered, strategies employed, and the outcomes achieved. Learn how we seamlessly integrated IDAA with our existing Db2 for z/OS environment, unlocking unprecedented performance improvements and accelerating our analytical processes.
Speakers, Tugce from Garanti BBVA & Cuneyt from IBM Germany R&D Lab, will guide you through a comprehensive exploration of the following objectives.
By attending this break-out session, participants will gain technical experiences of IDAA and Integrated Synchronization operation from the user perspective.
Speakers
avatar for Tugce Cignakli

Tugce Cignakli

Db2 DBA, Garanti BBVA Teknoloji
Tugce is an accomplished DB2 Database Administrator with over 9 years of experience in the field. Based in Garanti BBVA Teknoloji, she has honed her skills and expertise through years of hands-on experience and dedication to mastering her craft. As a seasoned professional in the world... Read More →
Monday October 28, 2024 11:30 - 12:30 CET
0 | Auditorium 3B
  Technical Session

11:30 CET

F2 | From the Statement Cache with Love
Monday October 28, 2024 11:30 - 12:30 CET
1 | Breakout 3 + 4
In today's modern applications, workload is increasingly shifting from traditional CICS or IMS transactions to Java workload. As a result, analyzing dynamic queries has become more important than ever before. 
In this presentation, I will demonstrate how to systematically analyze dynamic queries using the Global Dynamic Statement Cache, and how to identify queries that require immediate attention. We will develop a tool that allows SQL developers to analyze dynamic queries in their shop from day one after the conference. This tool is designed to be easily accessible and user-friendly, without requiring access to the mainframe. With it, developers can answer typical questions such as "Which queries performed better or worse within the last 30 days?", "Which of my queries were running at a given time and how did they perform?", and "Which of my queries are getting slower over time?" in a self-service mode. Additionally, we will explore how to translate query tuning results to cash savings, demonstrating the financial benefits of query optimization. By the end of this presentation, you will have a clear understanding of how to uncover and monetize hidden insights by analyzing the Global Dynamic Statement Cache.
Speakers
avatar for Thomas Baumann

Thomas Baumann

Data Evangelist, Swiss Mobiliar
Computer scientist by training, data scientist by practice, query tuner by spirit. Thomas is a fast learner with lots of curiosity, passionate about investigating mechanisms, causes and outcomes. Currently, his position is Data Evangelist at Swiss Mobiliar in Berne, Switzerland. When... Read More →
Monday October 28, 2024 11:30 - 12:30 CET
1 | Breakout 3 + 4
  Technical Session

12:30 CET

Lunch
Monday October 28, 2024 12:30 - 14:00 CET
TBA
Monday October 28, 2024 12:30 - 14:00 CET
TBA
  Lunch

14:00 CET

A3 | Db2 13 Features in Tandem with UBS Workloads
Monday October 28, 2024 14:00 - 15:00 CET
0 | Auditorium 2
Db2 13 for z/OS GA and CD offer many features useful for both application developers and database administrators. Some of the new functionalities include concurrency handling between application threads, controlling resource utilization duration to optimize for successful database object’s online schema change, and reducing the possibility of transaction failure after an online schema change. They are all useful enhancements which have been adopted by several Db2 users. Come and learn details of these features and why they are important to UBS during both the sponsor user process and after migration.
Speakers
BN

Bjarne Nelson

Db2 Lead Architect, UBS Business Solutions AG
Bjarne Nelson joined the Board in 2007 after 15 years serving in various capacities with IDUG including IDUG Asia-Pacific Conference Speaker, IDUG European Conference Speaker, IDUG North America Conference Speaker, IDUG European Conference Planning Committee Member, IDUG European... Read More →
Monday October 28, 2024 14:00 - 15:00 CET
0 | Auditorium 2
  Technical Session, IDUG EMEA VIRTUAL SESSION

14:00 CET

B3 | Db2 12.1: Review key enhancements for Db2U in modernizing Db2 containerization footprint.
Monday October 28, 2024 14:00 - 15:00 CET
0 | Auditorium 3A
Join us to hear the latest and greatest enhancements, associated with Db2 V12.1 - the first new version of Db2 in 5 years - as we drill down on what the Db2 Universal Container (Db2U) has to offer.  Topics will include ready to be deployed to OpenShift,  Kubernetes or Cloud Pak for Data.  This will include AWS/IBM Cloud (SaaS or Self managed), AKS, EKS, ARO, ROSA, SMP/MPP deployments for transactional or analytical workloads.
Speakers
avatar for Vijaya Katikireddy

Vijaya Katikireddy

Product Manager, Db2 & Db2 Tools, IBM
Monday October 28, 2024 14:00 - 15:00 CET
0 | Auditorium 3A
  Technical Session, IDUG EMEA VIRTUAL SESSION

14:00 CET

C3 | Evolution of Database Infrastructure: Performance & Monitoring aspects when Migrating a Legacy COBOL Application in Banking from Db2 z/OS to Db2 LUW
Monday October 28, 2024 14:00 - 15:00 CET
1 | Breakout 1 + 2
This presentation deals with the complicated migration of a decades-old COBOL application from an IBM mainframe with focus on migration journey from Db2 for z/OS to a distributed environment with Db2 LUW on Power Linux. With almost 12 million customers, the Polish banking institution faced the challenge of adapting to a new DBMS while transitioning to the distributed infrastructure. The focus lies on database layer monitoring, encompassing high-level performance monitoring and hardware capacity planning for the distributed architecture. Extensive testing and benchmarking, crucial for mitigating the inherent risks of migrating a 30TB+ database, are highlighted. Through this migration story, participants gain insights into complex, multi-level database monitoring and benchmarking, comparing DB2 Z/OS with DB2 LUW to assess needs for the new distributed environment. The second part shifts focus to theoretical aspects of complex DB2 monitoring, exploring the architecture behind state-of-the-art monitoring systems and strategies for implementation at scale to derive valuable insights. This presentation offers a blend of practical experiences and theoretical concepts, providing attendees with actionable knowledge for navigating similar database migration and monitoring challenges.
Speakers
avatar for Jakub Rosiak

Jakub Rosiak

Database & System Administrator, PKO Bank Polski
DBA & sysadmin at PKO Bank Polski. Working with DB2 on Z/OS in mainframe environment as well as and DB2 LUW on a distributed Linux platform, mostly in maintenance and performance monitoring areas. Academic teacher at Polish-Japanese Academy of Informational Technologies in Warsaw... Read More →
Monday October 28, 2024 14:00 - 15:00 CET
1 | Breakout 1 + 2
  Technical Session

14:00 CET

D3 | My first year on the mainframe as a Db2 database administrator
Monday October 28, 2024 14:00 - 15:00 CET
1 | Breakout 8
By the time that the IDUG 2024 EMEA Db2 Tech Conference will take place, I (a 23 year old) will have been submersed in the world of the mainframe for about a year and a half. My journey, that’s still very much in its early stages, started in September 2022 when I chose “Mainframe expert” as my area of specialization during my studies applied computer science at University of Applied Sciences HOGENT (Ghent, Belgium). During those studies, me and my fellow mainframe students got introduced to the world of the mainframe and what would prove to be our future employers. I’ve started working in July 2023 as an engineer in the Db2 mainframe team at Belfius, a Belgian bank and insurer, where I did my internship. Proving once and for all that learning on the job is the best method for developing skills that are actually useful for both yourself and your employer.
The presentation will be structured into three sections. The first segment will delve into strategies for addressing a company's deficit in mainframe skills. This will primarily involve an exploration of the approach recommended by HOGENT and its partnering companies. It's important to note that the current situation in Belgium may not directly apply to other countries, especially those lacking a university offering a mainframe program. Nevertheless, I firmly believe that accepting interns from other IT fields can yield comparable results. Furthermore, I intend to present the outcomes of the mainframe internship at Belfius and share the company's perspective on the experience. This will also include a candid discussion of the challenges encountered during the internship and our proposed solutions for future interns. Lastly, I will discuss the skills I developed during my inaugural year at Belfius as a member of the Db2 mainframe team. Since I entered this role without prior database administration experience, I essentially began from scratch. This section will offer insights into my year long journey and the on the-job training I received
Speakers
avatar for Nathan Degryse

Nathan Degryse

Database Administrator, Belfius
Hi! I'm Nathan. A 23 year old mainframe database administrator. I studied applied computer science at University college of Ghent (HOGENT) . I specialized in system- and network administration and I also graduated in the the micro-degree “Mainframe expert” thought by IBM champion... Read More →
Monday October 28, 2024 14:00 - 15:00 CET
1 | Breakout 8
  Technical Session

14:00 CET

E3 | Back to the Future with PBGs
Monday October 28, 2024 14:00 - 15:00 CET
0 | Auditorium 3B
We’ll explore the journey from the inception of Partition by Growth (PBG) tablespaces, through converting to them from deprecated tablespace types and the exciting enhancements made in Db2 12 to fan out multi-table tablespaces to PBG. Db2 13 now provides a robust online mechanism to convert PBG tablespaces to Partition by Range (PBR) tablespaces which is useful for PBGs which have grown to an unmanageable dimension. We’ll have a sneak peek at the future enhancements which will make management of PBGs and PBRs more straightforward still.
Speakers
avatar for Julia Carter

Julia Carter

Db2 Technical Consultant, Broadcom
Julia Carter has 19 years' experience with Db2 and is a Db2 Consultant at Broadcom in Europe. Previously she has worked as a Database Administrator for banks in UK and Mexico.She is a member of the IDUG Content Committee and the GSE UK Db2 committee. Julia is co-host of the IDUG Table... Read More →
Monday October 28, 2024 14:00 - 15:00 CET
0 | Auditorium 3B
  Technical Session, IDUG EMEA VIRTUAL SESSION

14:00 CET

F3 | Messing with JSON data – how to consume and publish JSON data using Db2
Monday October 28, 2024 14:00 - 15:00 CET
1 | Breakout 3 + 4
JavaScript Object Notation (JSON) is an open standard data interchange format that has been around since the early 2000s but is gaining more traction all the time. 
Data is available from a variety of sources and customers want to be able to consume and publish it without having to involve extra resources; software or staff.
As such, it behoves us in the database community to ensure that we can store, process  and display the data.
This presentation will demonstrate how to accomplish that requirement.
Speakers
avatar for Mark Gillis

Mark Gillis

Principal Consultant, Triton Consulting
I am a Principal Consultant with Triton Consulting, based in the UK. I have been working in IT for over 35 years, and as a DB2 DBA for 30. I have worked on DB2 installations ranging from single user local Windows based systems to 100+ TB DB2 Warehouses.  I have also been involved... Read More →
Monday October 28, 2024 14:00 - 15:00 CET
1 | Breakout 3 + 4
  Technical Session

14:00 CET

LUW Badging
Monday October 28, 2024 14:00 - 15:30 CET
1 | Multi 1C
All onsite attendees at IDUG EMEA 2024 are eligible to receive a complimentary LUW badging exam with their paid registration. To register for an exam:
  1. Send an email to badges@idug.org and provide the following information:

    First & Last Name
    Email Address
    Exam Choice
    Day & Time Choice

  2. Select the exam you'd like to take. There are 5 exam choices:

    Db2 11.5 Foundations Exam
    Db2 11.5 Administration Exam
    Db2 11.5 Advanced Database Resilience Exam
    Db2 11.5 Advanced Database Design & Application  
    Development Exam
    Db2 11.5 Advanced Tuning & Debugging Exam
  3. Let us know what time you'll arrive to take the exam. Here are the day/time choices:
Monday:  2:00 PM, 4:00 PM
Tuesday:  10:30 AM, 2:00 PM, 4:00 PM
Wednesday:  10:30 AM, 2:00 PM, 4:00 PM
Thursday:  10:30 AM
 
Please Note:  No walk-ins will be accepted.  You must book in advance and you will receive a confirmation once you are officially booked.  This is a Bring Your Own Device exam.  Photo ID will be required at exam time.
Monday October 28, 2024 14:00 - 15:30 CET
1 | Multi 1C
  Badging & Certification

15:00 CET

Coffee Break
Monday October 28, 2024 15:00 - 15:20 CET
TBA
Monday October 28, 2024 15:00 - 15:20 CET
TBA
  Coffee Break

15:20 CET

A4 | Taking SQL Functions To the Next Level
Monday October 28, 2024 15:20 - 16:20 CET
0 | Auditorium 2
SQL Functions have long enabled customers to improve productivity and performance while also enabling cross platform porting, and encapsulating application logic in the database. Db2 for z/OS supports Built-in Functions that Aggregate data, operate on scalar data, as well as materialize data as a table. Db2 also enables customers to create functions in Host languages (such as COBOL or C/C++) or in SQL PL (The ANSI compatible SQL Procedures Language).
In the latest version of Db2, SQL Data Insights was introduced to allow easy, function based AI, to be applied directly to customer data.
This session will cover the basics and dig deeper into how to exploit all the Function(al) capabilities of Db2 to take your SQL queries to new levels.
Speakers
avatar for Chris Crone

Chris Crone

Distinguished Engineer - Database Technologies, Broadcom
Chris Crone has extensive experience working with Db2 and IBM z Systems. He brings over 30 years of work with the Db2 for z/OS development team. He’s worked extensively with customers on new development projects, prioritizing requirements, and fighting fires.
Monday October 28, 2024 15:20 - 16:20 CET
0 | Auditorium 2
  Technical Session

15:20 CET

B4 | V12: New Security Features and Changes
Monday October 28, 2024 15:20 - 16:20 CET
0 | Auditorium 3A
Db2 V12 has a plethora of changes in the area of security and this session will highlight everything new and changed.  This includes features such as enhancements to trusted context, tablespace administration, fenced stored procedure lockdown, and minor authentication improvements.   A focus has been made on cleaning up less than secure defaults and features.  These have direct impact to many daily operations, be sure to attend to learn about all of these changes.
Speakers
avatar for Greg Stager

Greg Stager

Db2 LUW Security Architect, IBM Canada
Greg Stager is the security architect for Db2 LUW at the IBM Toronto Lab. Greg has been a member of the Db2 security development team since 2000, where he has worked on all aspects of security within Db2, including authentication, authorization, auditing and encryption.
Monday October 28, 2024 15:20 - 16:20 CET
0 | Auditorium 3A
  Technical Session

15:20 CET

C4 | What can I do with Db2 profile tables?
Monday October 28, 2024 15:20 - 16:20 CET
1 | Breakout 1 + 2
Did you know that you can control and manage an individual application or a class of applications without having to change the application source codes and without having to make changes that affect the whole subsystem? From having the targeted applications executing with specific special registers, global variables, with the characteristic to qualify for IDAA offload, to monitoring remote threads and connections, you can have such controls by using the profile tables. You can also customize certain subsystem parameters to model a production environment on the test system to observe your query workload before promoting. Come to hear all about what you can do for particular contexts using the Db2 for z/OS profile tables.

Speakers
avatar for Tammie Dang

Tammie Dang

Senior Software Engineer, IBM
Tammie Dang is a senior engineer in Db2 for z/OS Development focusing in the Application Management, SQL API and performance areas. She has been the architect and product owner for many key epic enhancements in Db2 13 for z/OS and Continuous Delivery. Tammie is currently leading a... Read More →
Monday October 28, 2024 15:20 - 16:20 CET
1 | Breakout 1 + 2
  Technical Session

15:20 CET

D4 | Temporal Tables in a Nutshell
Monday October 28, 2024 15:20 - 16:20 CET
1 | Breakout 8
The concept of temporal tables is a precious rare gem provided by IBM Db2 which has gone unnoticed.The intent of this abtract would be to reinstate the essence of the temporal concepts and its purpose, by elaborating on the different types of temporal tables offered along with appropriate use cases.Tips and tricks about where the temporal concept can be applied and how to overcome the time sync issue will be discussed.
Speakers
avatar for Cola Deepa Krishnanath

Cola Deepa Krishnanath

DBA, SEB
About 20 years of IT experience encompassing a wide range of skill set, roles and industryverticals.  Extensive experience with analysis, design, development, customizations and implementation of softwareapplications. Proficient in analyzing and translating business requirements... Read More →
Monday October 28, 2024 15:20 - 16:20 CET
1 | Breakout 8
  Technical Session

15:20 CET

E4 | The art of database design
Monday October 28, 2024 15:20 - 16:20 CET
0 | Auditorium 3B
Db2 OLTP and warehouse databases becomes larger and larger, and multi terra byte databases are common nowadays.
Therefore, is a good database design is essentially important – because it can influence the future of companies and government organizations, positively or negatively.
But what is a good database design and how do you develop it?
Designing a relational database is the process of creating a logical representation of either a complete database or objects like schemas, tables and so on.
The visual representation illustrates the database objects/entities, their attributes, data types etc. and describes the relationships between these entities, and the ways the data can be grouped and organized.
Database models address business needs and business rules. The design process can be very challenging because many aspects need to be considered. In addition, various stakeholders need to be involved.
In this session, I will talk about different design techniques and the most important aspects for a good database design.
Because this is essential for data quality, integrity, security, performance and scalability.
Speakers
avatar for Olaf Stephan

Olaf Stephan

IT Database Architect, BaFin
Olaf Stephan work as the Chief IT Database Architect for the Bundesanstalt für Finanzdienstleistungsaufsicht, BaFin (Federal Financial Supervisory Authority) in Frankfurt a.M. Germany.His area of expertise is database design, enterprise architecture, performance, information integration... Read More →
Monday October 28, 2024 15:20 - 16:20 CET
0 | Auditorium 3B
  Technical Session

15:20 CET

F4 | Tuning SQL Stored Procedures (LUW Edition)
Monday October 28, 2024 15:20 - 16:20 CET
1 | Breakout 3 + 4
SQL stored procedures are a very common method of delivering Db2 functionality to applications.  But when they need performance tuning how do you achieve this.   In this presentation we will explore the components behind SQL stored procedures and how to tune the individual elements.
Speakers
avatar for Philip Nelson

Philip Nelson

Senior Database Software Engineer, Lloyds Banking Group / ScotDB Limited
Philip Nelson has worked with Db2 for z/OS since 1989 and with Db2 (LUW) since the beginning.   He presents on a variety of Db2 topics at conferences, but particularly focusing on exploiting new functionality and encouraging application developer interaction.   He has been an... Read More →
Monday October 28, 2024 15:20 - 16:20 CET
1 | Breakout 3 + 4
  Technical Session

16:00 CET

LUW Badging
Monday October 28, 2024 16:00 - 17:30 CET
1 | Multi 1C
All onsite attendees at IDUG EMEA 2024 are eligible to receive a complimentary LUW badging exam with their paid registration. To register for an exam:
  1. Send an email to badges@idug.org and provide the following information:

    First & Last Name
    Email Address
    Exam Choice
    Day & Time Choice

  2. Select the exam you'd like to take. There are 5 exam choices:

    Db2 11.5 Foundations Exam
    Db2 11.5 Administration Exam
    Db2 11.5 Advanced Database Resilience Exam
    Db2 11.5 Advanced Database Design & Application  
    Development Exam
    Db2 11.5 Advanced Tuning & Debugging Exam
  3. Let us know what time you'll arrive to take the exam. Here are the day/time choices:
Monday:  2:00 PM, 4:00 PM
Tuesday:  10:30 AM, 2:00 PM, 4:00 PM
Wednesday:  10:30 AM, 2:00 PM, 4:00 PM
Thursday:  10:30 AM
 
Please Note:  No walk-ins will be accepted.  You must book in advance and you will receive a confirmation once you are officially booked.  This is a Bring Your Own Device exam.  Photo ID will be required at exam time.
Monday October 28, 2024 16:00 - 17:30 CET
1 | Multi 1C
  Badging & Certification

16:20 CET

Break
Monday October 28, 2024 16:20 - 16:30 CET
TBA
Monday October 28, 2024 16:20 - 16:30 CET
TBA
  Break

16:30 CET

A5 | Automate Db2 database changes into a DevOps pipeline
Monday October 28, 2024 16:30 - 17:30 CET
0 | Auditorium 2
We will illustrate how in an agile cloud native environment, applications developers can easily use the self-service facilities to make changes, test, commit, push, automate deployment with automated CI/CD pipeline. Such changes can only be done within pre-established rules set by DBA and other administrators.This presentation will show the steps a developer would take to modify an application including database changes and additional objects. A central part of the presentation will be a demo of DevOps facilities.
We will illustrate how in an agile cloud native environment, applications developers can easily use the self-service facilities to make changes, test, commit, push, automate deployment with automated CI/CD pipeline. Such changes can only be done within pre-established rules set by DBA and other administrators
Speakers
avatar for Sowmya Kameswaran

Sowmya Kameswaran

Technical Leader, IBM
I lead the modernization portfolio for IBM Db2 product line. My charter encompasses product design & development, vendor & customer relationship, external & internal product communication. As part of my leadership role, I mentor and manage full-stack software developers. I am responsible... Read More →
Monday October 28, 2024 16:30 - 17:30 CET
0 | Auditorium 2
  Technical Session

16:30 CET

B5 | Db2 12: Amazon RDS for Db2 latest news and tips and tricks
Monday October 28, 2024 16:30 - 17:30 CET
0 | Auditorium 3A
Db2 12 on Amazon RDS for Db2 will be discussed along with a set of tips and tricks on getting the most of Db2 running in AWS.
Speakers
avatar for Andrew Hilden

Andrew Hilden

Chief Architect Db2 on Cloud, RDS for Db2, IBM
Monday October 28, 2024 16:30 - 17:30 CET
0 | Auditorium 3A
  Technical Session

16:30 CET

C5 | Adaptive Workload Management: Latest Best Practices for Managing your Database
Monday October 28, 2024 16:30 - 17:30 CET
1 | Breakout 1 + 2
Db2’s Adaptive Workload Management technology vastly simplifies the task of dividing your database resources across workloads to ensure they meet their performance objectives. Unlike traditional workload managers it manages the admission of jobs based on their actual resource needs and intelligently schedules them based on the resource targets you assign, ensuring stable and reliable performance even in the face of the most highly concurrent workloads. Join David Kalmuk, the architect of the Adaptive Workload Manager, for an update on new enhancements in the latest release and best practices that will allow you to get the most out of this technology.
Speakers
avatar for David Kalmuk

David Kalmuk

Distinguished Engineer, Analytical Databases, IBM
David Kalmuk is a Distinguished Engineer & Master Inventor and Chief Architect for Analytical Databases at IBM. David has contributed to the development of numerous technologies in Db2 over the years including BLU Acceleration, Workload Management, Monitoring, as well as much of Db2’s... Read More →
Monday October 28, 2024 16:30 - 17:30 CET
1 | Breakout 1 + 2
  Technical Session

16:30 CET

D5 | Homebrew real-time monitoring with the Db2 Instrumentation Facility Interface.
Monday October 28, 2024 16:30 - 17:30 CET
1 | Breakout 8
Monitors for Db2 for z/OS use the Db2 Instrumentation Interface Facility to collect metrics. The Instrumentation Facility Interface is available to users as well. In this presentation you'll see how you can write your own programs to use this interface to gather metrics about your Db2 subsystems and workloads in real-time, and how we used them to solve problems we faced.
Speakers
JC

Jan Cannaerts

Systems Analyst
Jan has worked on the IBM Mainframe platform for the past 10 years, interlacing stretches of time of working solely with Db2 for z/OS with hardware, storage, and z/OS management.
Monday October 28, 2024 16:30 - 17:30 CET
1 | Breakout 8
  Technical Session

16:30 CET

E5 | Db2 Analytics Accelerator Experiences of ZABA from PoC to Production
Monday October 28, 2024 16:30 - 17:30 CET
0 | Auditorium 3B
Zagrebačka banka has been using Db2 Analytics Accelerator from 2017 and have recently migrated from V5 to V7. Prior to migration we did proof-of-concept with IBM support. This presentation will cover our experiences from PoC and production migration including our use cases, IDAA on Z configuration and installation, HA/DR considerations, workload migration and implementation of Integrated Synchronization.
Speakers
avatar for Maja Adam

Maja Adam

Lead Operating Systems Specialist, Zagrebačka banka d.d.
Maja Adam is Lead Operating Systems Specialist in Zagrebačka banka, Croatian bank which is member of Unicredit. She has been working with IBM Db2 for z/OS for over 20 years - first as application DBA and lately as Db2 system administrator. She holds Bachelor's degree in Computer... Read More →
Monday October 28, 2024 16:30 - 17:30 CET
0 | Auditorium 3B
  Technical Session

16:30 CET

F5 | Db2 Attachment Facilities for Beginners to Experts
Monday October 28, 2024 16:30 - 17:30 CET
1 | Breakout 3 + 4
Db2 Attachment Facilities are really important because they allow application programs to interact with Db2 for z/OS.  There are many types of facilities, so how do you know which one to use?  In this presentation we will investigate the most common attachment facilities (e.g., TSO, CAF, RRSAF).  We will discuss how and when to use them. In addition, we will cover some advanced topics such as security implications, thread reuse, and connection switching, all of which are factors to consider when deciding on an attachment facility.
Speakers
avatar for Emil Kotrc

Emil Kotrc

Software Architect, Broadcom
Emil is a software architect at Broadcom Mainframe Software, he holds a Ph.D. in Mathematical Engineering, is a member of the IDUG Content Committee, and an IBM Champion since 2015.
Monday October 28, 2024 16:30 - 17:30 CET
1 | Breakout 3 + 4
  Technical Session

17:30 CET

Solution Center Grand Opening & IDUG Welcome Reception
Monday October 28, 2024 17:30 - 19:00 CET
2 | Multipurpose Room / Solution Center
Monday October 28, 2024 17:30 - 19:00 CET
2 | Multipurpose Room / Solution Center
  Solution Center
 
Tuesday, October 29
 

TBA

z/OS Certification
Tuesday October 29, 2024 TBA
All onsite attendees at IDUG EMEA 2024 are eligible to receive a complimentary z/OS certification exam with their paid registration. If you have indicated z/OS as your primary platform in your registration form, you will be receiving an e-mail containing a voucher number and instructions before November 30. Questions? e-mail idug@idug.org.
Tuesday October 29, 2024 TBA
  Badging & Certification

09:00 CET

Keynote | Modernizing with the Winning Formula
Tuesday October 29, 2024 09:00 - 10:00 CET
0 | Auditorium 2
Behind every successful race is a strong pit crew. Crew members ensure the race car is balanced, operating temperature is set, and all features are enabled for maximum torque. In the world of Db2, the “pit crew” includes Database Administrators, System Engineers, and Application Developers—all working together to support overall business goals in a 24x7 economy. Join us for a test drive with the Db2 pit crew to find a formula for success in the race toward modernizing the mainframe experience.
Speakers
avatar for David Stokes

David Stokes

Senior Director, Engineering & Agile Program Management, Mainframe Software, Broadcom, Broadcom
With more than 20 years’ experience in enterprise software and sales, David has a broad and deep understanding of the mainframe market and ecosystem. He comprehends how products work in real-world environments and how they interact with other technologies.
avatar for Julia Carter

Julia Carter

Db2 Technical Consultant, Broadcom
Julia Carter has 19 years' experience with Db2 and is a Db2 Consultant at Broadcom in Europe. Previously she has worked as a Database Administrator for banks in UK and Mexico.She is a member of the IDUG Content Committee and the GSE UK Db2 committee. Julia is co-host of the IDUG Table... Read More →
avatar for Jim Endler

Jim Endler

Senior Principal Consultant, Technical Consulting, Broadcom
Broadcom Sr. Principal Consultant, Technical Consulting. Provide solution support for Broadcom Db2 Database Aministration, Backup and Recovery, and Performance soutions. Maintain an ongoing customer relationship to ensure Broadcom Db2 Management Solutions are fully exploited to support... Read More →
avatar for Toine Michielse

Toine Michielse

Solutions Architect, Broadcom
I have been working with Db2 for z/OS ever since V1. In my career I have worked as COBOL/IMS/DB2 programmer, IMS/DB2 DBA and DB2 system engineer. I have worked a number of years as a Db2 Lab advocate, supporting IBM customers worldwide. Before joining Broadcom I worked at SwissRe... Read More →
Tuesday October 29, 2024 09:00 - 10:00 CET
0 | Auditorium 2
  Keynote, IDUG EMEA VIRTUAL SESSION

10:00 CET

Coffee Break
Tuesday October 29, 2024 10:00 - 10:20 CET
TBA
Tuesday October 29, 2024 10:00 - 10:20 CET
TBA
  Coffee Break

10:20 CET

A6 | JC War Stories, Greatest Hits and Best Practices 2024 – Part 1
Tuesday October 29, 2024 10:20 - 11:20 CET
0 | Auditorium 2
This two part technical session that to provide benefit in terms of: learning recommended best practice; learning from the good, bad and ugly experiences from other installations; provide answers to important, frequent or difficult questions. The following topics will be covered: Online delete of active log dataset, Online migration from PBG UTS to PBR UTS table spaces, ALTER TABLE DATA CAPTURE concurrency enhancement, User controls to improve the ability for SQL DDL operations to succeed and/or reduce application service, what they did not tell you about DDF sysplex workload balancing, DDF system parameters MAXCONQN and MAXCONQW, WLM and DDF High Performance DBATs,Enhancements to Fast Traversal Block feature, Considerations using Contiguous Buffer Pool, Use of large index page size, Changes in behaviour after migrating to UTS, War story about insert processing with MEMBER CLUSTER, Considerations when collecting column frequency statistics, Increase in false lock contention when using data sharing.
Speakers
avatar for John Campbell

John Campbell

Senior Consultant, Triton Consulting
John Campbell is a senior consultant at Triton Consulting, an IBM Alumni, retired Distinguished Engineer in IBM Db2 for z/OS Development. He has worked with Db2 for z/OS for over 40 years and has extensive experience with Db2 in terms of systems, database and application design. He... Read More →
Tuesday October 29, 2024 10:20 - 11:20 CET
0 | Auditorium 2
  Technical Session, IDUG EMEA VIRTUAL SESSION

10:20 CET

B6 | Db2 Availability & Recovery: Get Ready For What's Next
Tuesday October 29, 2024 10:20 - 11:20 CET
0 | Auditorium 3A
In the ever-evolving landscape of database management, ensuring the availability and swift recovery of critical data has become paramount. This presentation dives into the latest enhancements and changes upcoming in availability and recovery with Db2’s Next Release to help you get the most out of your investment and defend against potential disruptions.
Speakers
avatar for Michael Roecken

Michael Roecken

Senior Software Developer, IBM Canada Ltd.
Michael Roecken is a senior software developer with Db2 for Linux, UNIX, and Windows platforms at the IBM Toronto Lab.  Michael has worked since 2000 designing, implementing and supporting various features and capabilities in the areas of: backup/restore, crash/rollforward recovery... Read More →
Tuesday October 29, 2024 10:20 - 11:20 CET
0 | Auditorium 3A
  Technical Session, IDUG EMEA VIRTUAL SESSION

10:20 CET

C6 | The Transition of Db2 Automated HA from TSA to Pacemaker on Linux - The Final Act
Tuesday October 29, 2024 10:20 - 11:20 CET
1 | Breakout 1 + 2
Alas! We are in the Final Act of the transition from TSA to Pacemaker on Linux! This finale is a culmination of 4+ years of intense development kicked off with a technical preview of 2-node HADR in v11.5.4.0 as the Prologue, followed by Act 1 with the official GA five months later in v11.5.5.0. Act 2 boosted up & running story with integrated bundling of the Pacemaker stack in v11.5.6.0. Act 3 covered v11.5.7.0 and v11.5.8.0 where the automation on cloud was introduced as well as the debut of the second HA configuration - Mutual Failover with shared disk. This session serves as a refresher of HADR and Mutual Failover and an introduction to DPF and pureScale with Pacemaker. It covers the "WHY" it is time to switch to Pacemaker, the "WHAT" you should know before you switch, the "HOW" you can switch, the "WHAT IF" you do not switch, and "WHAT ELSE" is in the pipeline from Db2 High Availability Development.
Speakers
avatar for Toby Haynes

Toby Haynes

Senior Software Developer, IBM Canada
With a background in Observational Astronomy at the University of Cambridge, England, Toby joined IBM Canada in 1999 as a software developer in the Db2 Runtime engine. After eight years of development experience, he moved over to the Db2 Performance team to start work on what would... Read More →
Tuesday October 29, 2024 10:20 - 11:20 CET
1 | Breakout 1 + 2
  Technical Session

10:20 CET

D6 | Diamonds are Forever - Real-World SQL Data Insight Experiences
Tuesday October 29, 2024 10:20 - 11:20 CET
1 | Breakout 8
Join me on a journey through our first year of deploying SQL Data Insights (SDI) into production. Discover how SDI impacted our business processes, changed stakeholder perceptions of the mainframe, and enhanced our approach to data analysis.
We will start with a review of our first use case and discuss the resources consumed for training and scoring, as well as the impact SDI had on our business processes. 
SDI's most evident benefit is its ability to analyze data where it sits without having to export, transfer and reload it, and with minimal data science dependency. But how does it compare to more traditional approaches? To answer that, we'll compare SDI with other machine learning algorithms by applying them to a frequently used dataset for predicting diamond prices. We'll delve into the accuracy of the algorithms and see how SDI stacks up against data scientists' most loved algorithms.
Following that, we'll explore a brand-new use case that applies the new commonality-function in Db2 FL504. We'll discuss its usefulness, resource requirements, and potential impact on business processes, providing more practical insights into the power of SDI.
And finally, I'll share a use case that demonstrates how to identify outliers using SDI with Db2 monitoring data, ready to be applied in your own shop. 
Don't miss this opportunity to gain practical insights into the power of SDI and how it can transform your data analysis!
Speakers
avatar for Thomas Baumann

Thomas Baumann

Data Evangelist, Swiss Mobiliar
Computer scientist by training, data scientist by practice, query tuner by spirit. Thomas is a fast learner with lots of curiosity, passionate about investigating mechanisms, causes and outcomes. Currently, his position is Data Evangelist at Swiss Mobiliar in Berne, Switzerland. When... Read More →
Tuesday October 29, 2024 10:20 - 11:20 CET
1 | Breakout 8
  Technical Session

10:20 CET

E6 | HADR - How and where to start
Tuesday October 29, 2024 10:20 - 11:20 CET
0 | Auditorium 3B
This session is meant to be a HADR beginners session (101. back to basics, however you want to call it). Showing what HADR is, how it works in general and how you get it started. Additionally I'll explain the most common configuration parameters, their purpose and possible trip wires on the way to a running HA cluster.
This session will NOT cover any cluster autmation like TSA or Pacemaker.
Speakers
avatar for Sebastian Zok

Sebastian Zok

Senior Database Administrator, Cancom Managed Services GmbH
Sebastian got a diploma in IT in 2007 and started first in software development. He worked on Db2 performance monitoring and switched to Db2 consultancy shortly after. He is working with Db2 LUW since version 7. Currently Sebastian is working for an IT provider as Senior Db2 DBA administering... Read More →
Tuesday October 29, 2024 10:20 - 11:20 CET
0 | Auditorium 3B
  Technical Session, IDUG EMEA VIRTUAL SESSION

10:20 CET

F6 | A LOB for friend. Know me a little better
Tuesday October 29, 2024 10:20 - 11:20 CET
1 | Breakout 3 + 4
This is a back-to-basics session that will cover the fundamentals of Db2 Large Objects (LOBs), their structure, different LOB types, how they are implemented, considerations for daily management and how is possible to
Improve application performance transforming standard lobs to Inline Lobs.
 
Db2 LOBs enable you to store large amounts of data in a single column. The data can be structured in nature, but more often contain unstructured data such as images or audio data. LOB implementation requires auxiliary objects to be created, which increases the complexity of object administration, space utilization, and utility processing.
This session provides an overview of Db2 LOBs, things to watch out for, and tips for tuning and space allocation.
Speakers
avatar for Roberto Cason

Roberto Cason

Solution Engineer, BMC Software
About 30 year of DB2 for z/OS experience working with customers in Italy.                            Over then 25 years of experience as System programmer and DBA in an outsourcing company for Banks and Financial Institutes where he was responsible for the design, maintenance... Read More →
Tuesday October 29, 2024 10:20 - 11:20 CET
1 | Breakout 3 + 4
  Technical Session

10:30 CET

LUW Badging
Tuesday October 29, 2024 10:30 - 12:00 CET
1 | Multi 1C
All onsite attendees at IDUG EMEA 2024 are eligible to receive a complimentary LUW badging exam with their paid registration. To register for an exam:
  1. Send an email to badges@idug.org and provide the following information:

    First & Last Name
    Email Address
    Exam Choice
    Day & Time Choice

  2. Select the exam you'd like to take. There are 5 exam choices:

    Db2 11.5 Foundations Exam
    Db2 11.5 Administration Exam
    Db2 11.5 Advanced Database Resilience Exam
    Db2 11.5 Advanced Database Design & Application  
    Development Exam
    Db2 11.5 Advanced Tuning & Debugging Exam
  3. Let us know what time you'll arrive to take the exam. Here are the day/time choices:
Monday:  2:00 PM, 4:00 PM
Tuesday:  10:30 AM, 2:00 PM, 4:00 PM
Wednesday:  10:30 AM, 2:00 PM, 4:00 PM
Thursday:  10:30 AM
 
Please Note:  No walk-ins will be accepted.  You must book in advance and you will receive a confirmation once you are officially booked.  This is a Bring Your Own Device exam.  Photo ID will be required at exam time.
Tuesday October 29, 2024 10:30 - 12:00 CET
1 | Multi 1C
  Badging & Certification

11:20 CET

Break
Tuesday October 29, 2024 11:20 - 11:30 CET
TBA
Tuesday October 29, 2024 11:20 - 11:30 CET
TBA
  Break

11:30 CET

A7 | JC War Stories, Greatest Hits and Best Practices 2024 – Part 2
Tuesday October 29, 2024 11:30 - 12:30 CET
0 | Auditorium 2
This two part technical session that to provide benefit in terms of: learning recommended best practice; learning from the good, bad and ugly experiences from other installations; provide answers to important, frequent or difficult questions. The following topics will be covered: Online delete of active log dataset, Online migration from PBG UTS to PBR UTS table spaces, ALTER TABLE DATA CAPTURE concurrency enhancement, User controls to improve the ability for SQL DDL operations to succeed and/or reduce application service, what they did not tell you about DDF sysplex workload balancing, DDF system parameters MAXCONQN and MAXCONQW, WLM and DDF High Performance DBATs,Enhancements to Fast Traversal Block feature, Considerations using Contiguous Buffer Pool, Use of large index page size, Changes in behaviour after migrating to UTS, War story about insert processing with MEMBER CLUSTER, Considerations when collecting column frequency statistics, Increase in false lock contention when using data sharing.
Speakers
avatar for John Campbell

John Campbell

Senior Consultant, Triton Consulting
John Campbell is a senior consultant at Triton Consulting, an IBM Alumni, retired Distinguished Engineer in IBM Db2 for z/OS Development. He has worked with Db2 for z/OS for over 40 years and has extensive experience with Db2 in terms of systems, database and application design. He... Read More →
Tuesday October 29, 2024 11:30 - 12:30 CET
0 | Auditorium 2
  Technical Session

11:30 CET

B7 | V12 Db2 SQL Extensions: Tenant, Lakehouse and more
Tuesday October 29, 2024 11:30 - 12:30 CET
0 | Auditorium 3A
A look at the new SQL capabilites added to Db2 v12 as well as a look back at some of the lesser known additions in 11.1 and 11.5 mod packs.  A deep dive into new namespace isolation capabilities provided via the TENANT concept.  A look at how Db2 can integrate into a lakehouse strategy.
Speakers
avatar for Mike Springgay

Mike Springgay

Db2 Architect, IBM
Mike Springgay is the Db2 Architect. Prior to that he was responsible for architecting extensions to Db2’s Warehouse capabilities, SQL compatibility features, routine infrastructure and client server connectivity.
Tuesday October 29, 2024 11:30 - 12:30 CET
0 | Auditorium 3A
  Technical Session

11:30 CET

C7 | Unveiling the Power of Log Analysis
Tuesday October 29, 2024 11:30 - 12:30 CET
1 | Breakout 1 + 2
Join us in unraveling the mysteries of log analysis! In this session, we'll break down the basics of logs and their importance. Learn how to extract valuable data from logs and discover practical ways to use this information for troubleshooting and business insights. Don't miss out on this opportunity to unlock the power of log analysis.
Speakers
avatar for Aysen Svoboda

Aysen Svoboda

Product Owner, Broadcom
With over 15 years of hands-on experience in mainframe technology, I've worn various hats as a DBA and System Programmer across different countries and organizations. Now, as a Product Owner, I focus on delivering top-notch solutions tailored to the needs of mainframe professionals... Read More →
Tuesday October 29, 2024 11:30 - 12:30 CET
1 | Breakout 1 + 2
  Technical Session

11:30 CET

D7 | The Engineering Challenges Behind the Db2 AI Query Optimizer
Tuesday October 29, 2024 11:30 - 12:30 CET
1 | Breakout 8
The Db2 AI Query Optimizer builds, trains, and uses Deep Learning Neural Networks to provide advanced query optimization capabilities. Introducing deep learning safely onto production database management systems is a monumental task. Learn about the tremendous engineering challenges we confronted as we transitioned the Db2 ML Optimizer Tech Preview into a production-ready feature in v12. Some of the many challenges faced were how to deliver good machine learning model accuracy across a wide variety of use cases, how to minimize impact to existing workloads running on the database management system, and how to minimize machine learning model storage requirements. Knowing how the Db2 AI Query Optimizer was designed and how these engineering challenges were tackled will give you the confidence needed to try out this new feature on your own database systems.
Speakers
avatar for Liam Finnie

Liam Finnie

Senior Software Developer, IBM
Liam joined IBM in 1999 as a software developer, and has been working in various parts of Db2 LUW since. He has been involved in the design and implementation of the Db2 Self-Tuning Memory Manager, Db2 pureScale, and columnar engine storage enhancements. Most recently, he has been... Read More →
Tuesday October 29, 2024 11:30 - 12:30 CET
1 | Breakout 8
  Technical Session

11:30 CET

E7 | DB2 LUW PureScale – Custom Disaster Recovery configuration
Tuesday October 29, 2024 11:30 - 12:30 CET
0 | Auditorium 3B
IBM provides us number of solution to achieve multisite HA/DR for PureScale clusters. Those include technologies like HADR Replication for PureScale Clusters, Geographically Dispersed PureScale Clusters, GPFS replication for PureScale Clusters, Q Replication for PureScale Clusters.
In the presentation we will describe alternative approach, where replication across 2 sites is provided by Storage Array Layer, which allows us to achieve additional benefits like consistency groups going beyond single GPFS filesystem used by the PureScale, optimized network utilization where Storage Array replication happens on SAN Fiber, additional HA layer where filesystem can be cross mounted across sites which gives additional redundancy layer for storage availability.
 
We implement solution by deploying Synchronic Storage Replication across 2 sites, where SAN fabric provides us NSD multi path connections from each side. This way on each side we have collection of NSD disks that are local to given side, and also connection to remote NSD disks from DR side. On both sites we install standalone PureScale clusters, independent from each, therefore failure of any of those clusters does not impact other side counterpart. Having 2 clusters we designate one as primary by creating PureScale managed GPFS on top of Storage Array Layer, and on top of that create Database with its' associated paths. Next we use gpfssync capabilities to export primary GPFS filesystem , and next mount the same on DR site. This allows us to mimic primary cluster on DR site, and next attach those synchronized mount points to TSAMP cluster on secondary site. Later on, we just move application connection to DR site, which can handle further ongoing workloads.
 
Proposed solution is active-passive deployment, when at any given time only one cluster has connection to synchronized storage array. We achieve this by protections on each layer (NSD disks active on one site only, GPFS mounts online on one site only, database cataloging on one site only). This is crucial to ensure only one side has active writes to the cluster, so that we prevent any corruption of the data. In the presentation we provide procedures to setup such deployment, along with failover procedures where we move storage attachment from primary to secondary, and reverse. We also provide testing results where we verify solution, by forcing failover and more failure scenarios while processing application workload.
Speakers
avatar for Mateusz Książek

Mateusz Książek

Db2 Administrator, PKOBP
Technical Leader in mainframe modernization project - Cross platform monitoring design & performance analysis(mainframe/distributed) - Application migration to distributed env - Dr architecture for cross platform env - TroubleshootingDB2 system AdministratorDB2 performance monitoring... Read More →
Tuesday October 29, 2024 11:30 - 12:30 CET
0 | Auditorium 3B
  Technical Session

11:30 CET

F7 | Real Life Access Plan Tuning
Tuesday October 29, 2024 11:30 - 12:30 CET
1 | Breakout 3 + 4
Optimal access plans are critical for query performance, and it is the Db2 optimizer's job to choose the best one. The optimizer is very sophisticated and considers many factors while costing an access plan, but sometimes it makes mistakes, and you need to fix it quickly. This session will show you how to apply access plan tuning techniques based on queries from real Db2 customer systems. A variety of query types will be covered, including OLTP and analytics, running on single or multiple data base partitions. You will also learn how to use the explain facility to understand how access plans work. Attend this session to learn some techniques to address a variety of access plan problems and to gain some insight into query optimization.
Speakers
avatar for John Hornibrook

John Hornibrook

Senior Technical Staff Member, IBM Canada
John is a Senior Technical Staff Member responsible for relational database query optimization on IBM's distributed platforms. This technology is part of Db2 for Linux, UNIX and Windows, Db2 Warehouse, Db2 on Cloud, IBM Integrated Analytics System (IIAS), IBM Db2 Analytics Accelerator... Read More →
Tuesday October 29, 2024 11:30 - 12:30 CET
1 | Breakout 3 + 4
  Technical Session

12:30 CET

Lunch
Tuesday October 29, 2024 12:30 - 14:00 CET
TBA
Tuesday October 29, 2024 12:30 - 14:00 CET
TBA
  Lunch

14:00 CET

A8 | Bufferpool Tuning - The Next Generation
Tuesday October 29, 2024 14:00 - 15:00 CET
0 | Auditorium 2
Buffer Pool Tuning - The Next Generation, will review the method and possibilities of Bufferpool and Group Bufferpool tuning that now exist in a modern world. It will take the attendees through an explanation of what are Bufferpools and  Group Bufferpools and what are the thresholds that are fixed or those that you can set. Then the BP tuning process from gathering data to actioning recommendations and then comparing results using just commands or Excel or even a state-of-the-art and Zowe front end with HTML5 graphics to enable a truly modern experience [Some assembly required!]
Speakers
avatar for Roy Boxwell

Roy Boxwell

Senior Software Architect, Software Engineering GmbH
Roy Boxwell is an IBM Champion with more than 37 years of experience in MVS, OS/390, and z/OS environments – 36 of those in Db2. He specializes in installation, migration, and performance monitoring and tuning. Roy leads the SEG development team responsible for the real-time database... Read More →
Tuesday October 29, 2024 14:00 - 15:00 CET
0 | Auditorium 2
  Technical Session, IDUG EMEA VIRTUAL SESSION

14:00 CET

B8 | What's New for Data Warehousing in Db2 12.1
Tuesday October 29, 2024 14:00 - 15:00 CET
0 | Auditorium 3A
Learn about the new features and improvements for Data Warehousing in Db2 12.1
Speakers
avatar for David Kalmuk

David Kalmuk

Distinguished Engineer, Analytical Databases, IBM
David Kalmuk is a Distinguished Engineer & Master Inventor and Chief Architect for Analytical Databases at IBM. David has contributed to the development of numerous technologies in Db2 over the years including BLU Acceleration, Workload Management, Monitoring, as well as much of Db2’s... Read More →
Tuesday October 29, 2024 14:00 - 15:00 CET
0 | Auditorium 3A
  Technical Session, IDUG EMEA VIRTUAL SESSION

14:00 CET

C8 | Introduction to Db2 for z/OS Restart
Tuesday October 29, 2024 14:00 - 15:00 CET
1 | Breakout 1 + 2
It is all too easy to take Db2 restart for granted, but it is important to understand how Db2 restart works so you can plan for and practice restart when there are exception conditions such as LPAR failures, in-doubt units of recovery, or objects in a group buffer pool recovery pending state. Planning, practice and preparation will stand you in good stead when you have a real emergency and need to restore a business service as soon as possible and at the same time preserve data integrity.
Speakers
avatar for Gareth Copplestone-Jones

Gareth Copplestone-Jones

Principal Consultant, Triton Consulting Ltd
Gareth has over 35 years Db2 experience as a DBA, and Systems Programmer. He gained experience in the financial, transport, retail and manufacturing businesses before joining IBM in 2000,  and joined the Db2 for z/OS Development SWAT Team in 2006, under the leadership of John Campbell... Read More →
Tuesday October 29, 2024 14:00 - 15:00 CET
1 | Breakout 1 + 2
  Technical Session

14:00 CET

D8 | İsbank's Journey to Leverage AI to Improve Db2 System for Db2 for z/OS, Health and Optimize System and SQL Performance
Tuesday October 29, 2024 14:00 - 15:00 CET
1 | Breakout 8
In this session you will find Isbank's experience with Db2 AI for z/OS. It will cover all POC and production experiences for the tested features of Db2 AI for z/OS as well as details about implementation project. What ill be your benefits if you decide to use Db2 AI in your shop? What does Db2 AI offer in a system assessment, SQL optimization and distributed data control parts? What are the new features that we are looking forward to in new releases? You will find all the answers in this presentation.
Speakers
avatar for Onder Cagatay

Onder Cagatay

System and DB2 Administrator, ISBANK T.A.S
Onder is graduated from Galatasaray University from computer engineering. He has been working as DB2 Database Administrator since the year 2006 on Z platform and been actually working for İSBANK for the last 11 years as DBA and System Architect. He worked on data replication from... Read More →
Tuesday October 29, 2024 14:00 - 15:00 CET
1 | Breakout 8
  Technical Session

14:00 CET

E8 | Db2 across architectures and encodings - A new practical approach to migrating databases with minimal downtime
Tuesday October 29, 2024 14:00 - 15:00 CET
0 | Auditorium 3B
There are many migration scenarios in which common tools like Backup/Restore or LOAD cannot be used, whether because of compatibility issues, too much manual doing, or lack of downtime.
In this session, I will go into detail of a self-made tool, which on top of Q-Replication makes it possible to migrate almost any DB, regardless of size, complexity, endianness or encoding in an effortless manner with near-zero downtime
Speakers
avatar for Miguel Sanjurjo

Miguel Sanjurjo

Senior Database Specialist, BITMARCK Technik GmbH
While studying Computer Science and IT-Management, I started working at IBM and specialized on AIX-Administration and on the POWER-Architecture. Since 2013 I work at BITMARCK in Hamburg, where I made my first contact with Db2 LUW. Soon it became clear, that this is the field where... Read More →
Tuesday October 29, 2024 14:00 - 15:00 CET
0 | Auditorium 3B
  Technical Session, IDUG EMEA VIRTUAL SESSION

14:00 CET

F8 | Back-to-Basics: Navigating Db2 Claims, Drains, and Materializing DDL Changes
Tuesday October 29, 2024 14:00 - 15:00 CET
1 | Breakout 3 + 4
DBAs often face challenges with performance degradation caused by claims, drains, and materializing pending DDL changes. But overcoming these is crucial in maintaining peak database performance and consistency during high-load periods. Join us as we dive into the basics of this important Db2 REORG utility. Gain insights into how most effectively manage drains and materializing pending DDL changes, particularly during peak system activities. This session is designed for attendees of all levels. Whether you're just starting your journey with Db2 or looking for a refresher, join us as we discuss these fundamental components of effective database administration and optimization.
Speakers
LC

Louise Comeaux

Lead Product Developer, BMC Software
Louise Comeaux is a lead product developer with over 30 years of mainframe development experience, 23 of which are in Db2 z/OS.  She most recently presented at IDUG EMEA 2023 in Prague.  She mentors new team members in Db2 fundamentals.    
Tuesday October 29, 2024 14:00 - 15:00 CET
1 | Breakout 3 + 4
  Technical Session

14:00 CET

LUW Badging
Tuesday October 29, 2024 14:00 - 15:30 CET
1 | Multi 1C
All onsite attendees at IDUG EMEA 2024 are eligible to receive a complimentary LUW badging exam with their paid registration. To register for an exam:
  1. Send an email to badges@idug.org and provide the following information:

    First & Last Name
    Email Address
    Exam Choice
    Day & Time Choice

  2. Select the exam you'd like to take. There are 5 exam choices:

    Db2 11.5 Foundations Exam
    Db2 11.5 Administration Exam
    Db2 11.5 Advanced Database Resilience Exam
    Db2 11.5 Advanced Database Design & Application  
    Development Exam
    Db2 11.5 Advanced Tuning & Debugging Exam
  3. Let us know what time you'll arrive to take the exam. Here are the day/time choices:
Monday:  2:00 PM, 4:00 PM
Tuesday:  10:30 AM, 2:00 PM, 4:00 PM
Wednesday:  10:30 AM, 2:00 PM, 4:00 PM
Thursday:  10:30 AM
 
Please Note:  No walk-ins will be accepted.  You must book in advance and you will receive a confirmation once you are officially booked.  This is a Bring Your Own Device exam.  Photo ID will be required at exam time.
Tuesday October 29, 2024 14:00 - 15:30 CET
1 | Multi 1C
  Badging & Certification

15:00 CET

Coffee Break
Tuesday October 29, 2024 15:00 - 15:20 CET
TBA
Tuesday October 29, 2024 15:00 - 15:20 CET
TBA
  Coffee Break

15:20 CET

PSP1 | A Db2 for z/OS must-have, the Db2 Analytics Accelerator – What Can It Do For You Today and Tomorrow
Tuesday October 29, 2024 15:20 - 16:20 CET
0 | Auditorium 2
If you are a Db2 for z/OS user and have not considered the Db2 Analytics Accelerator this is a chance to learn more about how it can significantly reduce CPU consumption while contributing to performance and resource savings for online, batch, and ETL processes. If you are already an Accelerator user, this is a chance to hear about what’s new with the recent statement of direction for the next version of the Accelerator. A lot has happened since the original 7.5 version and the adoption of IBM Z and LinuxONE on-platform deployment.  
Speakers
ME
Tuesday October 29, 2024 15:20 - 16:20 CET
0 | Auditorium 2
  Partner-Sponsored Presentation

15:20 CET

PSP2 | Exploit REST APIs to Unlock More Value From Db2 for z/OS
Tuesday October 29, 2024 15:20 - 16:20 CET
0 | Auditorium 3A
For years, your teams have invested heavily in your DB2 environment and its associated tools. It is critical to ensure that your team’s productivity continues to thrive. Broadcom’s Database Management Data Service (DBM-DS) is the foundation for serving up REST APIs that allow you to derive more value from your Db2 tooling. Join us in this session to learn more about the architecture behind DBM-DS and how it extends capabilities that can support you on your modernization journey. Learn about the latest updates, including the Beta program for the interactive web interface, which exploits REST APIs to help you better manage Db2 subsystems. Discover how DBM-DS can be the foundation for serving up REST APIs that drive more value from Db2 Tools you are already using, such as integrating Db2 with your existing DevOps processes, and leveraging performance dashboards that alert you to potential problems in your Db2 subsystems.
Speakers: Chris Crone, Broadcom Distinguished Engineer
Speakers
avatar for Chris Crone

Chris Crone

Distinguished Engineer - Database Technologies, Broadcom
Chris Crone has extensive experience working with Db2 and IBM z Systems. He brings over 30 years of work with the Db2 for z/OS development team. He’s worked extensively with customers on new development projects, prioritizing requirements, and fighting fires.
Tuesday October 29, 2024 15:20 - 16:20 CET
0 | Auditorium 3A
  Partner-Sponsored Presentation

15:20 CET

PSP3 Next-Gen Z Db2 Tools: Enhancing DBA and Developer Collaboration with Efficiency and Automation
Tuesday October 29, 2024 15:20 - 16:20 CET
0 | Auditorium 3B
With a new wave of DBAs entering the field, bringing diverse expertise, the demand for collaborative and intuitive management tools has never been higher. As Db2 application management evolves, traditional mainframe terminals are being replaced by modern tools for the Db2 professional. Discover how modern UIs and dashboards simplify Db2 data retrieval and manipulation, enhancing performance and efficiency. Explore streamlined database maintenance through real-time decision-making, providing greater agility. Experience mainframe-inclusive DevOps toolchains supporting agile development, testing, and delivery. These tools ensure 24x7 availability, resiliency, and a seamless customer experience. Leave this session equipped to enhance efficiency, automate processes, and adapt quickly to changes in Db2 environments.
Speakers
avatar for Michael Cotignola

Michael Cotignola

BMC Db2 Solutions Engineer, BMC Software
Michael Cotignola is a Principal Software Consultant supporting BMC's DB2 Mainframe Solutions.  In this role, he helps his clients maximize the value they receive from BMC's DB2 products.  Michael has worked in IT since 1975 in numerous IT disciplines, including operations, application... Read More →
NO
Tuesday October 29, 2024 15:20 - 16:20 CET
0 | Auditorium 3B
  Partner-Sponsored Presentation

15:20 CET

PSP5 | Audit your Db2 for z/OS - Isn‘t she aDORAble!!
Tuesday October 29, 2024 15:20 - 16:20 CET
1 | Breakout 1 + 2
This session will be all about covering the Audit requirements of DORA (Digital Operational Resilience Act). First up will be our WorkLoadExpert software that catches all the SQL traffic on your enterprise and saves it away, as you never know what you might need tomorrow! Then we will dive into the details of Audit and finally round it all out with a brand new piece of the puzzle: A complete Vulnerability test for your Db2 z/OS Enterprise!
Speakers
avatar for Roy Boxwell

Roy Boxwell

Senior Software Architect, Software Engineering GmbH
Roy Boxwell is an IBM Champion with more than 37 years of experience in MVS, OS/390, and z/OS environments – 36 of those in Db2. He specializes in installation, migration, and performance monitoring and tuning. Roy leads the SEG development team responsible for the real-time database... Read More →
Tuesday October 29, 2024 15:20 - 16:20 CET
1 | Breakout 1 + 2
  Partner-Sponsored Presentation

16:00 CET

LUW Badging
Tuesday October 29, 2024 16:00 - 17:30 CET
1 | Multi 1C
All onsite attendees at IDUG EMEA 2024 are eligible to receive a complimentary LUW badging exam with their paid registration. To register for an exam:
  1. Send an email to badges@idug.org and provide the following information:

    First & Last Name
    Email Address
    Exam Choice
    Day & Time Choice

  2. Select the exam you'd like to take. There are 5 exam choices:

    Db2 11.5 Foundations Exam
    Db2 11.5 Administration Exam
    Db2 11.5 Advanced Database Resilience Exam
    Db2 11.5 Advanced Database Design & Application  
    Development Exam
    Db2 11.5 Advanced Tuning & Debugging Exam
  3. Let us know what time you'll arrive to take the exam. Here are the day/time choices:
Monday:  2:00 PM, 4:00 PM
Tuesday:  10:30 AM, 2:00 PM, 4:00 PM
Wednesday:  10:30 AM, 2:00 PM, 4:00 PM
Thursday:  10:30 AM
 
Please Note:  No walk-ins will be accepted.  You must book in advance and you will receive a confirmation once you are officially booked.  This is a Bring Your Own Device exam.  Photo ID will be required at exam time.
Tuesday October 29, 2024 16:00 - 17:30 CET
1 | Multi 1C
  Badging & Certification

16:20 CET

Break
Tuesday October 29, 2024 16:20 - 16:30 CET
TBA
Tuesday October 29, 2024 16:20 - 16:30 CET
TBA
  Break

16:30 CET

A9 | Db2 13 & new functions – latest real customer experiences…
Tuesday October 29, 2024 16:30 - 17:30 CET
0 | Auditorium 2
This presentation will provide the ongoing success story Db2 z/OS Version 13 and covers the latest experiences with Db2 13 at Commerzbank AG. It will talk about some key important areas which are essential for the success and how to prevent some known avoidable pitfalls. We share the important latest experiences of the last 12 months, explains the upcoming and validated best practices in several key areas. This session will also dive into Function Level details and dependencies up to the latest FL 504 (/505), maintenance aspects, some tooling dependencies and some performance aspects as well as base utilities and system functionalities.
Speakers
avatar for Ute Kleyensteuber

Ute Kleyensteuber

Principal Product Owner, Commerzbank AG
Ute Kleyensteuber is a Principal Product Owner and Senior Infrastructure Engineer at Commerzbank AG in Germany, responsible for Db2 for z/OS since more than 35 years. Knowing and working with Db2 since Version 1.2 I've extensive experiences of Db2 in terms of system- and database... Read More →
Tuesday October 29, 2024 16:30 - 17:30 CET
0 | Auditorium 2
  Technical Session

16:30 CET

B9 | The all new TSA-less pureScale with Pacemaker on Linux
Tuesday October 29, 2024 16:30 - 17:30 CET
0 | Auditorium 3A
After HADR, Mutual Failover, and DPF, pureScale is the fourth and final High Availability configuration to support Pacemaker. The upcoming new Db2 major release represents the cut-over to this new technology.  This session goes into detail of the new architecture highlighting the delta from TSA with the benefits, changes in prerequisites, new up & running experience with new instances or upgrade from 11.5, day 2 operations differences, equivalent support on AWS, and concludes with the new Db2 integrated cluster utility.  It is a must-attend session for all existing and prospective on-premises and cloud pureScale users!
Speakers
avatar for Toby Haynes

Toby Haynes

Senior Software Developer, IBM Canada
With a background in Observational Astronomy at the University of Cambridge, England, Toby joined IBM Canada in 1999 as a software developer in the Db2 Runtime engine. After eight years of development experience, he moved over to the Db2 Performance team to start work on what would... Read More →
Tuesday October 29, 2024 16:30 - 17:30 CET
0 | Auditorium 3A
  Technical Session

16:30 CET

C9 | “Your data or your life!” - What DORA means for your Db2 Database
Tuesday October 29, 2024 16:30 - 17:30 CET
1 | Breakout 1 + 2
How much data could your organisation afford to lose?
Is your current backup and recovery strategy good enough?
With the mainframe being the system of record for 80% of the world’s data, it is imperative that your data resilient under any scenario, including the dreaded ransomware attack. Please join us as we walk through what the impending DORA legislation means for you. You will gain an understanding of the current state of Db2 Security and Backup and Recovery strategies, an awareness of DORA, its implications to your recovery strategy, and the consequences of not being prepared for it.
Speakers
avatar for David Lea

David Lea

Senior Product Owner AMI Security, BMC Software
David Lea is the Senior Product Owner for BMC AMI Security. Having spent seven years in mainframe security consulting he transitioned into his current role and is focused on converting technical knowledge into product enhancements. An advocate for Agile, David is passionate about... Read More →
Tuesday October 29, 2024 16:30 - 17:30 CET
1 | Breakout 1 + 2
  Technical Session

16:30 CET

D9 | Lakehouse as a modern approach to Mainframe Data Modernization: Data Integration, Analytics and AI using Db2 z/OS, VSAM and IMS
Tuesday October 29, 2024 16:30 - 17:30 CET
1 | Breakout 8
This session introduces the Lakehouse concept and what sets it apart from data lakes and traditional data warehouses. We focus on mainframe operational data stores as data feeds, and how such feeds can be integrated with other, non-mainframe data sources, how Lakehouses re-invent analytics and how machine learning training pipelines can be fed using data extracted and refined on a Lakehouse. 
We will use watsonx.data as the Lakehouse implementation, but the approach translates to any Lakehouse because of the use of open data formats.
Speakers
avatar for Daniel Martin

Daniel Martin

Director of Development and CTO for IDAA and DataGate, IBM
Daniel works at IBM since 2010 where he held various engineering and architecture roles contributing to Db2 LUW, Db2 z/OS, IDAA and Data Gate. He currently is the Director of Development and CTO for IDAA and DataGate.
Tuesday October 29, 2024 16:30 - 17:30 CET
1 | Breakout 8
  Technical Session

16:30 CET

E9 | Unlocking Db2 for z/OS Data Using Data Gate on Z
Tuesday October 29, 2024 16:30 - 17:30 CET
0 | Auditorium 3B
In 2021, we initiated a PoC for Db2 for z/OS Data Gate with primary focus on functional and non-functional performance requirements, running on an x86 platform, which was successfully completed with good results. As we started to drill further into other non-functional requirements focusing on HA/DR we came to the conclusion that Data Gate on Z could be a better fit for what we wanted to achieve, which triggered our 2022 PoC, covering Data Gate on Z. This presentation will cover the whole journey of having done PoCs for both x86 and the Z platform, but with emphasis on what additional benefits the Z variant brings to the table. This session will be about positioning Db2 Data Gate on Z as the most efficient/effective way of supporting the fundamental need for unlocking Db2 for z/OS data to support UBS requirements related to a newly defined Digital Core Architecture, app modernization, and MIPS offload use cases.
Speakers
BN

Bjarne Nelson

Db2 Lead Architect, UBS Business Solutions AG
Bjarne Nelson joined the Board in 2007 after 15 years serving in various capacities with IDUG including IDUG Asia-Pacific Conference Speaker, IDUG European Conference Speaker, IDUG North America Conference Speaker, IDUG European Conference Planning Committee Member, IDUG European... Read More →
Tuesday October 29, 2024 16:30 - 17:30 CET
0 | Auditorium 3B
  Technical Session, IDUG EMEA VIRTUAL SESSION

16:30 CET

F9 | Coding Against a Db2 for z/OS Database? Here's How To Make It Perform Well
Tuesday October 29, 2024 16:30 - 17:30 CET
1 | Breakout 3 + 4
Getting data out of a Db2 for z/OS database using SQL is easy enough. However, getting your program to meet performance and or cost requirements is not always that easy. In this presentation I will explain what drives performance and cost and how you can make these aspects a part of your design and coding process.
Speakers
avatar for Emil Kotrc

Emil Kotrc

Software Architect, Broadcom
Emil is a software architect at Broadcom Mainframe Software, he holds a Ph.D. in Mathematical Engineering, is a member of the IDUG Content Committee, and an IBM Champion since 2015.
Tuesday October 29, 2024 16:30 - 17:30 CET
1 | Breakout 3 + 4
  Technical Session

17:30 CET

Evening Reception
Tuesday October 29, 2024 17:30 - 19:00 CET
2 | Multipurpose Room / Solution Center
Tuesday October 29, 2024 17:30 - 19:00 CET
2 | Multipurpose Room / Solution Center
  Solution Center

19:30 CET

A Night Out With Broadcom | Off-Site Reception at Les Arts
Tuesday October 29, 2024 19:30 - 22:00 CET
Los Toros at Les Arts
Don’t miss an evening in the renowned Les Arts, at the Los Toros restaurant.
 
Tuesday 29th, October 2024
19:30-22:00
 
Come for the food and stay for the live music in an iconic city location!
Stop by the Broadcom booth to get your invitation!


Tuesday October 29, 2024 19:30 - 22:00 CET
Los Toros at Les Arts
  Special Event
 
Wednesday, October 30
 

TBA

z/OS Certification
Wednesday October 30, 2024 TBA
All onsite attendees at IDUG EMEA 2024 are eligible to receive a complimentary z/OS certification exam with their paid registration. If you have indicated z/OS as your primary platform in your registration form, you will be receiving an e-mail containing a voucher number and instructions before November 30. Questions? e-mail idug@idug.org.
Wednesday October 30, 2024 TBA
  Badging & Certification

09:00 CET

Keynote | What's Your Why?
Wednesday October 30, 2024 09:00 - 10:00 CET
0 | Auditorium 2
In a world of evolving technologies and constant innovation, it’s easy to get caught up in the “how” and “what” of our work, but the real driving force behind success is understanding the “why.” In this keynote, Julia and Marcus, hosts of the IDUG Db2 Table Talk podcast, and an inspiring panel of Db2 people will dive into the deeper purpose behind the technical challenges we tackle every day and how discovering our personal “why” can ignite creativity, fuel perseverance, and sharpen our problem-solving skills.
Speakers
avatar for Julia Carter

Julia Carter

Db2 Technical Consultant, Broadcom
Julia Carter has 19 years' experience with Db2 and is a Db2 Consultant at Broadcom in Europe. Previously she has worked as a Database Administrator for banks in UK and Mexico.She is a member of the IDUG Content Committee and the GSE UK Db2 committee. Julia is co-host of the IDUG Table... Read More →
avatar for Marcus Davage

Marcus Davage

Lead Product Developer, BMC Software
Having graduated in Computer Science at Aberystwyth in 1990, Marcus has worked with mainframes ever since, as a programmer, systems programmer, consultant, database administrator, production support hero, production support villain and management piñata for various companies. He... Read More →
Wednesday October 30, 2024 09:00 - 10:00 CET
0 | Auditorium 2
  Keynote

10:00 CET

Coffee Break
Wednesday October 30, 2024 10:00 - 10:20 CET
TBA
Wednesday October 30, 2024 10:00 - 10:20 CET
TBA
  Coffee Break

10:20 CET

A10 | Db2 for z/OS Utilities - Latest updates and developments
Wednesday October 30, 2024 10:20 - 11:20 CET
0 | Auditorium 2
In recent years, the Db2 for z/OS Utilities development team has delivered many exciting features in availability, usability and performance improvements, as well as the utility history support that empowers further automation and optimization in utility execution. This session will cover what you need to know about these exciting features, many of which you can take advantage of today.
Speakers
avatar for Ka Chun Ng

Ka Chun Ng

Senior Technical Staff Member, IBM
Ka Chun is one of the lead development architect in the Db2 for z/OS with a focus in the Db2 Utilities area, with over 20 years of experience working in the design, development and services for many utilities such as LOAD, REORG, RUNSTATS, REBUILD INDEX...etc and related Db2 engine... Read More →
Wednesday October 30, 2024 10:20 - 11:20 CET
0 | Auditorium 2
  Technical Session, IDUG EMEA VIRTUAL SESSION

10:20 CET

B10 | Online Database Conversion – NO downtime allowed!
Wednesday October 30, 2024 10:20 - 11:20 CET
0 | Auditorium 3A
We need to move our production database to a new “machine”, or upgrade it to a new version of Db2.   But, we cannot take an outage (longer than a very few minutes).  How can we do that?  What tools are available?   This presentation is a follow-up to last year’s “AIX to RHEL conversion” presentation.  In that case, we were moving small dev environments from AIX to RHEL.  Now it’s SHOW TIME!   It’s time to do Production environments.   What are the strengths and weaknesses of each available tool?   What should we use and what challenges will we encounter?
Speakers
avatar for Ken Shaffer

Ken Shaffer

Db2 Consultant, Aerodata Inc.
Ken has been a DB2 Consultant for over 20 years, specializing in LUW systems. He has worked on a variety of large databases for large corporate and government clients. Most of these projects have involved deploying and supporting mission-critical applications where constant availability... Read More →
Wednesday October 30, 2024 10:20 - 11:20 CET
0 | Auditorium 3A
  Technical Session, IDUG EMEA VIRTUAL SESSION

10:20 CET

C10 | Safeguarding Your Data: A Comprehensive Guide to Db2 for z/OS Security Exit Routines
Wednesday October 30, 2024 10:20 - 11:20 CET
1 | Breakout 1 + 2
Db2 security exits (connection, sign on, and authorization) are critical components of the Db2 security. Do you fully understand what they do and how? Do you have customized versions? Do you want full control?  In this session we will explain the purpose and internals of the security exits, we will navigate through them, and will show how open source tools such as VSCode can significantly help with their comprehension.
Speakers
avatar for Emil Kotrc

Emil Kotrc

Software Architect, Broadcom
Emil is a software architect at Broadcom Mainframe Software, he holds a Ph.D. in Mathematical Engineering, is a member of the IDUG Content Committee, and an IBM Champion since 2015.
Wednesday October 30, 2024 10:20 - 11:20 CET
1 | Breakout 1 + 2
  Technical Session

10:20 CET

D10 | SQL Tricks with Db2
Wednesday October 30, 2024 10:20 - 11:20 CET
1 | Breakout 8
SQL is a very powerful language. It can not only be used to for solving standard OLTP and analytics problems, but also many complex problems where the SQL solution is initially not obvious. This presentation shows some such problems and how solutions for these problems can be developed with SQL in Db2. Examples for such problems are the traversal of graphs, finding covering intervals, or pivoting data. This presentation will also discuss the performance impact of different solutions.
Speakers
avatar for Andreas Weininger

Andreas Weininger

Principal Information Architecture Technical Specialist, IBM
Andreas Weininger is part of the Information Architecture team of IBM in Munich. He has more than 20 year of experience with scalable solutions for data warehousing focusing especially on the performance aspects. He is a regular speaker at database and data warehousing events, and... Read More →
Wednesday October 30, 2024 10:20 - 11:20 CET
1 | Breakout 8
  Technical Session

10:20 CET

E10 | The Beginner's Guide to Db2 Performance Tuning and Faster Applications
Wednesday October 30, 2024 10:20 - 11:20 CET
0 | Auditorium 3B
Dive into the fundamentals of Db2 performance tuning and see firsthand how tuning not only addresses bottlenecks but can optimize application performance. In this beginner-friendly session, we’ll introduce the basics of Db2 performance tuning and then walk together through various advanced, yet easily understandable, optimization techniques. We’ll also explore the essentials of Db2's index navigation, the value of getpages and I/Os, and the importance that statistics, filters, and predicates have on determining the optimal access path for efficient queries. Leave with a firm grasp on the ways to identify and resolve performance issues, leading to faster query responses and more efficient resource utilization. Even better, leave as a Db2 performance expert, with practical ways to enhance the speed, reliability, and user experience of your applications.
The objectives cover a wide spectrum, starting with understanding how Db2 navigates an index and tablespace, and the performance attributes associated with various access paths. Readers will explore the impact of clustered and unclustered indexes on performance and comprehend the significance of getpages (logical reads) and I/Os (physical reads) in influencing system efficiency.
Moreover, this session elucidates the role of statistics, filter factors, and predicates in determining the optimal access path for queries, providing valuable insights into the decision-making process. Furthermore, it introduces potential solutions to common performance issues, equipping beginners with the foundational knowledge and problem-solving skills essential for embarking on the journey of Db2 performance optimization.
Speakers
avatar for Ramon Menendez

Ramon Menendez

Solution Engineer, BMC Software, S.A.
Ramon Menendez is a Principal Technical Consultant from BMC Software in Spain. Specialized in the DB2 family of products, he worked for seven years for IBM in the DB2 for OS/390 arena, mainly in implementation and performance evaluation projects, before joining BMC in 1996. He has... Read More →
Wednesday October 30, 2024 10:20 - 11:20 CET
0 | Auditorium 3B
  Technical Session, IDUG EMEA VIRTUAL SESSION

10:20 CET

F10 | Db2 V13 : The process of migration from V12 to V13. User Experience in INPS
Wednesday October 30, 2024 10:20 - 11:20 CET
1 | Breakout 3 + 4
Because of the services requested and the large amount of data treated, and the need to guarantee these services for business continuity, the Institute has decided to 'MIGRATE' to Db2 V13.
The main reasons for this choice were to make possible the Online conversion of tables from growth-based (PBG) to range-based (PBR) partitions with minimal impact on applications, and to support more open datasets (DSMAX can reach 400,000). 
I will describe the course followed, the solutions adopted and the various phases which allowed the Institute to 'MIGRATE ' to V13.
 
 
5) How we migrate to V13M100
6) How we migrate to V13M500 and V13M501
Speakers
PR

Patrizia Rizzi

System Administrator Db2, INPS
I have been working with Db2 for z/Os ever since V2.3.    I'm a system administrator at INPS(Institute National Pension Social) , the Italien Social Security services. I'm the responsible of Italian Regional User Group Rome (DUGI). I was part of CPC committee from 1999 to 2003... Read More →
Wednesday October 30, 2024 10:20 - 11:20 CET
1 | Breakout 3 + 4
  Technical Session

10:30 CET

LUW Badging
Wednesday October 30, 2024 10:30 - 12:00 CET
1 | Multi 1C
All onsite attendees at IDUG EMEA 2024 are eligible to receive a complimentary LUW badging exam with their paid registration. To register for an exam:
  1. Send an email to badges@idug.org and provide the following information:

    First & Last Name
    Email Address
    Exam Choice
    Day & Time Choice

  2. Select the exam you'd like to take. There are 5 exam choices:

    Db2 11.5 Foundations Exam
    Db2 11.5 Administration Exam
    Db2 11.5 Advanced Database Resilience Exam
    Db2 11.5 Advanced Database Design & Application  
    Development Exam
    Db2 11.5 Advanced Tuning & Debugging Exam
  3. Let us know what time you'll arrive to take the exam. Here are the day/time choices:
Monday:  2:00 PM, 4:00 PM
Tuesday:  10:30 AM, 2:00 PM, 4:00 PM
Wednesday:  10:30 AM, 2:00 PM, 4:00 PM
Thursday:  10:30 AM
 
Please Note:  No walk-ins will be accepted.  You must book in advance and you will receive a confirmation once you are officially booked.  This is a Bring Your Own Device exam.  Photo ID will be required at exam time.
Wednesday October 30, 2024 10:30 - 12:00 CET
1 | Multi 1C
  Badging & Certification

11:20 CET

Break
Wednesday October 30, 2024 11:20 - 11:30 CET
TBA
Wednesday October 30, 2024 11:20 - 11:30 CET
TBA
  Break

11:30 CET

A11 | BMC Db2 AMI Utilities To The Rescue - What's New !!
Wednesday October 30, 2024 11:30 - 12:30 CET
0 | Auditorium 2
Quickly and Easily solve your most demanding Db2 utility challenges using the latest capabilites available in the BMC AMI Db2 utilities. This presentation covers the latest enhnacements in the BMC utilities for Db2 zOS. Come learn how BMC customers solve their hardest operational problems every day using the Db2 utilities from BMC. Gain deep insights on the advanced performance, useability and automation features available today in the BMC Db2 Utilities that set us apart from the competion. 

Speakers
avatar for Michael Cotignola

Michael Cotignola

BMC Db2 Solutions Engineer, BMC Software
Michael Cotignola is a Principal Software Consultant supporting BMC's DB2 Mainframe Solutions.  In this role, he helps his clients maximize the value they receive from BMC's DB2 products.  Michael has worked in IT since 1975 in numerous IT disciplines, including operations, application... Read More →
Wednesday October 30, 2024 11:30 - 12:30 CET
0 | Auditorium 2
  Technical Session

11:30 CET

B11 | Maintaining Database Indexes in a 24×7 World
Wednesday October 30, 2024 11:30 - 12:30 CET
0 | Auditorium 3A
In a 24×7 world, the expectation is that databases are always available, especially those that target OLTP workloads. Within the Db2 family, pureScale is the shared-disk clustering solution that aims to achieve zero downtime for this 24x7 world through an architecture that provides the highest availability for the most demanding OLTP workloads. In this talk we will discuss the improvements we made to pureScale's Index Reorg Rebuild, one of the fundamental day-2 maintenance operations, to allow an index to be completely rebuilt without taking an outage. The architect of the feature will cover the nuts and bolts of the new Db2 pureScale Online Index Reorg Rebuild feature's design, including its processing stages, configuration and monitoring options, and best practices to use it and achieve the highest availability.
Speakers
avatar for Zach Hoggard

Zach Hoggard

Senior Software Developer, IBM
Zach Hoggard is a Senior Software Developer for IBM Db2 in the IBM Data & AI organization at the IBM Canada Lab. Zach has over 10 years of Db2 Kernel development experience and his areas of expertise are the Buffer Pool and Storage Manager components of Db2, but also has extensive... Read More →
Wednesday October 30, 2024 11:30 - 12:30 CET
0 | Auditorium 3A
  Technical Session

11:30 CET

C11 | The TLS journey continues – Client Certificate Authentication for Db2 for z/OS Servers
Wednesday October 30, 2024 11:30 - 12:30 CET
1 | Breakout 1 + 2
Encrypting connections to Db2 servers with TLS is increasingly becoming the standard. While TLS with server certificates is the most common case, Db2 for z/OS installations are more frequently asking for client certificate authentication. After a quick recap of the TLS basics, this presentation shows how client certificate authentication works and how it can be configured for Db2 and REST clients connecting to a Db2 for z/OS database server.
Speakers
avatar for Christoph Theisen

Christoph Theisen

Principal Solutions Advisor, Rocket Software
Christoph is working as Principal Solutions Advisor for Rocket Software and located in Germany. Before joining Rocket in April 2021, he worked for three decades for IBM. Starting in IBM's Global Services unit in 1991 he worked in several client engagements - the majority related to... Read More →
Wednesday October 30, 2024 11:30 - 12:30 CET
1 | Breakout 1 + 2
  Technical Session

11:30 CET

D11 | Optimization 101: What Makes Db2 Choose Certain Access Paths
Wednesday October 30, 2024 11:30 - 12:30 CET
1 | Breakout 8
What makes Db2 chose certain access paths?  Why that index?  Why that join method?   
There are many things that the optimizer code looks at when determining an access path to retrieve the requested data for a query.  This presentation will focus on the main areas that drive the optimizer choices, what control we might have over some of them, and some of the defaults that take place.  This is a 'must see' for those that want to get stronger in performance and tuning and undertand many of the basics.
Speakers
avatar for Tony Andrews

Tony Andrews

Developer, Trainer, Performance and Tuning Consultant, P&T Solutions, Inc.
Tony Andrews has more than 25 years’ experience in the development of relational database applications. Most of this time, he has provided development and consulting services to Fortune 500 companies and government agencies. Tony has written literally thousands of queries and programs... Read More →
Wednesday October 30, 2024 11:30 - 12:30 CET
1 | Breakout 8
  Technical Session

11:30 CET

E11 | Db2 Turbo Statistics
Wednesday October 30, 2024 11:30 - 12:30 CET
0 | Auditorium 3B
Catalog statistics are what fuel the Db2 optimizer, and its tank is always full because of automatic statistics collection. However there are some extra buttons on the dashboard that you can use to enable even better statistics to really boost your query performance. Statistical views are an advanced form of statistics that allow the optimizer to see relationships across joins and to see the data distributions for expressions and even groups of expressions. Statistical views can be combined with column groups and distribution statistics to provide a high-octane boost to your queries with the added benefit of more stable and reliable query performance. Attend this presentation to learn how to use these more advanced forms of statistics to get top performance out of your Db2 system.
Speakers
avatar for John Hornibrook

John Hornibrook

Senior Technical Staff Member, IBM Canada
John is a Senior Technical Staff Member responsible for relational database query optimization on IBM's distributed platforms. This technology is part of Db2 for Linux, UNIX and Windows, Db2 Warehouse, Db2 on Cloud, IBM Integrated Analytics System (IIAS), IBM Db2 Analytics Accelerator... Read More →
Wednesday October 30, 2024 11:30 - 12:30 CET
0 | Auditorium 3B
  Technical Session

11:30 CET

F11 | Customer Journey: Improve Db2 Recoverability Posture Using a Few Simple Procedures
Wednesday October 30, 2024 11:30 - 12:30 CET
1 | Breakout 3 + 4
With increased regulations and the retirement of your most experienced Db2 DBAs, it is more important than ever to review the recovery process for your business data via Db2 log based recovery. This session takes you through the steps necessary to establish an effective recovery procedure, and identify potential bottlenecks to optimizing recovery performance. Built on the foundation of a real life customer scenario, we will show how the customer was able to extend their Db2 solutions to validate recoverability, simulate recoveries to identify areas for optimization, and create recovery strategy templates to provide standardardization for application recovery scenarios. This process resulted in a major reduction in RTO (Recovery Time Objective).
Speakers
avatar for Jim Endler

Jim Endler

Senior Principal Consultant, Technical Consulting, Broadcom
Broadcom Sr. Principal Consultant, Technical Consulting. Provide solution support for Broadcom Db2 Database Aministration, Backup and Recovery, and Performance soutions. Maintain an ongoing customer relationship to ensure Broadcom Db2 Management Solutions are fully exploited to support... Read More →
Wednesday October 30, 2024 11:30 - 12:30 CET
1 | Breakout 3 + 4
  Technical Session

12:30 CET

Lunch
Wednesday October 30, 2024 12:30 - 14:00 CET
TBA
Wednesday October 30, 2024 12:30 - 14:00 CET
TBA
  Lunch

14:00 CET

A12 | Deliver Taylor Swift-Level Performance Through Test Data Management for Db2
Wednesday October 30, 2024 14:00 - 15:00 CET
0 | Auditorium 2
A well-established Test Data Management (TDM) ensures the availability of realistic and representative data for testing purposes. DBAs benefit from an efficient test data provisioning process, while developers leverage diverse test data sets to validate application functionality, performance, and scalability, ultimately leading to higher-quality software releases. In this session, we will explore best practices for establishing TDM processes for Db2 for z/OS data. We will review and discuss possible approaches and techniques, including the additional value those with Broadcom Utilities can derive.
Speakers
avatar for Denis Tronin

Denis Tronin

Product Manager, Broadcom
Denis Tronin is an experienced IT professional and product manager skilled in mainframe (Db2 for z/OS, System Performance, Workload Automation), API management (Zowe API Mediation Layer) and DevOps domains. He is an IBM champion and an active speaker at major mainframe conference... Read More →
Wednesday October 30, 2024 14:00 - 15:00 CET
0 | Auditorium 2
  Technical Session, IDUG EMEA VIRTUAL SESSION

14:00 CET

B12 | Data Movement Utilities: make them work for you
Wednesday October 30, 2024 14:00 - 15:00 CET
0 | Auditorium 3A
In the Db2 world, there are many choices when it comes to Data Movement Utilities. But what's the difference, and which one should you choose? This presentation will discuss the various Data Movement Utilities: LOAD, IMPORT, INGEST, EXPORT and others. We will go over the key differences and which utility is right for your job. Find out about performance comparisons of the various utilities, and how to monitor your job.
Speakers
avatar for Adam Zygmunt

Adam Zygmunt

Software Developer, IBM
Adam Zygmunt is a Software Developer with IBM Db2 LUW kernel development. Focusing on the Data Movement utilities, he is involved in feature development, L3 support and problem determination.
Wednesday October 30, 2024 14:00 - 15:00 CET
0 | Auditorium 3A
  Technical Session, IDUG EMEA VIRTUAL SESSION

14:00 CET

C12 | DB2 Pervasive Encryption - Encryption at Rest
Wednesday October 30, 2024 14:00 - 15:00 CET
1 | Breakout 1 + 2
Natwest group is one of the largest Db2 for z/OS customers worldwide with multi member multi data sharing groups. This environment supports a number of critical, very high volume and high availability (24/7/365) customer facing application.
In the highly regulated financial services world there is an increasing requirement to encrypt application data at rest held in Db2 objects. This session gives an overview of encryption at Rest for z/OS Db2 and the implementation details from a Db2 perspective.
Speakers
avatar for Dhiren Chaudhary

Dhiren Chaudhary

Db2 Tech Lead, Natwest Group
Db2 professional with 20+ years experience in Db2 with a passion for performance tuning and deriving actionable insights from data.
Wednesday October 30, 2024 14:00 - 15:00 CET
1 | Breakout 1 + 2
  Technical Session

14:00 CET

D12 | SQL in Action - An Index Compendium
Wednesday October 30, 2024 14:00 - 15:00 CET
1 | Breakout 8
The query speed indexes can provide is astonishing! Why is that? What details need to be considered? What is good to know regarding indexes?These question will be shown and discussed in detail as indexes are an outstanding performance feature of databases and change the runtime of queries from hours to minutes or even seconds.
Learn about different index types index maintenance and monitoring.Virtual indexes are helpful in my daily practice so options and advantages will be presented.
This presentation will help you to get a deeper understanding about indexes and provide hints for a improved index usage.
Speakers
avatar for Michael Tiefenbacher

Michael Tiefenbacher

Principal Consultant & Customer Success Manager, mip GmbH
Michael works as a consultant, architect and trainer for Db2 and Data Warehousing with more than 25 years of experience. He is a frequent speaker at conferences and is awarded IBM Gold Consultant and as IBM Champion since 2010. He is also one of the RUG-Leaders of the DeDUG user group... Read More →
Wednesday October 30, 2024 14:00 - 15:00 CET
1 | Breakout 8
  Technical Session

14:00 CET

E12 | When you know where to look, diagnosing Db2 performance problems is easy peasy
Wednesday October 30, 2024 14:00 - 15:00 CET
0 | Auditorium 3B
Analyzing Db2 for z/OS performance problems can be overwelming. There is a lot of information available in Db2 , z/OS, ... so it is important that you know where to look and what to look at.
This session will discuss a number of real customer problems, what info to collect, and how to analyze and interpret the data to find the heart of the problem.
While the focus will be on Db2, but as Db2 performance is closely related to how the overall z/OS system is doing, the session will also explore a number of z/OS key metrics to see whether the issue you experience in Db2 might be part of a larger system problem or not. 
Speakers
avatar for Akiko Hoshikawa

Akiko Hoshikawa

Db2 for z/OS Development, IBM
Akiko Hoshikawa is a Distinguished Engineer at IBM Silicon Valley Laboratory in San Jose. As a Db2 for z/OS architect she has overall responsibility for the performance and strategic integration of AI capability within IBM Db2 for z/OS, including the Db2 AI for z/OS product
Wednesday October 30, 2024 14:00 - 15:00 CET
0 | Auditorium 3B
  Technical Session, IDUG EMEA VIRTUAL SESSION

14:00 CET

F12 | Understanding Db2 latches and latch waits in OLTP environment
Wednesday October 30, 2024 14:00 - 15:00 CET
1 | Breakout 3 + 4
Db2 exposes various latch monitoring interfaces: - MON_GET_LATCH - TOTAL_EXTENDED_LATCH_WAIT in MON interfaces- db2pd -latches
Those are primarily intended for the support and internal usage, hence not well documented, but it still might be very useful for DBAs system admins to know how to interpret them and explore tuning possibilities to achieve better throughput.The intention of the presentation is to explain how Db2 handles concurrency and what types of workloads might cause latch waits.Presentation will cover latches in: - bufferpool  (bpdLatch, groupLatch, clockLatch)- memory (SMemPool latch)- lock manager (xhsh and hsh latch)- OS locks (SQLO_LT_NO_IDENTITY latch) 
Bottleneck analysis and examples will be primarily based on the real scenarios from Inditex environments, with whom I've worked over many years on various performance problems.
Presentation will be done with the customer (Indiex, Luis Alberto López Maldonado)
Speakers
avatar for Kamil Kuduk

Kamil Kuduk

Db2 Advanced Problem Determination, IBM Poland
Working for IBM Db2 in support role for over 10 years. Last few years in the Advanced Problem Determination team, specializing in performance problems and operating system troubleshooting.
Wednesday October 30, 2024 14:00 - 15:00 CET
1 | Breakout 3 + 4
  Technical Session

14:00 CET

LUW Badging
Wednesday October 30, 2024 14:00 - 15:30 CET
1 | Multi 1C
All onsite attendees at IDUG EMEA 2024 are eligible to receive a complimentary LUW badging exam with their paid registration. To register for an exam:
  1. Send an email to badges@idug.org and provide the following information:

    First & Last Name
    Email Address
    Exam Choice
    Day & Time Choice

  2. Select the exam you'd like to take. There are 5 exam choices:

    Db2 11.5 Foundations Exam
    Db2 11.5 Administration Exam
    Db2 11.5 Advanced Database Resilience Exam
    Db2 11.5 Advanced Database Design & Application  
    Development Exam
    Db2 11.5 Advanced Tuning & Debugging Exam
  3. Let us know what time you'll arrive to take the exam. Here are the day/time choices:
Monday:  2:00 PM, 4:00 PM
Tuesday:  10:30 AM, 2:00 PM, 4:00 PM
Wednesday:  10:30 AM, 2:00 PM, 4:00 PM
Thursday:  10:30 AM
 
Please Note:  No walk-ins will be accepted.  You must book in advance and you will receive a confirmation once you are officially booked.  This is a Bring Your Own Device exam.  Photo ID will be required at exam time.
Wednesday October 30, 2024 14:00 - 15:30 CET
1 | Multi 1C
  Badging & Certification

15:00 CET

Coffee Break
Wednesday October 30, 2024 15:00 - 15:20 CET
TBA
Wednesday October 30, 2024 15:00 - 15:20 CET
TBA
  Coffee Break

15:20 CET

PSP10 | Exploiting Cloud and Db2 Recovery Strategies for DORA Compliance
Wednesday October 30, 2024 15:20 - 16:20 CET
1 | Breakout 8
DBAs must keep business-critical data available and eliminate downtime while complying with stringent regulations such as DORA. The Digital Operational Resilience Act (DORA) initiative protects institutions during catastrophic cyberattacks, ensuring timely data access. This presentation explores enhancing high availability and productivity through automation and modern interfaces for Db2 professionals. We will highlight ensuring operational resilience in the context of mainframe data within a hybrid cloud environment, the importance of immutable mainframe data copies, their benefits and challenges, and strategies for leveraging these copies to enhance data availability and expedite recovery. Leave with strategies to prepare for potential issues, quickly identify problems, solve them, and recover data to as close to current as possible, meeting different industry guidelines.
Speakers
avatar for Roberto Cason

Roberto Cason

Solution Engineer, BMC Software
About 30 year of DB2 for z/OS experience working with customers in Italy.                            Over then 25 years of experience as System programmer and DBA in an outsourcing company for Banks and Financial Institutes where he was responsible for the design, maintenance... Read More →
GA

Gianluca Alessi

Director, SW Consulting
Wednesday October 30, 2024 15:20 - 16:20 CET
1 | Breakout 8
  Partner-Sponsored Presentation

15:20 CET

PSP7 | IBM Db2 Strategy & Roadmap
Wednesday October 30, 2024 15:20 - 16:20 CET
0 | Auditorium 2
Customers use IBM Db2 to run some of the toughest mission critical workloads on the planet. The world’s largest financial institutions, healthcare providers and insurers, car manufacturers, retailers, government agencies all trust Db2 to run their operations every day. Customers depend on Db2 to continuously innovate and enable them to accelerate their own innovation, like building the next generation of cutting-edge cloud/AI apps and services. In this session, we discuss IBM’s strategy and roadmap, review the latest advancements with the upcoming Db2 12 release, and preview the AI initiatives planned for 2025. We’ll dive into Amazon RDS for Db2, a new offering on AWS that makes it easy to set up, operate, and scale Db2 databases in the cloud. And, finally, we’ll preview a brand new generative AI-powered product that makes it easy for Db2 DBAs to get their work done.
Speakers
avatar for Miran Badzak
Wednesday October 30, 2024 15:20 - 16:20 CET
0 | Auditorium 2
  Partner-Sponsored Presentation

15:20 CET

PSP8 | Db2 Meets Open Source = A Powerful DevOps Strategy
Wednesday October 30, 2024 15:20 - 16:20 CET
0 | Auditorium 3A
We all understand the importance of solving contention between the infrastructure team responsible for operations and the application development teams. Operations owners value stability, which can be disrupted from application changes. Join us in this session to discover how you can successfully incorporate Db2 into your end-to-end DevOps process using a proven approach and alleviate the tension by providing transparency for all stakeholders. In the case of Db2 for z/OS, a smooth DevOps strategy can enhance application development practices and improve time to value for application changes. You will learn how building on your existing infrastructure and exploiting the plethora of open-source software in the market using this prescriptive approach can enable you to successfully incorporate Db2 in your end-to-end DevOps process.
Speakers
avatar for Denis Tronin

Denis Tronin

Product Manager, Broadcom
Denis Tronin is an experienced IT professional and product manager skilled in mainframe (Db2 for z/OS, System Performance, Workload Automation), API management (Zowe API Mediation Layer) and DevOps domains. He is an IBM champion and an active speaker at major mainframe conference... Read More →
avatar for Emil Kotrc

Emil Kotrc

Software Architect, Broadcom
Emil is a software architect at Broadcom Mainframe Software, he holds a Ph.D. in Mathematical Engineering, is a member of the IDUG Content Committee, and an IBM Champion since 2015.
avatar for Chris Crone

Chris Crone

Distinguished Engineer - Database Technologies, Broadcom
Chris Crone has extensive experience working with Db2 and IBM z Systems. He brings over 30 years of work with the Db2 for z/OS development team. He’s worked extensively with customers on new development projects, prioritizing requirements, and fighting fires.
Wednesday October 30, 2024 15:20 - 16:20 CET
0 | Auditorium 3A
  Partner-Sponsored Presentation

15:20 CET

PSP9 | Database Assistant for Db2: Simplify Db2 Troubleshooting and Error Resolution with AI
Wednesday October 30, 2024 15:20 - 16:20 CET
0 | Auditorium 3B
As data environments grow increasingly complex, database administrators (DBAs) face challenges in maintaining performance and troubleshooting errors efficiently. Our forthcoming AI-powered solution leverages natural language processing to streamline database interaction, allowing users to query their Db2 systems and resolve issues with ease. This presentation will explore how AI-driven tools can transform Db2 management by simplifying tasks such as error resolution, performance monitoring, and retrieving key metrics. Attendees will gain insights into the evolving role of AI in enhancing DBA productivity and operational efficiency.
Speakers
NW
Wednesday October 30, 2024 15:20 - 16:20 CET
0 | Auditorium 3B
  Partner-Sponsored Presentation

16:00 CET

LUW Badging
Wednesday October 30, 2024 16:00 - 17:30 CET
1 | Multi 1C
All onsite attendees at IDUG EMEA 2024 are eligible to receive a complimentary LUW badging exam with their paid registration. To register for an exam:
  1. Send an email to badges@idug.org and provide the following information:

    First & Last Name
    Email Address
    Exam Choice
    Day & Time Choice

  2. Select the exam you'd like to take. There are 5 exam choices:

    Db2 11.5 Foundations Exam
    Db2 11.5 Administration Exam
    Db2 11.5 Advanced Database Resilience Exam
    Db2 11.5 Advanced Database Design & Application  
    Development Exam
    Db2 11.5 Advanced Tuning & Debugging Exam
  3. Let us know what time you'll arrive to take the exam. Here are the day/time choices:
Monday:  2:00 PM, 4:00 PM
Tuesday:  10:30 AM, 2:00 PM, 4:00 PM
Wednesday:  10:30 AM, 2:00 PM, 4:00 PM
Thursday:  10:30 AM
 
Please Note:  No walk-ins will be accepted.  You must book in advance and you will receive a confirmation once you are officially booked.  This is a Bring Your Own Device exam.  Photo ID will be required at exam time.
Wednesday October 30, 2024 16:00 - 17:30 CET
1 | Multi 1C
  Badging & Certification

16:20 CET

Break
Wednesday October 30, 2024 16:20 - 16:30 CET
TBA
Wednesday October 30, 2024 16:20 - 16:30 CET
TBA
  Break

16:30 CET

A13 | z/OS Expert Panel
Wednesday October 30, 2024 16:30 - 17:30 CET
0 | Auditorium 2
Wednesday October 30, 2024 16:30 - 17:30 CET
0 | Auditorium 2
  Expert Panel

16:30 CET

B13 | Db2 Connect - What's new and Best Practices
Wednesday October 30, 2024 16:30 - 17:30 CET
0 | Auditorium 3A
Db2 Connect is supposed to be a well-known topic but it is often not very well understood. This session shows the latest updates to Db2 Connect V11.5 and presents some of the best practices from conversations and interactions with customers. We cover topics such as installation, deployment, license activation, and configuration, including setting up TLS. In addition, we show why direct connectivity to Db2 mainframe servers is the preferred solution over Db2 Connect Servers, a.k.a. as Gateways.
Speakers
avatar for Christoph Theisen

Christoph Theisen

Principal Solutions Advisor, Rocket Software
Christoph is working as Principal Solutions Advisor for Rocket Software and located in Germany. Before joining Rocket in April 2021, he worked for three decades for IBM. Starting in IBM's Global Services unit in 1991 he worked in several client engagements - the majority related to... Read More →
Wednesday October 30, 2024 16:30 - 17:30 CET
0 | Auditorium 3A
  Technical Session

16:30 CET

C13 | Db2 audit made easy
Wednesday October 30, 2024 16:30 - 17:30 CET
1 | Breakout 1 + 2
Let Db2 take care of the audit data automatically, w/o having to run external Jobs in order to archive and extract the audit logs.This is a presentation about the handling of audit data in a customer project at REWE digital in Germany. Since Db2 10.5 FP4 (Cancun), it's possible for the extract of audit logs, to write that data to SYSLOG on Unix (AIX & Linux) systems.
Customer wants to get rid of scheduled external jobs, which have to run in intervalls against every db2 instance (more than 150) in their environment in order to archive and extract the audit data for instances and databases.
The session will give insight into the realisation of the project using Db2's internal administrative task scheduler and procedures in oder to extract the audit data directly to SYSLOG files and let QRADAR take the data directly from that single source per system for further processing.
Monitoring of the audit processing will be another main aspekt of this session.
Speakers
avatar for Torsten Roeber

Torsten Roeber

Db2 Services Specialist, IBM Germany
I'm with IBM since 1990 and most of my career worked in product support.More than 15 years, I've worked as Db2 LUW product support engineer for Germay and EMEA. Currently I'm working for IBM Services (TLS) supporting customer with Db2 projects.
Wednesday October 30, 2024 16:30 - 17:30 CET
1 | Breakout 1 + 2
  Technical Session

16:30 CET

D13 | Db2 Developers Top 10 Lists
Wednesday October 30, 2024 16:30 - 17:30 CET
1 | Breakout 8
There are some technical basics that I think every Db2 developer should know as part of their jobs in designing, developing, and tuning applications they are a part of.  What should they know in order to code the most efficient queries?  What should they know in order to design the most efficient program and application architecture?  What should they know about in order to minimize production incidents?  This presentation will cover these areas and more to help get the developer more 'Empowered' in their day to day projects.
Speakers
avatar for Tony Andrews

Tony Andrews

Developer, Trainer, Performance and Tuning Consultant, P&T Solutions, Inc.
Tony Andrews has more than 25 years’ experience in the development of relational database applications. Most of this time, he has provided development and consulting services to Fortune 500 companies and government agencies. Tony has written literally thousands of queries and programs... Read More →
Wednesday October 30, 2024 16:30 - 17:30 CET
1 | Breakout 8
  Technical Session

16:30 CET

E13 | Tuning SQL Stored Procedures (z/OS Edition)
Wednesday October 30, 2024 16:30 - 17:30 CET
0 | Auditorium 3B
SQL stored procedures are a common way to encapsulate application functionality in Db2 for z/OS, both natively for applications or as part of Db2 REST APIs.   But what happens when they need to be tuned?   This presentation explores the underlying implementation of SQL stored procedures and how to go about improving their performance.
Speakers
avatar for Philip Nelson

Philip Nelson

Senior Database Software Engineer, Lloyds Banking Group / ScotDB Limited
Philip Nelson has worked with Db2 for z/OS since 1989 and with Db2 (LUW) since the beginning.   He presents on a variety of Db2 topics at conferences, but particularly focusing on exploiting new functionality and encouraging application developer interaction.   He has been an... Read More →
Wednesday October 30, 2024 16:30 - 17:30 CET
0 | Auditorium 3B
  Technical Session

16:30 CET

F13 | The useful, the hidden and the mystical
Wednesday October 30, 2024 16:30 - 17:30 CET
1 | Breakout 3 + 4
The presentation is about an Admin_Move_Table journey, how it works, step by step. It also shows an alternative way to generate DDL, similar to Db2Look and give some tips how a DBA can use ChatGPT.
Speakers
avatar for Marcel Scheibe

Marcel Scheibe

Database Administrator, Atruvia AG
* Starting in 1997 as a developer with PL/1 and Db2 for z/OS* 2001 changed to the Db2 for z/OS database administration* 2008 started with Db2, a project to migrate a database from Db2 for z/OS to Db2* Then I lived in both Db2 worlds for a while* In 2015 I decided to only work with... Read More →
Wednesday October 30, 2024 16:30 - 17:30 CET
1 | Breakout 3 + 4
  Technical Session

17:30 CET

Break
Wednesday October 30, 2024 17:30 - 17:40 CET
TBA
Wednesday October 30, 2024 17:30 - 17:40 CET
TBA
  Break

17:40 CET

B14 | LUW Expert Panel
Wednesday October 30, 2024 17:40 - 18:40 CET
0 | Auditorium 3A
Wednesday October 30, 2024 17:40 - 18:40 CET
0 | Auditorium 3A
  Expert Panel

17:40 CET

A14 | "Run-It-Back" - Db2 for z/OS Development all new "2024 SWAT Tales"
Wednesday October 30, 2024 17:40 - 18:40 CET
0 | Auditorium 2
The session will concentrate on new SWAT team experiences. Various unexpected outcomes and behaviors will be discussed as well has hot technical items customers are exploiting as well as technologies that have been challenging for customers. The complete session will be focused on customer experiences and sharing real life outcomes.
Speakers
avatar for Anthony Ciabattoni

Anthony Ciabattoni

Db2 for z/OS SWAT Team Leader, IBM
Anthony Ciabattoni is an IBM Certified Executive IT specialist and a current member of the Db2 for z/OS Development SWAT team based out of the Silicon Valley Lab with over 30 years of working directly with Db2 for z/OS. His experience includes be a customer lead Db2 architect as well... Read More →
Wednesday October 30, 2024 17:40 - 18:40 CET
0 | Auditorium 2
  Technical Session

17:40 CET

C14 | Who's Knocking At the Door? Best Practices for Auditing Access to Db2 for z/OS
Wednesday October 30, 2024 17:40 - 18:40 CET
1 | Breakout 1 + 2
Do you want to know when unauthorized access to Db2 has been attempted? Maybe learn who messed up your data? In this presentation we will learn what Db2 for z/OS has to offer for security auditing. The audience will get a good understanding of audit practices; traces and policies that can help to prevent unauthorized access.
Speakers
avatar for Denis Tronin

Denis Tronin

Product Manager, Broadcom
Denis Tronin is an experienced IT professional and product manager skilled in mainframe (Db2 for z/OS, System Performance, Workload Automation), API management (Zowe API Mediation Layer) and DevOps domains. He is an IBM champion and an active speaker at major mainframe conference... Read More →
Wednesday October 30, 2024 17:40 - 18:40 CET
1 | Breakout 1 + 2
  Technical Session

17:40 CET

D14 | IDUG Content Committee SQL Dojo 2024
Wednesday October 30, 2024 17:40 - 18:40 CET
1 | Breakout 8
The IDUG Content Committee consists of a team of dedicated volunteers who produce content for IDUG website including articles and blogs and the ever-popular DB2 Table Talk podcast.  Come to this session where the attendees will be placed into teams and be given SQL Challenges to solve by the content committee.  Amusing and practical challenges will be given to the contestants.  Each team will have a few minutes at a keyboard to solve the current problem before the keyboard is passed to the next team.  Shouting, googling, giving advice (good and bad) and general mayhem are all allowed during this fun, interactive and non-traditional session!
Wednesday October 30, 2024 17:40 - 18:40 CET
1 | Breakout 8
  Technical Session

17:40 CET

E14 | Introduction to dashboards for Db2 for z/OS DBAs
Wednesday October 30, 2024 17:40 - 18:40 CET
0 | Auditorium 3B
The ability to explore, analyze, and visualize data is becoming a hot topic. As DevOps is adapted by the mainframe community the developers show an increasing interest in the Ops side, i.e., being able to monitor and view the health of an application. While showing data in 3270 is not bad there are many advantages of using modern tooling to visualize data. 
In the first half of the presentation, we will give a high level introduction to modern open source visualization tools like Kibana and Grafana. 
In the second half of the presentation we will explore several use cases of interest to Db2 for z/OS DBAs and application owners and developers, such as viewing Db2 real time statistics, Db2 utility history and Db2 performance metrics. Ultimately this allows you to build dashboards tailored to individual applications.
Speakers
avatar for Jørn Thyssen

Jørn Thyssen

Principal Solutions Advisor, Rocket Software
Jørn Thyssen joined Rocket in 2017 as a Solutions Advisor specializing in Db2 tools bringing in 16 years of experience working with IBM z technology and Db2 for z/OS. He specializes in mainframe modernization, Db2 administration, and Db2 performance supporting customers across the... Read More →
Wednesday October 30, 2024 17:40 - 18:40 CET
0 | Auditorium 3B
  Technical Session

17:40 CET

F14 | sysplexWLB - one step closer to achieve Continuos Availability for DDF
Wednesday October 30, 2024 17:40 - 18:40 CET
1 | Breakout 3 + 4
SysplexWLB is one of features allowing achieve continues availability in datasharing group accessed from remote DDF clients. However to effectively use it there are some requirements to meet, often not understood correctly. Also new Db2 z/OS 13 gives sysprogs and Db2 administrators more "power" to enable it globally for clients coming to Db2z.This presentation will explain concept of sysplexWLB

how it works
what is required to implement it,
sample ideal architectual setup
zparm settings
recent enhancements in Db2 z/OS 13 for sysplexWLB
Speakers
avatar for Michal Bialecki

Michal Bialecki

Db2 z/OS SWAT Team, IBM
Michal Bialecki is an IBM Certified Technical Specialist and a member of the DB2 z/OS Development SWAT team where he supports and advocates for customers across various industries and geographies. For the last 15 years Michal worked for the Db2 for z/OS organization in support & development... Read More →
Wednesday October 30, 2024 17:40 - 18:40 CET
1 | Breakout 3 + 4
  Technical Session

19:30 CET

A Night Out With IBM | Off-Site Reception at the Melia Rooftop
Wednesday October 30, 2024 19:30 - 21:30 CET
Melia Rooftop
Please visit the IBM booth to register -- we look forward to seeing you there!






Wednesday October 30, 2024 19:30 - 21:30 CET
Melia Rooftop
  Special Event
 
Thursday, October 31
 

TBA

z/OS Certification
Thursday October 31, 2024 TBA
All onsite attendees at IDUG EMEA 2024 are eligible to receive a complimentary z/OS certification exam with their paid registration. If you have indicated z/OS as your primary platform in your registration form, you will be receiving an e-mail containing a voucher number and instructions before November 30. Questions? e-mail idug@idug.org.
Thursday October 31, 2024 TBA
  Badging & Certification

09:00 CET

A15 | Exploiting Db2 DDF without fears or revelations
Thursday October 31, 2024 09:00 - 10:00 CET
0 | Auditorium 2
The presentation will concentrate on the use and evolution of Db2 DDF access from its infancy to a leading OLTP transactional model that organizations are relying on. During the session industry infrastructure and application usage best practices will be discussed. Db2 for z/OS SWAT team customer experiences will be shared, what has worked and the challenges that have been experienced. In addition to DDF access dynamic SQL fears and concerns will be targeted. The overall objective of the session is to share best practices and success stories and to calm any revelations around DDF from an infrastructure and application perspective and organizations increasingly exploit the technology.
Speakers
avatar for Anthony Ciabattoni

Anthony Ciabattoni

Db2 for z/OS SWAT Team Leader, IBM
Anthony Ciabattoni is an IBM Certified Executive IT specialist and a current member of the Db2 for z/OS Development SWAT team based out of the Silicon Valley Lab with over 30 years of working directly with Db2 for z/OS. His experience includes be a customer lead Db2 architect as well... Read More →
Thursday October 31, 2024 09:00 - 10:00 CET
0 | Auditorium 2
  Technical Session

09:00 CET

B15 | Getting the Best from your applications on Db2 pureScale in v12.1
Thursday October 31, 2024 09:00 - 10:00 CET
0 | Auditorium 3A
DB2 pureScale v12.1 is the ideal platform for demanding OLTP applications, with Outstanding Availability, Excellent Performance and Scalability.
The most-common SQL for DB2 OLTP applications run unmodifed on Db2 pureScale when migrating from existing Db2 non-clustered configurations. Most changes for optimizations deal with database design, such as indexes and data partitioning, to maximize performance and scalability. This presentation focuses on not just functioning on Db2 pureScale but finding opportunities to run optimally and reap the benefits of scale-up and scale-out performance:

spotting challenges early in planning / porting applications to Db2 pureScale
using database monitoring insights to find and address bottlenecks 
Speakers
avatar for Christian Garcia-Arellano

Christian Garcia-Arellano

STSM, Db2 OLTP Architect and Master Inventor, IBM Canada
Christian Garcia-Arellano is STSM and Db2 OLTP Architect at the IBM Toronto Lab, and has a MSc in Computer Science from the University of Toronto. Christian has been working in various DB2 Kernel development areas since 2001. Initially Christian worked on the development of the self... Read More →
Thursday October 31, 2024 09:00 - 10:00 CET
0 | Auditorium 3A
  Technical Session

09:00 CET

C15 | A new way to migrate your Db2 for z/OS systems has arrived!
Thursday October 31, 2024 09:00 - 10:00 CET
1 | Breakout 1 + 2
In this session we will demonstrate how you can exploit recent innovations to automate the generation of Db2 migration artifacts for a traditional or with the usage of IBM Z/OSMF workflows to install and / or migrate a Db2 subsystem or members of a data sharing group. We will demo to you how the artifacts can be generated. Next, we will show how these artifacts are assembled into a workflow. Finally, we will give a preview how we are evolving to auto-discover all the Db2 installation configuration parameters.
Speakers
avatar for Sueli Almeida

Sueli Almeida

IBM Certified Thought Leader, IBM
Thursday October 31, 2024 09:00 - 10:00 CET
1 | Breakout 1 + 2
  Technical Session

09:00 CET

D15 | I REST my case! Exploit API's for productivity
Thursday October 31, 2024 09:00 - 10:00 CET
1 | Breakout 8
Come to this session to learn about the value that REST APIs can bring to your shop. You will find that it is not nearly as tough as it may look. I will explain the how using some working examples.
Speakers
avatar for Toine Michielse

Toine Michielse

Solutions Architect, Broadcom
I have been working with Db2 for z/OS ever since V1. In my career I have worked as COBOL/IMS/DB2 programmer, IMS/DB2 DBA and DB2 system engineer. I have worked a number of years as a Db2 Lab advocate, supporting IBM customers worldwide. Before joining Broadcom I worked at SwissRe... Read More →
Thursday October 31, 2024 09:00 - 10:00 CET
1 | Breakout 8
  Technical Session

09:00 CET

E15 | Beyond DB2 Comfort Zone: From Performance Optimization to Automation to Cloud
Thursday October 31, 2024 09:00 - 10:00 CET
0 | Auditorium 3B
Complex database operation on Power system to support very high transactional volume of 80,000/secondsNear realtime HA/DR with a split seconds recoveryAutomated upgrades and configuration to maintain 500 plus databases with few resources and high level resilienciesSharing the best practices to work with IBM L3, CritSit and special teams to improve IBM/DB2 for this complex and mission critical databaseAll migrations efforts with current offering from IBM and AWSIn-house CDC solution where market driven tools like DMS/Infospehere fails.
Speakers
avatar for Nemi Agrawal

Nemi Agrawal

IT Executive, Raindrops Inc.
emi Agrawal has extensive experience in leading strategic and complex solutions often cutting across organizational lines for mission critical systems at the Department of Homeland Security/Customs and Border Protection (DHS/CBP) and financial industry. His expertise in leading databases... Read More →
Thursday October 31, 2024 09:00 - 10:00 CET
0 | Auditorium 3B
  Technical Session

09:00 CET

F15 | Example of Disaster Recovery config in Mainframe&Distributed environment
Thursday October 31, 2024 09:00 - 10:00 CET
1 | Breakout 3 + 4
The presentation will be divided into 3 parts:
1. DR recommendation for Mainframe environment focusing on DB2 z/OS
DR cosiderations: What technology? What data? What purpose?
- popular DR myths word thinking about
- is there any recommendation other than 'It depends'?
2. DR configuration in mixed environmentPresentation will cover real production configuration for core banking application from Disaster Recovery point of view. Applications runs on Mainframe and Linux/Windows environment, both parts of app are important and data consistency between them is crucial. 
Application consumes :
a.      few thousand of MSU on Mainframe
b.     about 100 TB of data on Mainframe
c.      more than 50 physical intel servers 
d.     about 150 TB of data on distributed
Presentation describes the approach for db2 z/os and files data consistency between two platform. The approach for building and testing disaster recovery procedures will be presented. 
3. Golden Copy verification in mixed environmentsPresentation will cover the idea of creating consistent backup before each batch processing, short description of configuration will explain the idea of approach for backup.
All aspects of configuration and testing (consistency) Golden copy backup will be described.
Speakers
avatar for Mateusz Książek

Mateusz Książek

Db2 Administrator, PKOBP
Technical Leader in mainframe modernization project - Cross platform monitoring design & performance analysis(mainframe/distributed) - Application migration to distributed env - Dr architecture for cross platform env - TroubleshootingDB2 system AdministratorDB2 performance monitoring... Read More →
Thursday October 31, 2024 09:00 - 10:00 CET
1 | Breakout 3 + 4
  Technical Session

10:00 CET

Coffee Break
Thursday October 31, 2024 10:00 - 10:20 CET
TBA
Thursday October 31, 2024 10:00 - 10:20 CET
TBA
  Coffee Break

10:20 CET

A16 | Driving Down Database Development Dollars
Thursday October 31, 2024 10:20 - 11:20 CET
0 | Auditorium 2
Application developers and database administrators alike are under constant pressure to drive down costs and reduce CPU cycles. Discover technical insights and cultural shifts for Developers, DBAs, and Operations to tackle the widespread challenges in mainframe enterprises globally. Learn SQL tips and compiler hints. Find out what culture changes are necessary for co-ordinated cooperation in cost reduction. Join Marcus Davage, BMC Lead Product Developer, for this insightful webinar.
Speakers
avatar for Marcus Davage

Marcus Davage

Lead Product Developer, BMC Software
Having graduated in Computer Science at Aberystwyth in 1990, Marcus has worked with mainframes ever since, as a programmer, systems programmer, consultant, database administrator, production support hero, production support villain and management piñata for various companies. He... Read More →
Thursday October 31, 2024 10:20 - 11:20 CET
0 | Auditorium 2
  Technical Session, IDUG EMEA VIRTUAL SESSION

10:20 CET

B16 | Db2 Advanced Log Space Management - Unleashed
Thursday October 31, 2024 10:20 - 11:20 CET
0 | Auditorium 3A
Trying to figure out the ins and outs of Db2 Log Space Management?  Spent too much time trying to figure out what settings are best for your environment?  With the introduction of Advanced Log Space Management the time has come to unleash it's potential.  Fully supported, the journey has begun in making log space management more autonomic.  This presentation will introduce you to some of the concepts and principles behind it all.  We will do a deep dive into the technology and transformation behind making log space management more hands off, which in the end will make life simple for you and your organization.
Speakers
avatar for Michael Roecken

Michael Roecken

Senior Software Developer, IBM Canada Ltd.
Michael Roecken is a senior software developer with Db2 for Linux, UNIX, and Windows platforms at the IBM Toronto Lab.  Michael has worked since 2000 designing, implementing and supporting various features and capabilities in the areas of: backup/restore, crash/rollforward recovery... Read More →
Thursday October 31, 2024 10:20 - 11:20 CET
0 | Auditorium 3A
  Technical Session, IDUG EMEA VIRTUAL SESSION

10:20 CET

C16 | Power-Up for Ansible: Use Db2 as Configuration Database
Thursday October 31, 2024 10:20 - 11:20 CET
1 | Breakout 1 + 2
I already showed howto work on Db2-Databases with Ansible and Python in previous IDUG sessions. This time around I'm going to guide you through the process on how to use Db2 as a configuration repository for Ansible. Runtime configuration for Ansible playbooks is usually done by the ansible inventory (usually requires a pull request) and, for runtime configuration, "extra-vars". This can be cumbersome in large environments and does not bear much flexibility. The result is usually an increase of AWX/Ansible-Tower templates for different configurations and targets. Furthermore, the templates (and surveys) get increasingly complex and uncomfortable to handle. Keeping runtime configuration data in a centralized database gives ample oportunity to create and maintain arbitrarily complex runtime configurations in one or multiple Databases with SQL so that the user does not need to know anything about Ansible at all, minimizing operational overhead.I will show how to implement this with the help of a few lines of python code. Live-elements will be pre-recorded if needed. Code will be available on GitHub.
Speakers
avatar for Norbert Munkel

Norbert Munkel

Solution Consultant, ITGAIN Consulting GmbH
I started getting in touch with IT when I got a student job at the german nuclear safety agency programming Fortran77 in 1986. I ended up in a regional data center doing all sorts of things on the distributed side. In 1999 I joined SUSE Linux in Nuremberg where I manged the international... Read More →
Thursday October 31, 2024 10:20 - 11:20 CET
1 | Breakout 1 + 2
  Technical Session

10:20 CET

D16 | Better Together: Modernizing Development with Ansible & Db2 Integration for z/OS
Thursday October 31, 2024 10:20 - 11:20 CET
1 | Breakout 8
Transform mainframe development with Ansible's automation capabilities. Learn how the IBM Ansible Z Collection provides a modern mainframe interface for RESTful API interactions to IBM® Db2® integrations, including practical ways to streamline a workflow for this. We'll also explore ways to configure Visual Studio Code for seamless Docker/Ansible operations and demonstrate managing Db2 containers for a more efficient and effective development environment. This deep dive into Ansible's provisioning power will arm you with modern tools to revolutionize mainframe development and interaction with Db2 for z/OS.
In this session we'll be exploring the dynamic landscape of Ansible and Db2 for z/OS, redefining development practices through efficient strategies and innovative solutions. It commences with an introduction to Ansible, showcasing its versatility across diverse use cases and highlights the IBM Ansible Z Collection's interface with the mainframe.
The narrative delves into tips and tricks, offering insights to circumvent common challenges and avoid pitfalls, particularly through the usage of REST calls and integrating with Db2. It unravels the process of discovery, illustrating the interaction with Db2 through commands, SQL/DDL, utilities.
Speakers
avatar for Anthony Anter

Anthony Anter

DevOps Architect & Evangelist, BMC Software Inc.
Thursday October 31, 2024 10:20 - 11:20 CET
1 | Breakout 8
  Technical Session

10:20 CET

E16 | Unleashing the potential of Native Cloud Object Storage in Db2 Warehouse
Thursday October 31, 2024 10:20 - 11:20 CET
0 | Auditorium 3B
Native Cloud Object Storage support brings to Db2 Warehouse a significant reduction in cost when compared with Block Storage. But this is not the whole story, Cloud Object Storage also enables increased scalability and availability, and the multi-tier LSM storage layer enables performance and functional benefits.  In this session you will learn about our favorite use cases and features that get the best out of this new feature.

Speakers
avatar for Christian Garcia-Arellano

Christian Garcia-Arellano

STSM, Db2 OLTP Architect and Master Inventor, IBM Canada
Christian Garcia-Arellano is STSM and Db2 OLTP Architect at the IBM Toronto Lab, and has a MSc in Computer Science from the University of Toronto. Christian has been working in various DB2 Kernel development areas since 2001. Initially Christian worked on the development of the self... Read More →
Thursday October 31, 2024 10:20 - 11:20 CET
0 | Auditorium 3B
  Technical Session

10:20 CET

F16 | R.I.P. IBM Data Studio
Thursday October 31, 2024 10:20 - 11:20 CET
1 | Breakout 3 + 4
Data Studio has long been the standard desktop interface for Db2 for z/OS (alongside traditional ISPF). But  with Data Studio support for Db2 for z/OS ceasing in March 2025 what is replacing it?
This session will look at the 2 (free) products that are replacing Data Studio - Db2 Admin Foundation, and the Db2 for zOS Developer Extension for VSCode. We will look at the prereqs for the solution's, discuss the personas that each is targeted at, and look at the functionality available in each product.
If technology is on my side I will also attempt to do a live demo.
Speakers
avatar for Mark Turner

Mark Turner

Db2 Technical Lead and Mainframe Devops Lead, NatWest
Mark Turner is the Senior Technical Lead for Db2, responsible for Db2 strategy and roadmap at NatWest. He has more than 35 years’ experience working with Db2 on z/OS covering many areas including general database administration, Db2 infrastructure design, application and system... Read More →
Thursday October 31, 2024 10:20 - 11:20 CET
1 | Breakout 3 + 4
  Technical Session

10:30 CET

LUW Badging
Thursday October 31, 2024 10:30 - 12:00 CET
1 | Multi 1C
All onsite attendees at IDUG EMEA 2024 are eligible to receive a complimentary LUW badging exam with their paid registration. To register for an exam:
  1. Send an email to badges@idug.org and provide the following information:

    First & Last Name
    Email Address
    Exam Choice
    Day & Time Choice

  2. Select the exam you'd like to take. There are 5 exam choices:

    Db2 11.5 Foundations Exam
    Db2 11.5 Administration Exam
    Db2 11.5 Advanced Database Resilience Exam
    Db2 11.5 Advanced Database Design & Application  
    Development Exam
    Db2 11.5 Advanced Tuning & Debugging Exam
  3. Let us know what time you'll arrive to take the exam. Here are the day/time choices:
Monday:  2:00 PM, 4:00 PM
Tuesday:  10:30 AM, 2:00 PM, 4:00 PM
Wednesday:  10:30 AM, 2:00 PM, 4:00 PM
Thursday:  10:30 AM
 
Please Note:  No walk-ins will be accepted.  You must book in advance and you will receive a confirmation once you are officially booked.  This is a Bring Your Own Device exam.  Photo ID will be required at exam time.
Thursday October 31, 2024 10:30 - 12:00 CET
1 | Multi 1C
  Badging & Certification

11:20 CET

Break
Thursday October 31, 2024 11:20 - 11:30 CET
TBA
Thursday October 31, 2024 11:20 - 11:30 CET
TBA
  Break

11:30 CET

A17 | Unleashing the power of Db2 z/OS profiles tables
Thursday October 31, 2024 11:30 - 12:30 CET
0 | Auditorium 2
This joint presentation by Michal Bialecki and Adam Pesta, "Unleashing the power of Db2 z/OS profile tables" explores the pivotal role of system table profiles (SYSIBM.DSN_PROFILE_*)  in Db2 z/OS database management. Attendees will discover how strategic profile utilization:

enhances availabilility,
fortifies and enforces security for remote clients
allows granular application-level lock control or RELEASE(COMMIT/DEALLOCATE) behavior for both remote and local applications 

The session covers crafting effective profiles, real-world examples, and addresses challenges in profile management. Insightful discussions on future trends empower attendees to leverage Db2 z/OS profiles for transformative outcomes in their database systems.
Speakers
avatar for Adam Pesta

Adam Pesta

Db2 z/OS L2 support, IBM
Adam Pesta is an Db2 z/OS Support Specialist from IBM Poland, currently working remotely for the Silicon Valley Laboratory in San Jose, providing technical support for Db2 for z/OS relational database services. He has more than twenty years of experience with relational databases... Read More →
Thursday October 31, 2024 11:30 - 12:30 CET
0 | Auditorium 2
  Technical Session

11:30 CET

B17 | Accessing open data formats (Parquet, ORC) from Db2: architecture, metadata and integration
Thursday October 31, 2024 11:30 - 12:30 CET
0 | Auditorium 3A
Db2 Warehouse (on prem and on cloud) as well as Db2 11.5 FP9 now allows users to work directly with the datalake tables, using open data file format- Parquet - ORC- Avro- Text and JSON
Presentation will show how Db2 works with the open data formats organized as both Hive and Iceberg tables, how the data is stored internally in the object store and compare this type of data to native Db2 tables. It will also explain topic of metadata and metastore integration with other query engines available in watsonx.data
Speakers
avatar for Kamil Kuduk

Kamil Kuduk

Db2 Advanced Problem Determination, IBM Poland
Working for IBM Db2 in support role for over 10 years. Last few years in the Advanced Problem Determination team, specializing in performance problems and operating system troubleshooting.
Thursday October 31, 2024 11:30 - 12:30 CET
0 | Auditorium 3A
  Technical Session

11:30 CET

C17 | Basics of shell scripting for the Db2 DBA
Thursday October 31, 2024 11:30 - 12:30 CET
1 | Breakout 1 + 2
For work I try to stick to a rule: "Never do something three times!". I do it once, the second time I'm annoyed and for the third time I try to automate it.As I'm currently managing around 40 RHEL servers with nearly 700DBs on it, automation, conventions and rules are key.
In this session I want to show the audience general commands and constructs within shell programming. Givng a method at hand how to fast develop shell scripts and oneliners and some tricks to get around some possible pitfalls on the way.
Speakers
avatar for Sebastian Zok

Sebastian Zok

Senior Database Administrator, Cancom Managed Services GmbH
Sebastian got a diploma in IT in 2007 and started first in software development. He worked on Db2 performance monitoring and switched to Db2 consultancy shortly after. He is working with Db2 LUW since version 7. Currently Sebastian is working for an IT provider as Senior Db2 DBA administering... Read More →
Thursday October 31, 2024 11:30 - 12:30 CET
1 | Breakout 1 + 2
  Technical Session

11:30 CET

D17 | DBAs and Developers Unite! Learning To Use Db2 for z/OS REST APIs
Thursday October 31, 2024 11:30 - 12:30 CET
1 | Breakout 8
RESTful API (Application Programming Interface) support has been introduced to strengthen the position Db2 for z/OS plays in the new mobile application era. This presentation will equip the audience with a solid understanding of REST APIs in general and how to apply them to Db2. Administrators will learn how to create and maintain the services while developers will get familiar with the Db2 specifics.
Speakers
avatar for Denis Tronin

Denis Tronin

Product Manager, Broadcom
Denis Tronin is an experienced IT professional and product manager skilled in mainframe (Db2 for z/OS, System Performance, Workload Automation), API management (Zowe API Mediation Layer) and DevOps domains. He is an IBM champion and an active speaker at major mainframe conference... Read More →
Thursday October 31, 2024 11:30 - 12:30 CET
1 | Breakout 8
  Technical Session

11:30 CET

E17 | All you need to know about accessing Db2 for z/OS data in the cloud
Thursday October 31, 2024 11:30 - 12:30 CET
0 | Auditorium 3B
Every enterprise, with Db2 for z/OS core database, have plans for application and data modernization in the context of Db2 for z/OS. Topics like, Hybrid cloud, data fabric, data lakehouse are all bringing new architectures and product level topics in front of every Db2 DBA and Db2 Sysprog. 
This session prepares all Db2 for z/OS DBAs for the following topics in detail. 

Modernizing direct access to Db2 for z/OS data from the cloud via ODBC, JDBC, Rest APIs 
How analytics infrastructures implemented inside or outside of IBM Z will be managed, administered, and monitored by Db2 DBAs.
What are the virtualization options of the mainframe data and specifically Db2 for z/OS. How the DBA will control this virtualized access? 
How to provision a copy of Db2 for z/OS data in cloud for high-volume query and/or analytics use cases. 
Technical details of Integrated Synchronization which is the essential replication protocol from Db2 for z/OS to the cloud. 
Speakers
avatar for Mehmet Cuneyt Goksu

Mehmet Cuneyt Goksu

Executive IT Specialist, IBM
Cüneyt Göksu is an Executive IT Specialist for IBM® Z solutions in the context of Data and AI in IBM Germany Development Lab as a member of Center of Excellence team. He holds MBA, Bachelor’s degree and PhD in Computer Science. He has been working with IBM Db2® for z/OS and... Read More →
Thursday October 31, 2024 11:30 - 12:30 CET
0 | Auditorium 3B
  Technical Session

11:30 CET

F17 | Db2 and Zowe: Everything, everywhere at once.
Thursday October 31, 2024 11:30 - 12:30 CET
1 | Breakout 3 + 4
Db2 for z/OS is undergoing a seismic shift in its tooling portfolio at the moment, with the sunsetting of Data Studio and DSM, and the emergency of a VS Code plugin stack for desktop developers and a web based suite built around the Admin Foundation offering.  This talk will focus on the VS Code side that leverages The Open Mainframe Project Zowe Explorer and Db2 Developer for z/OS extension to provide a powerful and intuitive way to work with z/OS address spaces, jobs, stored procedures, ad-hoc SQL scripts, and more.   Zowe is fast becoming the new face of z/OS for folks doing mainframe education courses and this talk will cover the Zowe CLI as well as the Db2 CLP showing the differences and overlap and when to choose each one,  as well as the use of Zowe to build out DevOps pipelines to help simplify and automate software agility.
Speakers
avatar for Joe Winchester

Joe Winchester

Senior Technical Staff Member, IBM
I am a Senior Technical Staff Member in the IBM z Systems software group and a leadership member of the zowe.org project,  owned and managed the Open Mainframe Project under the Linux Foundation.  I actively participate in the project as a committer, squad lead, technical steering... Read More →
Thursday October 31, 2024 11:30 - 12:30 CET
1 | Breakout 3 + 4
  Technical Session

12:30 CET

Break
Thursday October 31, 2024 12:30 - 12:40 CET
TBA
Thursday October 31, 2024 12:30 - 12:40 CET
TBA
  Break

12:40 CET

Keynote | Data-Driven Leadership: How to Succeed Where Others Fail – IDUG Women in Technology (WIT), Sponsored by Broadcom
Thursday October 31, 2024 12:40 - 13:45 CET
0 | Auditorium 2
SVP and Chief Pharmacy Officer, Dr. Mary Beth Lang, faced a global pandemic while overseeing an organization of over 15,000 employees impacting the lives of nearly 12.5 million patients. Dr. Lang's reach spans far and she is able to dive deep to resolve many intense issues over the course of her career, earning a reputation as the "fixer".  Join this session to learn how Dr. Lang leveraged her strength in data and analytics, building allyship across organizational boundaries to drive successful outcomes during crises.
Speakers
avatar for Dr. Mary Beth Lang

Dr. Mary Beth Lang

SVP and Chief Pharmacy Officer, Kaiser Permanente
Mary Beth Lang is a visionary transformation leader, who supports the engineering, application, and modernization of advanced technology capabilities to improve clinical excellence, virtual healthcare delivery, purchasing and contracting decisions, operations, and efficiency. Conceived... Read More →
Thursday October 31, 2024 12:40 - 13:45 CET
0 | Auditorium 2
  Keynote, IDUG EMEA VIRTUAL SESSION

13:45 CET

Break
Thursday October 31, 2024 13:45 - 14:30 CET
TBA
Thursday October 31, 2024 13:45 - 14:30 CET
TBA
  Break

14:30 CET

B203 | The next generation of services for Db2 administration and development workshop
Thursday October 31, 2024 14:30 - 18:30 CET
0 | Auditorium 3A
Bring your own device to this workshop, where you will have a chance to perform a hands-on lab to experience the latest deliverables towards Db2 user transformation. 

Db2 administrator personas can execute some of their daily tasks in a more intuitive way via Db2 Administration Foundation and its integration with Db2 Tuning Services, Query Workload Tuner and IDAA Administration services.  Last but not least, administrators can also benefit from Db2 DevOps experience (DBaaS) to “shift-left” database operations to application developers under their rules and administrative directives.
Db2 application developer personas can develop / test and deploy application changes that also require database change in a speed that business demand. Using Db2 Developer Extension in IDE will simplify coding of SQL including native stored procedure code. Using Db2 DevOps Experience services (DBaaS), developers can, on demand, self-service database operations under the rules previously established by the Db2 administrators. 
Speakers
avatar for Sowmya Kameswaran

Sowmya Kameswaran

Technical Leader, IBM
I lead the modernization portfolio for IBM Db2 product line. My charter encompasses product design & development, vendor & customer relationship, external & internal product communication. As part of my leadership role, I mentor and manage full-stack software developers. I am responsible... Read More →
Thursday October 31, 2024 14:30 - 18:30 CET
0 | Auditorium 3A
  Hands-On Lab

14:30 CET

A203 | Db2 Analytics Accelerator for z/OS - Technical Workshop
Thursday October 31, 2024 14:30 - 18:30 CET
1 | Breakout 8
Duration: ½ Day, Classroom Style, No Computers needed.
In this workshop you will get a technical deep dive on latest enhancements in Db2 Analytics Accelerator directly from the Accelerator development organization. We will cover topics such as: 
-         What's new in latest releases including technical details and usage.
-         Deployment and architecture options, migration, and HA/DR best practices.
-         Data load and Integrated Synchronization experiences. 
-         Accelerator on Z monitoring tips. 
-         Query performance best practices
Speakers
avatar for Mehmet Cuneyt Goksu

Mehmet Cuneyt Goksu

Executive IT Specialist, IBM
Cüneyt Göksu is an Executive IT Specialist for IBM® Z solutions in the context of Data and AI in IBM Germany Development Lab as a member of Center of Excellence team. He holds MBA, Bachelor’s degree and PhD in Computer Science. He has been working with IBM Db2® for z/OS and... Read More →
avatar for Ute Baumbach

Ute Baumbach

Member of Analytics on z Systems Center of Excellence, IBM
Ute has been a Software Engineer at the IBM Research and Development Laboratory in Boeblingen, Germany for more than 25 years, where she works in various software development projects and roles. Most of her projects were based on Db2 for Linux, UNIX, and Windows, and Db2 for z/OS... Read More →
Thursday October 31, 2024 14:30 - 18:30 CET
1 | Breakout 8
  Workshop

14:30 CET

C203 | The HADR with Pacemaker for Cloud Deployments Workshop
Thursday October 31, 2024 14:30 - 18:30 CET
0 | Auditorium 3B
Db2 databases support the High Availability needs of many customers today. Db2 v11.5.5.0 saw the general availability of High Availability with Pacemaker on the Linux platform, providing a newer, Cloud-ready alternative to the TSA implementation. Newer releases have added support for AWS, Azure and Google Cloud environments, and many other refinements.
This workshop will give you hands-on experience for managing a Db2 HADR with Pacemaker Cluster on Microsoft Azure, Google Cloud or AWS. The session will cover the Cloud specific Implementation of Fencing and virtual IP Addresses. It will help you understand the information provided by the cluster utilities, across basic operations, diagnostics, and best practices from the IBM Labs This workshop will also demonstrate basic problem scenarios, troubleshooting and collection of essential support data to accelerate problem resolution in emergency cases.
Speakers
avatar for Thomas Rech

Thomas Rech

IT Architect, IBM Germany
Thomas has been working in the Db2 area since 1996. Starting as a Db2 course instructor, he soon moved to the SAP on Db2 environment in 1997. He joined the SAP/IBM Db2 Development Team, followed by a role as technical sales consultant. He led several lighthouse projects like the... Read More →
Thursday October 31, 2024 14:30 - 18:30 CET
0 | Auditorium 3B
  Workshop
 
Share Modal

Share this link via

Or copy link

Filter sessions
Apply filters to sessions.
Sunday, October 27
Monday, October 28
Tuesday, October 29
Wednesday, October 30
Thursday, October 31
0 | Auditorium 2
0 | Auditorium 3A
0 | Auditorium 3B
1 | Breakout 1
1 | Breakout 1 + 2
1 | Breakout 2
1 | Breakout 3
1 | Breakout 3 + 4
1 | Breakout 8
1 | Multi 1A
1 | Multi 1C
1 | Multi 1D
2 | Multipurpose Room / Solution Center
Los Toros at Les Arts
Melia Rooftop
TBA
  • Badging & Certification
  • Break
  • Coffee Break
  • Expert Panel
  • Hands-On Lab
  • IDUG Fundamentals
  • Keynote
  • Lunch
  • Opening Comments
  • Partner-Sponsored Presentation
  • Solution Center
  • Special Event
  • Technical Session
  • Workshop
  • Company
  • BMC
  • Broadcom
  • IBM
  • SEGUS
  • Subject
  • AI / ML
  • AppDev
  • Cross Platform
  • LUW
  • z/OS
  • Area
  • AI and GenAI
  • AI Generation and Machine Learning
  • AppDev
  • Automation
  • Back to Basics
  • Badging & Certification
  • Best Practices
  • Data Movement and Analytics
  • Data Movement and Integration
  • Database Resiliency
  • Db2 Cloud and Warehouse
  • Expert Panel
  • Fundamentals
  • Latest and Features LUW
  • Latest and Features z/OS
  • Machine Learning
  • Modernization in Development
  • Modernization in Operations
  • Performance and Monitoring
  • Security and Compliance
  • User Stories
  • Utilities
  • Working with SQL