This 4 hours workshop - knowledge transfer session will be conducted by following presenters: Toine Michielse, Michal Bialecki, Julia Carter, Emil Kotrc, Denis Tronin In the world of Db2 for z/OS, "set it and forget it" is a recipe for performance degradation and wasted storage. As data volumes explode and batch windows shrink, traditional housekeeping—REORG, RUNSTATS, and IMAGE COPY—must evolve from manual chores into a streamlined, automated strategy. This deep-dive workshop provides a comprehensive blueprint for modern Db2 maintenance. We will move past the basics to explore how to balance object availability with optimal performance. Attendees will learn how to leverage the latest utility enhancements to reduce CPU consumption, manage multi-terabyte objects, and ensure that the optimizer always has the "ground truth" through intelligent statistics collection.
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.
Toine Michielse believes the future of the mainframe depends on building bridges – between platforms, between generations, and between past and present ways of working. A four-time IBM Champion and long-time advocate for modernization, Toine has reimagined what it means to be a... Read More →
Sunday September 27, 2026 9:00am - 1:00pm BST Arrabida
4 hours Hands-on-lab workshop (BYOD - Bring Your Own Device) Transition from legacy "green screen" interfaces to a modern, high-performance environment using Visual Studio Code. This workshop provides a deep dive into Zowe Explorer and the Code4z extension pack, streamlining both system and database management. You will learn to handle z/OS core tasks - including dataset and USS file operations, job submission, and CLI terminal commands - alongside essential Db2 DBA tasks like schema management and SQL execution. We will also cover best practices for managing VS Code setups and profiles to ensure your workflow is optimized for daily enterprise use. Master these modern tools to simplify and accelerate your Db2 operations.
Jim Endler is a Sr.Principal Technical Consultant at Broadcom who focuses on helping customers manage and optimize their Db2 for z/OS environments. He works closely with them to improve database performance and modernize operations through automation, ensuring mainframe systems remain... Read More →
Michal Bialecki is a Db2 Technical Consultant at Broadcom, bringing over 20 years of experience to the role. Prior to joining Broadcom in 2025, he spent two decades working remotely for IBM Silicon Valley Lab, where he served as a member of Db2 z/OS Development SWAT team with John... Read More →
Sergei Osadchuk is a Staff Software Engineer at Broadcom with over 10 years of experience in mainframe technologies. Currently based in Prague, he leads the development of the Broadcom Database Management Solutions for Db2 plug-in for Zowe CLI and its accompanying VS Code extension... Read More →
Denis Tronin is an experienced IT professional and product manager, skilled in mainframe technologies (Db2 for z/OS, system performance, workload automation), API management (Zowe API Mediation Layer), and DevOps. He is an IBM Champion and a frequent speaker at major industry con... Read More →
Sunday September 27, 2026 2:00pm - 6:00pm BST Arrabida
As cyber threats grow increasingly sophisticated, ensuring the security of Db2 for z/OS environments is critical to protecting sensitive data and maintaining compliance. This presentation explores a comprehensive security assessment designed to identify vulnerabilities, evaluate access controls, and strengthen configurations. Experts with extensive mainframe experience will review key elements such as grants and permissions, DSNZPARMs, audit policies, and DDF settings, providing detailed findings and actionable recommendations. Attendees will gain insights into optimizing user privileges, securing data, while also preparing for an easier transition to external security. Enhance your security posture and mitigate risks with proven strategies tailored to Db2 for z/OS.
Jørn Thyssen is a Senior Technical Staff Member at Rocket Software, working with mainframe and Db2 tools in customer modernization and performance projects. He has extensive experience with IBM Z and Db2 for z/OS, and collaborates closely with development teams on initiatives involving... Read More →
Monday September 28, 2026 11:30am - 12:30pm BST Arrabida
These two tables, SYSUTILITIES and SYSOBJECTEVENTS, have really became part of my daily inputs since the moment they arrive to my systems. They are recording all the movements related to utilities in your system, so let's start deep diving on them : Which ones are the most CPU consuming The more time consuming The ones that should probably not be running anymore The ones that fail too often The time slots when most of them are running And how to use the information they provide to improve your system.
Db2 for z/OS consultant, Volkswagen Group Services
I am a pure IBM technology person, 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 what I already know.
Monday September 28, 2026 2:00pm - 3:00pm BST Arrabida
This session is about deep dive technical details of how Z data is integrated with other platforms and solutions. This is an architectural, use case and product level technical session. There will be latest news from the zSW Development and Product Management in the context of Data Management, focused on Db2 for z/OS. The goal of this session is
What are data modernization Challenges – Past, Present, Future IBM Z Data and AI Enterprise Architecture Architectural alternatives to provide Db2 for z/OS data into other platforms for data modernization story Core Products, Virtualization, Data Integration and AI Techniques Replicate, Direct Access, Virtualization – Pros & Cons. Technical and Business Use Cases with Capabilities Roadmaps and Future direction of IBM
Cüneyt Göksu is an Executive IT Specialist for IBM® Z solutions in the context of Data and AI in IBM Germany Development Lab as a member of Center of Excellence team. He holds MBA, Bachelor’s degree and PhD in Computer Science. He has been working with Db2 for z/OS and IBM Z... Read More →
This session explores backup and recovery strategies for Db2 for z/OS, emphasizing the critical importance of compliance and recoverability in today’s data-driven world. Attendees will learn about various backup types, tools, and recovery processes, with a focus on creating resilient systems that align with modern compliance requirements. Through use cases, the session will demonstrate how to ensure recoverability, data integrity, minimize downtime, and maintain availability.
Rahul is a Db2 for z/OS professional at Broadcom Inc., working as part of the Db2 tools development team. His work focuses on supporting and evolving database management solutions that power critical enterprise systems.
A former System Programmer and DBA with 17 years in the mainframe space. Currently a Product Owner, dedicated to bridging the gap between software development and the real-world needs of the Db2 z/OS community.
Monday September 28, 2026 4:30pm - 5:30pm BST Arrabida
Db2 and IMS database administrators on IBM Z are increasingly expected to support modern, AI‑enabled business initiatives while continuing to manage complex, mission‑critical transactional environments. Traditional operational workflows—often manual and reliant on deep individual expertise—can limit consistency and scalability as systems evolve. This session introduces IBM Z Database Assistant, which brings agent‑assisted intelligence into Db2 and IMS administration. By combining DBA‑centric AI agents with context‑driven dashboards, the Database Assistant helps DBAs better understand database behavior, evaluate operational impact, and take informed actions—reducing the need for manual interpretation across multiple tools. Attendees will see how natural language interaction can simplify common DBA tasks, how intelligent SQL tuning can improve transactional workload efficiency, and how AI agents can assist with faster problem diagnosis across Db2 and IMS environments.
Architect of IBM Z Database Assistant and Technical Lead for IBM Db2 for z/OS Agent. Experienced in enterprise mainframe systems, modern cloud-native tooling, and emerging agentic workflows. Passionate about bridging Z systems with modernization, driving innovation that brings legacy... Read More →
Tuesday September 29, 2026 10:20am - 11:20am BST Arrabida
This presentation explores the nuances of query parallelism in Db2, focusing on how to effectively tune queries for optimal zIIP exploitation. Attendees will gain insights through real-world query examples that will illustrate these principles in action, showcasing tangible improvements. Additionally, we will discuss how ChatGPT can assist in the query tuning processs. Join me to rediscover the power of parallelism and leverage zIIP processors to their fullest potential.
As Data Evangelist at Swiss Mobiliar in Bern, Switzerland, Thomas is dedicated to optimizing databases and managing database risks. When he's not in the office, he can be found sharing his expertise on database optimization and risk management at various speaking engagements. Thomas... Read More →
Tuesday September 29, 2026 11:30am - 12:30pm BST Arrabida
Many Db2 DBAs treat the z/OS Workload Manager (WLM) as "the system programmer’s problem," but WLM is actually the engine that determines if your SQL succeeds or fails. In this session, we will demystify WLM from a DBA’s perspective. We’ll cover the basics: defining service classes, importance, and goals. You will learn how WLM distinguishes between "local" work (like batch) and "remote" SQL (using enclaves), and why this matters for your daily performance monitoring. We’ll wrap up with simple best practices and a look at how to spot WLM issues before they become outages. Join this session to learn how to speak the language of WLM and ensure your Db2 workload gets the priority it deserves.
Denis Tronin is an experienced IT professional and product manager, skilled in mainframe technologies (Db2 for z/OS, system performance, workload automation), API management (Zowe API Mediation Layer), and DevOps. He is an IBM Champion and a frequent speaker at major industry con... Read More →
Tuesday September 29, 2026 2:00pm - 3:00pm BST Arrabida
The presentation is based on real life BPool tuning process for one of the Ensono clients. The "reverse application analysis" reveals the opportunities the IFCID(199) usage gives to every Db2 SYSPROG. The standard Ensono BPool tuning process presented with a multiple charts.It also was enhanced with IFCID(199) implementation, giving amaizing results. How to use IFCID(199), different characteristics SYNC I/O, ASYNCH I/O, GetPages can be involved into the the analysis uncovering the hidden performance bugs.
Started as a System Programmer for VM/ESA and then z/OS in 1997.With Db2 v4 from 1998.For a couple of years a developer in Cobol, PL/I, REXX (ocasionally is still doing this for admin purposes :-) for a smaller polish software company.In 2005 started my longest carrier span for the... Read More →
Tuesday September 29, 2026 4:30pm - 5:30pm BST Arrabida
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 dependencies, maintenance aspects, some tooling dependencies, and some performance aspects as well as base utilities and system functionalities.
Ute Kleyensteuber is a Principal Product Owner, Senior Infrastructure Engineer and Director 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... Read More →
Wednesday September 30, 2026 10:20am - 11:20am BST Arrabida
OpenTelemetry is rapidly becoming the industry standard for application observability —offering a unified approach across distributed platforms. But did you know that even mainframe applications and subsystems can now be part of this modern observability ecosystem? In this session, we’ll dive into what OpenTelemetry means from a Db2 for z/OS perspective. You’ll learn its core concepts, why they matter for mainframe environments, and how to take your first steps toward OpenTelemetry-based end-to-end monitoring of Db2 for z/OS applications with minimal effort. We’ll also highlight common pitfalls and explain why OpenTelemetry complements — rather than replaces — traditional Db2 monitoring.
Christoph began his career in IBM’s Global Services unit in 1991, working on numerous client engagements — primarily focused on Db2 for z/OS — as an application developer, database administrator, architect, and consultant. Over time, his role evolved into that of a Client Technical... Read More →
Wednesday September 30, 2026 11:30am - 12:30pm BST Arrabida
Db2 for z/OS environments generate thousands of system messages and codes every day, only a small subset of which indicate truly critical conditions. This session focuses on how Db2 DBAs can effectively identify, interpret, and respond to critical events that threaten system availability, data integrity, resource consumption, and security. Starting from the structure and meaning of Db2 messages, reason codes, and return codes, the presentation walks through real-world scenarios such as log space exhaustion, storage shortages, dataset access failures, and recovery-related errors. Attendees will learn how to distinguish symptoms from root causes and how timely detection can prevent hangs, outages, and data loss. The session emphasizes a proactive monitoring and troubleshooting approach based on SYSLOG and Db2 address space analysis. It is aimed at Db2 DBAs who want to strengthen operational resilience, improve incident response, and consistently meet SLA and recovery objectives.
In this session, we'll go back to basics and look at SQL-PL, Db2's built in server-side application logic. We'll take a look at the code constructs and how to leverage in stored procedures, user defined functions and triggers. We'll also look at more complex scenarios like code for a Data Partitioning Feature (DPF) environment. The majority of this session will be looking at and executing source code.
DBA, Db2 technical lead, Les King Learning, Seneca College
Les King is a part-time professor at multiple Ontario Colleges, offering courses in Mathematics, Programming and Data Management. Les has also been an instructor at the University of Toronto in the Mathematics department. Les effectively draws a connection between what the marketplace... Read More →
Wednesday September 30, 2026 4:30pm - 5:30pm BST Arrabida
Think you’re in the elite 1% of Db2 for z/OS pros? Or just starting your journey to the top? Ditch the slides for a high-stakes, 1% Club style tournament! We’ll scale the heights of Db2 knowledge together, from SQL basics to zIIP offloading and hex-level internals. It’s a no-shame game where every wrong answer leads to a deep-dive technical debrief. Come for the fun, stay for the insights, and level up your Db2 skills!
Michal Bialecki is a Db2 Technical Consultant at Broadcom, bringing over 20 years of experience to the role. Prior to joining Broadcom in 2025, he spent two decades working remotely for IBM Silicon Valley Lab, where he served as a member of Db2 z/OS Development SWAT team with John... Read More →
Julia Carter has 20 years' experience with Db2 and is a Db2 Consultant at Broadcom in Europe. Previously she has worked as a Database Administrator for banks in the UK and Mexico. She is a member of the IDUG Content Committee and Global Marketing Committee and is co-host of the IDUG Db2 Table Talk podcasts. Julia has been an IBM Champion for Data and AI since 2020... Read More →
Wednesday September 30, 2026 5:40pm - 6:40pm BST Arrabida
This session is deep dive technical details about Db2 Analytics Accelerator on IBM Z with latest V8 product updates, new capabilities, with migration details. There will be z17 and LinuxONE 5 Migration Experiences with V7 and V8, platform specific details, migration planning and deployment details. Session will contain IBM Z platform specific details z17 and LinuxONE 5, in the context of Accelerator such as machine configuration, CBU and Flex Capacity usage, different architecture alternatives for different business needs including GDPS usage with 2-, 3-, 4- site GDPS alternatives. There will be Lessons Learned from PoCs, current implementations, architecture discussions and health checks.
Cüneyt Göksu is an Executive IT Specialist for IBM® Z solutions in the context of Data and AI in IBM Germany Development Lab as a member of Center of Excellence team. He holds MBA, Bachelor’s degree and PhD in Computer Science. He has been working with Db2 for z/OS and IBM Z... Read More →
There are several flavors of compression in Db2 for z/OS. You can reduce the space required for a table by using data compression. Compressing the data in a table space can significantly reduce the amount of disk space that is needed to store data and can help improve buffer pool performance. You can also compress your indexes to significantly reduce the physical space requirements for most indexes. You can also reduce the size of data in a LOB table space to ensure that the LOB table space and its associated base table space remain available for inserting data. In this presentation you will learn the different algorithms used for compression in Db2, comparing the cost and benefit of each of them. You will learn how to measure the effect of compression, the space savings but also the effect on applications and utility processing and of course the recent changes in the latest versions and function levels of Db2 for z/OS.
Ramon Menendez is a Principal Solution Engineer from BMC Software in Spain, specialized in the DB2 family of products. Started in IT as a QUEL developer and INGRES administrator. Worked for several years for IBM with DB2, mainly in competitive analysis, implementation and performance... Read More →
Thursday October 1, 2026 10:20am - 11:20am BST Arrabida
In this session we will demonstrate how data can be utilized to gain valuable insights into system performance and optimization. We will provide an introduction of the newest and greatest capabilities in visualizing performance data for an easy step in, which can lead to significant performance improvements. The objective of this session is to demonstrate some real-world examples mainly out of Db2 and WLM and how visualizing performance data helped the Performance Teams diagnose performance issues, better perform capacity planning and how attendees can learn easily more about their z/OS /CICS /Db2 environment.
My mainframe career started in 2001 at an independent software vendor in Germany developing tools for Db2. I began as developer for a tool automating Db2 maintenance. Then moving forward as lead for a point in time recovery tool and later added a tool for homogenous system cloning... Read More →
After a few years as a bank clerk, I started my mainframe career in 1987.So next year, I 'm 40 years Mainframe Professional. I began as a developer, then moved to systems engineering and project management at banks and insurance companies. In 1997, I joined my first ISV. Primarily... Read More →
Thursday October 1, 2026 11:30am - 12:30pm BST Arrabida
