Loading…
Simple
Expanded
Grid
By Venue
Map
strong>LUW [clear filter]
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

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

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
 
Monday, October 28
 

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

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

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

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: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

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: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

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
 
Tuesday, October 29
 

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: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: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

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

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

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

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: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

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
 
Wednesday, October 30
 

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

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: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: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

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

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

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

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: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

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: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

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
 
Thursday, October 31
 

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

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

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: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: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

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