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

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

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
 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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