IDUG EMEA 2024: Full Schedule

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

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

Subject LUW
Area Latest and Features LUW

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

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

Subject AI / ML
Area AI and GenAI, Machine Learning, Latest and Features LUW

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

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

Subject z/OS
Area Data Movement and Analytics, Working with SQL, Latest and Features LUW, User Stories

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

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

Subject LUW
Area Latest and Features LUW, Security and Compliance

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

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

Subject LUW
Area Best Practices, Modernization in Operations, Modernization in Development, Latest and Features LUW, Db2 Cloud and Warehouse

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

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

Subject LUW
Area Back to Basics, Utilities, Database Resiliency, Best Practices, Modernization in Development, Latest and Features LUW, Db2 Cloud and Warehouse

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

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

Subject LUW
Area Database Resiliency, Latest and Features LUW

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

Mike Springgay

Db2 Architect, IBM

Tuesday October 29, 2024 11:30 - 12:30 CET
0 | Auditorium 3A

Technical Session

Subject LUW
Area AppDev, Working with SQL, Latest and Features LUW

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

Liam Finnie

Senior Software Developer, IBM

Tuesday October 29, 2024 11:30 - 12:30 CET
1 | Breakout 8

Technical Session

Subject z/OS
Area AI and GenAI, Machine Learning, Latest and Features LUW

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

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

Subject LUW
Area Data Movement and Analytics, Latest and Features LUW, Db2 Cloud and Warehouse

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

Toby Haynes

Senior Software Developer, IBM Canada

Tuesday October 29, 2024 16:30 - 17:30 CET
0 | Auditorium 3A

Technical Session

Subject LUW
Area Database Resiliency, Latest and Features LUW

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

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

Subject LUW
Area Utilities, Latest and Features LUW

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

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

Subject LUW
Area Best Practices, Performance and Monitoring, Latest and Features LUW

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

Michael Roecken

Senior Software Developer, IBM Canada Ltd.

Thursday October 31, 2024 10:20 - 11:20 CET
0 | Auditorium 3A

Technical Session, IDUG EMEA VIRTUAL SESSION

Subject LUW
Area Best Practices, Performance and Monitoring, Modernization in Development, Latest and Features LUW

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

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

Subject LUW
Area Data Movement and Integration, Data Movement and Analytics, Latest and Features LUW, Db2 Cloud and Warehouse

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

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

Subject LUW
Area Database Resiliency, Modernization in Operations, Latest and Features LUW