Loading…
Welcome to The AI Era Conference 2026: Shaping Tomorrow’s Intelligence Today!

Join us as we navigate the transformative landscape of AI, forge connections, and unlock the potential of tomorrow’s possibilities. Let’s embark on a journey towards a more intelligent future together!
Subject: z/OS clear filter
Sunday, October 26
 

9:00am WIB

A201 | Db2 for z/OS Performance Monitoring and Tuning
Sunday October 26, 2025 9:00am - 1:00pm WIB
Rheinlandsaal C
Are you struggling with Db2 subsystem and application performance? Join this comprehensive workshop to enhance your skills in Db2 performance management, covering everything from foundational concepts to advanced techniques. We will examine the critical Db2 components that influence subsystem and application throughput, and learn how to identify, monitor, and optimize key health indicators. Additionally, we will share best practices for effective performance analysis and demonstrate how modern open tools can simplify these processes. You'll leave with practical knowledge to improve Db2 performance and streamline your tuning efforts.
Speaker
SB
Sunday October 26, 2025 9:00am - 1:00pm WIB
Rheinlandsaal C
  Workshops

9:00am WIB

D201 | Part 1: Db2&You – Getting to - and using - Db2 13 for z/OS
Sunday October 26, 2025 9:00am - 1:00pm WIB
Aristoteles 2
Presented by Paul Bartak and Tom Crocker



This full-day session is divided into two parts. Part One will focus on migration and serviceability, and Part Two will cover DBA and application development topics. Attend both sessions and show your accomplishment by receiving a digital badge!

Generally available since 2022, Db2 13 for z/OS continues to deliver new capabilities, with 72% (and growing) of the capabilities being delivered via the continuous delivery stream. Meanwhile, Db2 12 for z/OS end-of-support is announced for the end of 2025.

Join us for this insightful workshop, constructed by the original Db2 for z/OS Migration Planning Workshop author (V8 – V11). This workshop is designed to help you no matter where you are in the migration lifecycle. If you haven’t started your migration to Db2 13, now is the time to begin, and this workshop can help you to prepare and get started. If you already use Db2 13, chances are there is even more value to gain from this version, and this workshop can show you how.

DBAs, Designers, and Architects will find topics of interest throughout the entire session, while System Programmers may be more interested in the morning sessions and Application Developers the afternoon sessions. The topics are arranged by role to make best use of your time.

Topics will include:
• Migration (with best practices, scripts to assist, and a project plan)

• Serviceability & Resiliency (the highest-ranking category for features within Db2 13)
Speaker
TC
Sunday October 26, 2025 9:00am - 1:00pm WIB
Aristoteles 2
  Workshops

2:00pm WIB

E202 | Infusing Db2 for z/OS with AI: A Hands-on lab with IBM Db2 AI
Sunday October 26, 2025 2:00pm - 6:00pm WIB
Aristoteles 1
Gain hands-on experience with IBM Db2 AI for z/OS, a powerful new offering built on IBM Watson Machine Learning for z/OS. Learn how Db2 AI can:

Optimize SQL statements
Provide Db2 system assessments with expert guidance for tuning your subsystem
Utilize the Distributed Connection Controller to analyze remote workload traffic and generate Db2 profiles for monitoring and controlling remote connection access based on location, user ID, and application name
Monitor system performance with a new performance insight visualization dashboard

Experience the latest enhancements, including improved regression detection, optimized dynamic query processing in SQL optimization, greater flexibility in executing system assessments, and the new profile alert features with an improved scorecard in the Distributed Connection Controller. Additionally, enjoy overall improvements to the user interface for a more seamless experience. Note: Please bring your own laptop.
Speaker
JL
Sunday October 26, 2025 2:00pm - 6:00pm WIB
Aristoteles 1
  Track E
 
Monday, October 27
 

10:20am WIB

A1 | Db2 for z/OS: Trends and Directions
Monday October 27, 2025 10:20am - 11:20am WIB
Rheinlandsaal C
This spotlight session from Db2 for z/OS development will provide essential insight into Db2's strategy and technical direction. Discover the latest enhancements and the significant value they add whilst gaining a clear view of how these innovations fit into the future of Db2 for z/OS. This look to the future will equip you to make important strategic decisions now to position your business at the forefront of IBM's flagship database evolution.
Speaker
HR
Monday October 27, 2025 10:20am - 11:20am WIB
Rheinlandsaal C
  Track A

11:30am WIB

F2 | Strategies for Making Db2 Data Accessible with APIs
Monday October 27, 2025 11:30am - 12:30pm WIB
Aristoteles 3
This session will explore multiple strategies for enabling API access to your Db2 data. We will examine both direct API connections to Db2 and alternative mechanisms for accessing Db2 data through z/OS-enabled APIs. Attendees will gain insights into optimizing data accessibility and enhancing integration capabilities, empowering their applications to interact seamlessly with Db2 resources. Join us to explore practical approaches and best practices for leveraging APIs effectively in your Db2 environment.
Speaker
CC
Monday October 27, 2025 11:30am - 12:30pm WIB
Aristoteles 3
  Track F

11:30am WIB

A2 | Db2 13 for z/OS Experience with new features for Availability, Resilience and Performance
Monday October 27, 2025 11:30am - 12:30pm WIB
Rheinlandsaal C
This single session will introduce and discuss in detail then design point for select new features in Db2 13 for z/OS to improve availability, resilience and performance. Ewhich apply when exploiting: online removal of active log dataset, online migration from PBG UTS to PBR UTS table spaces, ALTER TABLE DATA CAPTURE concurrency enhancement, user controls to improve the ability for SQL DDL operations to succeed and/or reduce application service, RUNSTATS and Page-level Sampling, enhancements to Fast Traversal Block (FTB) feature, virtual and real memory contraction, more open datasets and reduction in number and frequency of DBAT termination.
Speaker
JC
Monday October 27, 2025 11:30am - 12:30pm WIB
Rheinlandsaal C
  Workshops

11:30am WIB

B2 | RUNSTATS Master - reloaded
Monday October 27, 2025 11:30am - 12:30pm WIB
Socrates
Waaaaay back in 2006 I first held a RUNSTATS Master class where everything that RUNSTATS does to help, and hinder(!), us was fully explained. After 18 years it has now become an adult and has been updated right up until the last RUNSTATS change in Db2 13 FL500 with all the changes that have happened since 2006.
This session will show you how RUNSTATS works, when to, and not to, use it and how to use it as good as you can.
Speaker
RB
Monday October 27, 2025 11:30am - 12:30pm WIB
Socrates
  Workshops

2:00pm WIB

A3 | Db2 13 for z/OS - Five Key Features to Drive Performance and Innovation
Monday October 27, 2025 2:00pm - 3:00pm WIB
Rheinlandsaal C
Db2 for z/OS continues to evolve with features that make database management more efficient, scalable, and responsive. Recent enhancements in Db2 for z/OS focus on making database administration more efficient, with tools and features that automate processes, improve performance, and minimize downtime.
Description:
1. Package Validity at Statement Level (FL502 & FL504)

Introduces statement-level package validation.
Valid statements in a package remain executable even when some are invalidated.Enhances performance with incremental binding, reducing the need for full package rebinding.
New catalog table SYSPACKSTMTDEP records package dependencies at the statement level.

2. SQL Data Insights (FL500)

Leverages AI and deep learning with vector-embedding models to enhance query insights.
Functions like AI_ANALOGY, AI_COMMONALITY, and AI_SIMILARITY help detect data patterns, offering cognitive intelligence directly within SQL queries.


3. Current Lock Timeout Register

New CURRENT LOCK TIMEOUT register allows setting lock timeouts at the application or SQL statement level.
Offers better control over lock waits, overriding system-wide defaults for more efficient handling of transaction concurrency.

4. Online Conversion of Tables from PBG to PBR (FL500)

Simplifies online conversion of Partitioned-by-Growth (PBG) tables to Partitioned-by-Range (PBR) tables.
Reduces performance impact with minimal downtime, using ALTER and REORG utilities for smoother conversion.

5. Deadlock Resolution Priority Variable (FL501)

Introduces DEADLOCK_RESOLUTION_PRIORITY to define thread priority for deadlock resolution.
Higher priority threads are less likely to be terminated, enhancing application stability during deadlock situations.

Speakers:
Primary Speaker:
Preetham Kannan

Secondary Speaker:
Vishwa Pratap Thakur
Speaker
PK
Monday October 27, 2025 2:00pm - 3:00pm WIB
Rheinlandsaal C
  Track A

2:00pm WIB

B3 | Key Performance Updates, zSynergy and Best Practices for Db2 for z/OS
Monday October 27, 2025 2:00pm - 3:00pm WIB
Socrates
Db2 for z/OS continues to evolve, delivering enhancements in performance optimization and monitoring. This session will provide a deep dive into:

The latest performance improvements in Db2 13 for z/OS including its synergy with the newest IBM Z technologies.
Practical performance tuning guidance, derived from real-world customer experiences, to address challenges and maximize efficiency.

Attendees will gain insights into key updates, best practices, and expert recommendations to optimize Db2 performance and monitoring in their environments.
Speaker
AH
Monday October 27, 2025 2:00pm - 3:00pm WIB
Socrates
  Track B

3:20pm WIB

A4 | The Latest Db2 13 Online schema evolution and application performance enhancements
Monday October 27, 2025 3:20pm - 4:20pm WIB
Rheinlandsaal C
The session will focus on Db2 13 the invaluable features of the online schema enhancements that can assist DBAs managing their database objects. Each feature listed below will be explored and discussed in detail on what customer pain point is being addressed, best practices when implementing the features, real life customer experiences. Topics incluses,

table space conversion within UTS table space.
Stacking changes.
The userbility enhancements of partition scheme changes within the UTS table space type conversion.
Scalability enhancments for managing data set.
A quick overview and best practice for applicataion using Insert Algorithm 2
Speaker
FV
Monday October 27, 2025 3:20pm - 4:20pm WIB
Rheinlandsaal C
  Track A

3:20pm WIB

B4 | Taming Page Splits: Reduced Stress for DBAs in Db2 13
Monday October 27, 2025 3:20pm - 4:20pm WIB
Socrates
Index page splitting in Db2 for z/OS has long been a source of performance stress for DBAs, particularly in high-volume insert environments. Prior to Db2 13, identifying and resolving these issues was a frustrating process. This session delves into the enhancements introduced in Db2 13 that simplify the management of index page splits. We will explore new capabilities and enhanced real-time statistics provide DBAs with actionable intelligence, enabling them to quickly pinpoint and address problematic page splitting activity. Discover how Db2 13 reduces the stress associated with index performance tuning, offering practical strategies to minimize page splitting and optimize Db2 performance.
This abstract was submitted in GSE Virtual 2025 as well.
Speaker
SP
Monday October 27, 2025 3:20pm - 4:20pm WIB
Socrates
  Track B

3:20pm WIB

E4 | Fear no Threads: Secure and Monitor Db2 Connections with Profile Tables
Monday October 27, 2025 3:20pm - 4:20pm WIB
Aristoteles 1
Managing distributed connections to Db2 and preventing rogue threads from causing issues has become a significant challenge for DBAs. Join this session to learn how to use profile tables to effectively monitor distributed threads and take proactive measures to mitigate the impact of potential threats. Additionally, we will explore an innovative customer application of profiles that controls JDBC connections and redirects specific connections to the appropriate Db2 for z/OS release.
Speaker
TM
Monday October 27, 2025 3:20pm - 4:20pm WIB
Aristoteles 1
  Track E

3:20pm WIB

F4 | Db2 z/OS in a Hybrid Cloud - A Survey of Architecture Options across AWS, Azure, Google and IBM Cloud
Monday October 27, 2025 3:20pm - 4:20pm WIB
Aristoteles 3
Google AlloyDB DualRun or the mainframe connector? AWS DMS for Db2 z/OS or AWS Glue? Azure Host Integration Server or AIS/ADF? Or a best of breed across all of them? Anything IBM has to offer?
The possibilities are endless, and hybrid cloud data architectures are more relevant than ever after recent events where anchors suddenly drop on overseas cables, cloud vendors raise prices and tariffs all of the sudden are a thing again.
This talk reviews options how to build hybrid cloud architectures, reviews technology options provided by all major vendors in this space and summarizes their differences and commonalities.
Speaker
DM
Monday October 27, 2025 3:20pm - 4:20pm WIB
Aristoteles 3
  Track F

4:30pm WIB

A5 | Db2 Analytics Accelerator: product updates, new version V8, and experiences from the customers and health checks
Monday October 27, 2025 4:30pm - 5:30pm WIB
Rheinlandsaal C
This is deep dive technical session about Db2 Analytics Accelerator on IBM Z with latest product updates, including software and new z17 hardware from development and product management perspective.

New release of IDAA is V8. When this session is presented in IDUG EMEA 2025, V8 ESP Program will be completed, product will be GA and speaker will talk about new features and early customer experiences of V8 release.

This session will also contain IBM Z platform specific details (z16 and z17) 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 solid, real experiences and lessons learned during PoCs, production implementations, architecture discussions and health checks
Speaker
CG
Monday October 27, 2025 4:30pm - 5:30pm WIB
Rheinlandsaal C
  Track A

4:30pm WIB

B5 | Build a lightweight monitor to identify SQL workload tuning potential
Monday October 27, 2025 4:30pm - 5:30pm WIB
Socrates
In this session, you will learn how to capture SQL statistics from Db2’s dynamic statement cache and how to combine them with the information from your EXPLAIN tables. The code that we use will be available for download after the session. Discover how to identify the queries that will benefit most from tuning, allowing you to focus your valuable time on those that matter. We start with simple metrics like RID list errors and work our way up to other performance metrics like top consumers, I/O statistics, lock contention, and more. You will learn how to track the performance and resource consumption of a given SQL statement over time, which makes it possible to spot trends. Finally, we will show how to detect access path changes in dynamic SQL workload. This is a common problem in environments with heavy dynamic workload. Something as simple as a single RUNSTATS execution on one of the involved tables can cause unexpected changes to the access path that Db2 chooses. Using historic explain information, these changes become visible, and you can take immediate action.
Speaker
KS
Monday October 27, 2025 4:30pm - 5:30pm WIB
Socrates
  Track B
 
Tuesday, October 28
 

10:20am WIB

A6 | Optimizing SQL Pagination in Db2 for z/OS for Performance Gains
Tuesday October 28, 2025 10:20am - 11:20am WIB
Rheinlandsaal C
SQL pagination or scrolling is a common technique used in many applications (such as CICS, web, mobile) that need to fetch the next n rows to be displayed on the screen. There are multiple ways to achieve this goal and many do not take advantage of the latest enhancements in recent Db2 versions. In this session we will take a look at the traditional pagination approaches and compare them to the latest possibilities. We will discover that in many cases, optimizing pagination approaches can result in performance gains.
Speaker
EK
Tuesday October 28, 2025 10:20am - 11:20am WIB
Rheinlandsaal C
  Track A

10:20am WIB

B6 | Db2 under siege: real-world exploits and defence strategies
Tuesday October 28, 2025 10:20am - 11:20am WIB
Socrates
"Db2 Under Siege: Real-World Exploits and Defence Strategies" examines the evolving threats to IBM’s Db2 database, including SQL injection, privilege escalation, and misconfigurations. The paper highlights real-world attacks and offers practical defense strategies like patch management, encryption, and role-based access controls. It aims to equip IT professionals with the tools to safeguard Db2 environments from emerging cyber threats.
Speaker
DL
Tuesday October 28, 2025 10:20am - 11:20am WIB
Socrates
  Track B

10:20am WIB

E6 | Automating and operationalizing data-driven AI with Db2 SQL Data Insights - new APIs for full control
Tuesday October 28, 2025 10:20am - 11:20am WIB
Aristoteles 1
Db2 for z/OS 13 introduced SQL Data Insights which combines deep learning in artificial intelligence (AI) with advanced IBM Z technologies -- to infuse the Db2 engine with SQL-based semantic queries on user tables and views. The term of large database models (LDMs) in analogy to large language models (LLMs) was introduced to explain how in-database AI can reveal relationships and insights in enterprise data which were previously undiscoverable with SQL. During the past 2 IDUG conferences both the basic principles as well as real business use cases were presented.
The first SQL Data Insights deliveries obviously focussed on outcome rather than on operationalization and automation. 2025 updates closed the gap to manage and administer SQL Data Insights and to deploy models in an automatable, repeatable, and controlled way via APIs. This session explains and demonstrates how these new SQL Data Insights APIs can boost the efficiency when managing and deploying SQL Data Insights models in Db2, from development to production.
Speaker
SE
Tuesday October 28, 2025 10:20am - 11:20am WIB
Aristoteles 1
  Track E

10:20am WIB

F6 | A day in the life of an MFA-enabled Db2 for z/OS DBA
Tuesday October 28, 2025 10:20am - 11:20am WIB
Aristoteles 3
As enterprise security threats evolve, Multi-Factor Authentication (MFA) has become essential for safeguarding access to mission-critical systems like Db2 for z/OS. This session provides an inside look at a day in the life of a Db2 for z/OS administrator navigating an MFA-enabled environment. From securely logging in and managing authentication challenges to executing routine database tasks with enhanced security controls, we’ll examine how MFA impacts daily workflows, troubleshooting, and compliance requirements. Attendees will gain practical insights into best practices, potential challenges, and strategies for balancing security with productivity. Additionally, we’ll explore a range of access methods, from traditional TSO to modern tools like Db2 for z/OS Administration Foundation, SQL Tuning Services, and the Db2 for z/OS Developer Extension for VS Code.
Speaker
JT
Tuesday October 28, 2025 10:20am - 11:20am WIB
Aristoteles 3
  Track F

11:30am WIB

A7 | Db2 13 latest real customer experiences - new functions, best practices and some more…
Tuesday October 28, 2025 11:30am - 12:30pm WIB
Rheinlandsaal C
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.
Speaker
UK
Tuesday October 28, 2025 11:30am - 12:30pm WIB
Rheinlandsaal C
  Track A

11:30am WIB

B7 | Mastering Access Path Management in Db2 for z/OS: Simplify, Optimize, Succeed
Tuesday October 28, 2025 11:30am - 12:30pm WIB
Socrates
The access path chosen by Db2 has a major impact on SQL performance and overall application efficiency. This session offers a quick refresher on access path fundamentals and focuses on best practices for managing access paths across the application lifecycle to ensure stable workload performance. Discover key strategies to keep your applications running smoothly and efficiently.
Speaker
DT
Tuesday October 28, 2025 11:30am - 12:30pm WIB
Socrates
  Track B

11:30am WIB

E7 | Transforming your Db2 image Copies to Data Pipelines for Generative AI
Tuesday October 28, 2025 11:30am - 12:30pm WIB
Aristoteles 1
In the era of generative AI, the ability to efficiently harness and transform vast amounts of data is paramount. This presentation explores an innovative approach to converting Db2 for z/OS image copies into robust data pipelines tailored for generative AI applications. We will delve into the technical intricacies of extracting, loading, and transforming (ELT) processes that enable seamless mainframe data integration with modern AI frameworks. Attendees will gain insights into best practices for data normalization, pipeline automation, and performance optimization. By leveraging these techniques, organizations can unlock the full potential of their historical data, driving advanced AI models and fostering data-driven decision-making. Learn how to bridge the gap between traditional mainframe environments and cutting-edge AI technologies, paving the way for transformative business insights and innovation.
Speaker
ML
Tuesday October 28, 2025 11:30am - 12:30pm WIB
Aristoteles 1
  Track E

11:30am WIB

F7 | Coming back to DSNZPARM roots
Tuesday October 28, 2025 11:30am - 12:30pm WIB
Aristoteles 3
In the past, one of the most required tasks of a Db2 DBA when facing the migration to a new version was to check and review parameters in DSNZPARM module. Along the Db2 versions, some parameters disappeared, some still remain but almost forgotten and new ones are coming out to cover the new functionalities and enhancements developed or to update existing capabilities.
As per Db2 13, there are more than 300 parameters. This seminar reviews the most important parameters, grouped by the Db2 functionalities or areas where they apply and focused on latest Db2 13.
Speaker
MG
Tuesday October 28, 2025 11:30am - 12:30pm WIB
Aristoteles 3
  Track F

2:00pm WIB

A8 | Dynamic SQL Monitoring: Best Practices
Tuesday October 28, 2025 2:00pm - 3:00pm WIB
Rheinlandsaal C
Unlock the power of dynamic SQL with effective monitoring techniques! This session focuses on the versatile EXPLAIN STMTCACHE statement, showcasing best practices and its various options to help you analyze and optimize dynamic SQL performance. You'll learn to gain deeper insights into access paths, quickly identify performance bottlenecks, and elevate your monitoring skills. Whether you're a Db2 expert or new to dynamic SQL, join us to enhance your Db2 environment!
Speaker
MB
Tuesday October 28, 2025 2:00pm - 3:00pm WIB
Rheinlandsaal C
  Track A

2:00pm WIB

B8 | "Run-It-Back" - Db2 for z/OS Development all new "2025 SWAT Tales"
Tuesday October 28, 2025 2:00pm - 3:00pm WIB
Socrates
The session will concentrate on new SWAT team experiences. Various unexpected outcomes and behaviors will be discussed as well has hot technical items customers are exploiting as well as technologies that have been challenging for customers. The complete session will be focused on customer experiences and sharing real life outcomes.
2025 will have topics such as REBIND best practices and lessons learned and various options and what they mean, what zHyperlink, Middleware recovery boosts, asynchronous LOCK1 duplexing
Speaker
AC
Tuesday October 28, 2025 2:00pm - 3:00pm WIB
Socrates
  Track B

2:00pm WIB

E8 | Deep Dive into SQL Data Insights
Tuesday October 28, 2025 2:00pm - 3:00pm WIB
Aristoteles 1
This session addresses a timely and relevant topic in data management and AI: SQL Data Insights (SDI), a new feature in Db2 for z/OS V13, which enables organizations to extract value from their data without requiring extensive data science skills. Building on last year's introductory session, this presentation responds to attendee inquiries about finding use cases, securing management buy-in, resource needs, and model tuning. As most installations are now on V13, this session will equip participants with practical strategies to effectively leverage SDI, driving greater value from their Db2 data. From a technical perspective, we will discuss how data preparation can enhance the accuracy of an SDI model, and from a business perspective, we will assess models based on business metrics such as profit and savings.
Speaker
TB
Tuesday October 28, 2025 2:00pm - 3:00pm WIB
Aristoteles 1
  Track E

2:00pm WIB

F8 | Tales of a DBA with UDFs and Store Procedures
Tuesday October 28, 2025 2:00pm - 3:00pm WIB
Aristoteles 3
I would like to talk about the Stored Procedures from a DBA point of view, as starting points:
- Differences between SP and UDF, and some information about what they are. The different SP and how to check if you have still any External SQL, that is deprecated and how to migrate them to Native.
- How to display their status, checking whether they are started or not, among other things
- How to consult the WLM where they run, and check with the command /D WLM, APPLENV whether its available or not, and how if there’s a problem with the SP, normally you can find the error there, for example if it’s giving some ASUTIME error.
How to check our WLM environments, in order to see if we have them with the right parameters: NUMTCB, MNSPAS, ...
- ZPARM related to them, as the “new” MAX_UDF.
- Talking about the DSNTIJPM Premigration Reports Db2 V13, because Report 19 is for checking the native SQL procedures and compiled SQL created prior to Db2 11. So if you have any, you have to regenerate them before moving to V13. How to check and how to regenerate them. I had to do this for some before moving to V13.
- Show some of the IBM Stored procedures provided by IBM, for example I always use the DSNTEJ6Z installation job- for calling the ADMIN_INFO_SYSPARM and get the ZPARM of any subsystem.
- The ADMIN_INFO_SQL, sometimes you can need it for sending it to IBM support
- The one for doing a WLM_REFRESH (DSNTEJ6W), I find this interesting for example, for giving at Development the option to the developers to do themselves the WLM refresh, only at development, that way they don’t need to ask for the same to Ops or zOS teams.
- Other options that can be discussed with the application are these parameters:
· STOP AFTER SYSTEM DEFAULT FAILURES
· STOP AFTER nn FAILURES
· CONTINUE AFTER FAILURES
. STAY RESIDENT
- The stored procedures to run utilities or execute Db2 commands: DSNUTILU, DSNUTILV, …
- Some interesting provided UDF as the ones at DSNTEJ3U: DAYNAME, CURRENCY, … or the interesting WEATHER.
Mainly the Db2 people hear about a Stored Procedure when there’s a problem. Maybe you are the one also that DROP or CREATE it, but for sure, if any of them starts to consume a lot, or to loop, or to have some trouble, you will be the one contacted for checking where the problem is.
Speaker
SM
Tuesday October 28, 2025 2:00pm - 3:00pm WIB
Aristoteles 3
  Track F

4:30pm WIB

A9 | Db2 System and Application monitoring and alert system approach
Tuesday October 28, 2025 4:30pm - 5:30pm WIB
Rheinlandsaal C
We monitor Db2 systems with Broadcom Detector for Db2 for z/OS and Subsystem Analyzer for Db2 for z/OS products. While monitoring the Db2 system, we also collect the data of these products by loading them into DB2 tables. We store this data, which has been accumulated for more than 10 years, in our statistics warehouse. We keep this data in a separate data sharing and regularly feed it to IDAA.
We have created many different structures on the data in this statistics warehouse.
In our Inhouse developed product, which has been patented for reorg tables, we determine the time when the tables are least used in order to minimize the effect of switch phase.We generate near-real time alarms for worsening sql and dbrms on the data we keep at 15-minute intervals.With the dashboard we have prepared, we can show all the information about DBRM, TRX or batch jobs in Db2, statistics about their past work, table accesses, and which transactions come from which channels.And there are many different structures that we have created based on this. We would be very happy if we could share these structures with everyone and give them ideas.

Speaker
HK
Tuesday October 28, 2025 4:30pm - 5:30pm WIB
Rheinlandsaal C
  Track B

4:30pm WIB

B9 | Protecting your Db2 for z/OS environment from cyber attacks
Tuesday October 28, 2025 4:30pm - 5:30pm WIB
Socrates
Successful cyber-attacks - ransomware attacks in particular - can have a devastating impact to your business. Depending on the individual attack scenario, existing processes to maintain business continuity such as the implementation of GDPS using multiple physical sites may not be able to protect you from these attacks. In this session, we look at options to reduce a potential data loss and the downtime to restore your Db2 for z/OS production environment in the most efficient way to optimize both your Recovery Point Objective (RPO) and Recovery Time Objective (RTO) after a cyber attack.
Speaker
PB
Tuesday October 28, 2025 4:30pm - 5:30pm WIB
Socrates
  Track C

4:30pm WIB

E9 | Unlocking the Power of AI with Db2 for z/OS
Tuesday October 28, 2025 4:30pm - 5:30pm WIB
Aristoteles 1
Db2 for z/OS harnesses the transformative capabilities of AI to unlock value in two critical areas: driving actionable business insights with AI-enhanced SQL queries (SQL Data Insights) and fine-tuning operational efficiency with Db2 AI for z/OS.
In this session, discover how the latest advancements in AI technology within Db2 for z/OS can revolutionize your organization's approach to data – helping you to uncover deeper insights from your data while boosting system performance and reliability. This session also covers how Db2 AI exploitation utilizes IBM Z AI acceleration. Don’t miss the chance to explore the newest features and learn how these innovations are poised to transform both business intelligence and database management for Db2 for z/OS customers.
Speaker
AH
Tuesday October 28, 2025 4:30pm - 5:30pm WIB
Aristoteles 1
  Track F
 
Wednesday, October 29
 

10:20am WIB

A10 | Supercharge Db2 Utilities: Uncover More Features
Wednesday October 29, 2025 10:20am - 11:20am WIB
Rheinlandsaal C
Join this session to gain insights on best proactices for using Broadcom Db2 utilities and explore traditional and emerging use cases, such as intelligent housekeeping, DevOps, test data management, and recovery compliance. You will learn how to get the most value out of the technology you have in your hands.
Speaker
DT
Wednesday October 29, 2025 10:20am - 11:20am WIB
Rheinlandsaal C
  Track A

10:20am WIB

B10 | Db2 for z/OS Tablespace Update
Wednesday October 29, 2025 10:20am - 11:20am WIB
Socrates
Tablespace design is a critical part of a DBAs role in building the physical model for busy database systems. Db2 has gone through some major changes in the last decade that give us more flexibility, availability and capacity. This session will cover the latest features as well as provide some ideas for moving legacy structures into the 21st century.
Speaker
DS
Wednesday October 29, 2025 10:20am - 11:20am WIB
Socrates
  Track B

11:30am WIB

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

11:30am WIB

B11 | Personal Experience: 40 Years of Battle Scars from Managing Db2 for z/OS
Wednesday October 29, 2025 11:30am - 12:30pm WIB
Socrates
Having been a DBA from 1985 to 1995, followed by working in the field with Db2 customers around the world for 30 years, I have come face-to-face with many trials and tribulations. Join this session to experience some of the most interesting battles and learn how partner solutions can augment and complement native Db2 features. You will leave inspired with new ideas to apply in your environment.
Speaker
SR
Wednesday October 29, 2025 11:30am - 12:30pm WIB
Socrates
  Track B

2:00pm WIB

A12 | Db2 for z/OS Utilities – Unveiling recent updates and current developments
Wednesday October 29, 2025 2:00pm - 3:00pm WIB
Rheinlandsaal C
The Db2 for z/OS Utilities team has rolled out a series of innovative features that have significant impacts on data availability, usability, and utility performance, while also introducing utility history support that further empowers automation and optimization in utility execution. In this session, we will dive into these exciting new enhancements, highlighting key features that you can take advantage of today.
Speaker
HR
Wednesday October 29, 2025 2:00pm - 3:00pm WIB
Rheinlandsaal C
  Track A

2:00pm WIB

B12 | in memory table : what did you expect ?
Wednesday October 29, 2025 2:00pm - 3:00pm WIB
Socrates
Reducing CPU Cost is a never ending work. Once your applications, system and bufferpools are well tuned, you need to find new quick wins.
Are « in-memory table » one of them ?
In this presentation we will explore how, in a bank OLTP environment, we tested and implemented « in-memory table » : pros and cons, which tables are eligible, what precautions to take and what results we achieved.
Speaker
LK
Wednesday October 29, 2025 2:00pm - 3:00pm WIB
Socrates
  Track B

2:00pm WIB

E12 | Mastering SQL Performance on IBM Z: Analyzing and Optimizing Queries for Maximum Throughput
Wednesday October 29, 2025 2:00pm - 3:00pm WIB
Aristoteles 1
This session will introduce you to the core concepts of SQL performance tuning on IBM Z systems. We'll explore how to analyze and optimize query execution, access path interpretation, understand different tables used to analyze access paths, BIND/REBIND options, effective Index designs, optimizing complex SQLs and monitoring of SQL performance. We'll learn how to identify and resolve common bottlenecks. We'll cover practical tips and techniques that you can immediately apply to improve the speed of your applications, even if you're new to SQL.
Speaker
SP
Wednesday October 29, 2025 2:00pm - 3:00pm WIB
Aristoteles 1
  Track E

2:00pm WIB

F12 | Enhance Db2 Performance with Mult-Row Processing Techniques
Wednesday October 29, 2025 2:00pm - 3:00pm WIB
Aristoteles 3
Db2 provides many mechanisms to process (INSERT, UPDATE, DELETE, and FETCH) multiple rows of data at a time. This session will provide an overview of these capabilities and provide insight on how to take advantage of them to improve performance and elapsed time in your applications.
Speaker
CC
Wednesday October 29, 2025 2:00pm - 3:00pm WIB
Aristoteles 3
  Track F

4:30pm WIB

A13 | z/OS Expert Panel
Wednesday October 29, 2025 4:30pm - 5:30pm WIB
Rheinlandsaal C
Wednesday October 29, 2025 4:30pm - 5:30pm WIB
Rheinlandsaal C
  Track A

5:40pm WIB

A14 | Tools maintenance our way
Wednesday October 29, 2025 5:40pm - 6:40pm WIB
Rheinlandsaal C
One important task for a Db2 for z/OS sysprog is to install and maintain Db2 tools. Most changes to tools are handled as continuous delivery. Before becoming a sysprog I had no idea how much time could be spent on all these tools. Getting new PTFs, installing them, verifying the changes and sometimes backing out the changes.
We have developed a way to do all this work as smooth as possible. The purpose of this session is to give an overall description of SMP/E, Tools Customizer and our process. You who has never work with tools maintenance will get an insight in the work and you who do this regularly will hopefully get new ideas on how to do it more smoothly.
As of today we only use IBM tooling, but I think this process could be applied to tools from other verdors too.
Speaker
MA
Wednesday October 29, 2025 5:40pm - 6:40pm WIB
Rheinlandsaal C
  Track A

5:40pm WIB

D14 | Db2 for z/OS Security Basics
Wednesday October 29, 2025 5:40pm - 6:40pm WIB
Aristoteles 2
This session will discuss the basics of Db2 for z/OS security and its integration with system Z security capabilities. The basics include identification and authentication process, privilege management, security and audit capabilities in Db2 for z/OS and integration with operating system security capabilities to provide the protection for Db2 for z/OS access.
Speaker
GC
Wednesday October 29, 2025 5:40pm - 6:40pm WIB
Aristoteles 2
  Track D

5:40pm WIB

E14 | The ins and outs of High Performance DBATs
Wednesday October 29, 2025 5:40pm - 6:40pm WIB
Aristoteles 1
High Performance DBATs have been around since Db2 for z/OS Version 10. Yet, they still seem to be a mystery to many people. This presentation will change that. The session will explain what HPDBATs are, what benefits they can bring, when to use them, and what can happen when they are used incorrectly, and how to monitor their usage.
Speaker
BS
Wednesday October 29, 2025 5:40pm - 6:40pm WIB
Aristoteles 1
  Track E

5:40pm WIB

F14 | Create Stored Procedure to 'Reorg Table' including table function for Select Reorg() and REST-Services
Wednesday October 29, 2025 5:40pm - 6:40pm WIB
Aristoteles 3
A lot of people use Data and Tables in Db2 z/OS but don't know about Tablespaces and Utilities. Wouldn't it be nice to reorg or runstats a table via select or by calling a Rest-Service provided by Db2 itself, at least in test and development environments?
We will create a stored procedure as a wrapper for DSNUTILU. Because SPUFI and DSNTEP4 do not support CALL-Statements, we will include that procedure in a function which we can use in Select, so SELECT * FROM TABLE(REORG_TABLE('schema', 'tablename')) becomes valid.While Utilities use Tablespaces, we'll provide a new Api to use Tables instead.
We will also create a Db2-REST-Service which calls our Wrapper. Now almost anybody from all platforms can reorg a table in Db2 - using Ansible or even Excel if we want to.
Reorg is only an example, other Utilities are provided as well.
In fact we'll create a bunch of Procedures to Reorg Tablespace, Reorg Table and save Utility's Sysprint.
Speaker
VB
Wednesday October 29, 2025 5:40pm - 6:40pm WIB
Aristoteles 3
  Track F
 
Thursday, October 30
 

9:00am WIB

A15 | Billions of XMLs! How Do You Manage That?
Thursday October 30, 2025 9:00am - 10:00am WIB
Rheinlandsaal C
As an early adopter of PureXML on both Db2 for z/OS and LUW, we have accumulated a lot of XML over the years. This presentation looks at why we have so much XML and then at some of the challenges of tables with XML columns, focusing on Db2 for z/OS. We then look at different techniques for dealing with some of these challenges.
Speaker
PN
Thursday October 30, 2025 9:00am - 10:00am WIB
Rheinlandsaal C
  Track A

9:00am WIB

B15 | Who’s in Your DB2? Auditing z/OS Like a Mainframe Maestro
Thursday October 30, 2025 9:00am - 10:00am WIB
Socrates
This presentation explores the critical process of auditing IBM DB2 for z/OS database access, focusing on the tools and techniques essential for ensuring security, compliance, and operational integrity. We will examine the role of DB2 audit traces in capturing detailed access and activity data, the implementation of audit policies to enforce organizational standards, and the utilization of System Management Facility (SMF) records—such as SMF Type 102 —for comprehensive monitoring and analysis. Attendees will gain insights into configuring these components effectively, interpreting audit data, and addressing common challenges in mainframe database auditing. Practical examples and best practices will be shared to demonstrate how these mechanisms support regulatory compliance and safeguard sensitive data in a z/OS environment.
Speaker
JT
Thursday October 30, 2025 9:00am - 10:00am WIB
Socrates
  Track B

9:00am WIB

E15 | Achieving Resilience with DORA and Db2 Tools: Enhancing Operational Continuity and Compliance
Thursday October 30, 2025 9:00am - 10:00am WIB
Aristoteles 1
Join us as we explore the DORA regulation and its influence on mainframe operations. Discover how Db2 tools empower organizations to meet DORA's requirements effectively. Learn to create a resilient Db2 environment with proactive monitoring, alerting, and robust backup solutions. We'll share practical tips for DBAs to minimize downtime, enhance recovery times, and strengthen operational continuity, all while ensuring compliance with DORA.
Speaker
JA
Thursday October 30, 2025 9:00am - 10:00am WIB
Aristoteles 1
  Track E

9:00am WIB

F15 | Pedal to The Metal - this is not your Daddy's Accelerator!
Thursday October 30, 2025 9:00am - 10:00am WIB
Aristoteles 3
The IBM Db2 Analytics Accelerator for z/OS(IDAA) has evolved enormously over the last 14 years since its introduction to the DB2 for z/OS world with the result that the IDAA of 2025 is a completely different proposition to customers compared to when it was originally presented to the market back in 2011.
As with many new functions and features of Db2 introduced over the years, it was not love at first with the IDAA, however, it is no longer a stand-alone Netezza appliance with periodic refreshes, limited SQL compatibility and limited use cases. It is in fact a completely different hardware and software solution with multiple deployment options from IFLs on Z, a z/Linux One machine or even in cloud and it is also a completely new software based on the columnar DB2 BLU DW engine.
What this means for customers is that the IDAA of 2025 with lots more functionality and flexibility has become an extremely interesting and feasible solution to the many challenges that customers are facing from classical Analytical applications to Batch processing and OLTP transactions requiring analytical queries on real-time data.
This presentation will provide a brief overview of the changes to IDAA since its introduction explaining what and how these changes make the IDAA a completely different proposition for customers in 2025.
More importantly, the presentation will provide a technical explanation of how you can perform an assessment of your environment to be able to evaluate the potential benefits of IDAA in your shop, or, if you already have an IDAA, how you can identify new candidates for IDAA processing.
Finally, the presentation will provide tips and insights from real-world use cases highlighting not only the benefits but also the errors to avoid and the potential problems that you may encounter when offloading work to IDAA
Speaker
AC
Thursday October 30, 2025 9:00am - 10:00am WIB
Aristoteles 3
  Track F

10:20am WIB

A16 | All about the Db2 Log: Updates, Commits, and Best Practices for Data Integrity
Thursday October 30, 2025 10:20am - 11:20am WIB
Rheinlandsaal C
Ever wonder what happens during a table update in Db2? What occurs after a commit, and how does Db2 ensure data consistency and recoverability? In this presentation, we will explore the Db2 log in detail, examining the processes involved with inserts, deletes, and updates. We will also share best practices to avoid the pitfalls of poor commit practices.
Speaker
EK
Thursday October 30, 2025 10:20am - 11:20am WIB
Rheinlandsaal C
  Track A

10:20am WIB

B16 | ISBANK'S Journey to implement CDC IIDR Remote Capture with a Resilient Architecture
Thursday October 30, 2025 10:20am - 11:20am WIB
Socrates
In this session you will find how ISBANK has implemented CDC IIDR Remote Capture with a resilient architecture. You will find different use cases and how we manage different types of replications, their resource consumptions, and the methods used to optimze those. Finally, we'll show you the dashboard created in Graphana to easily monitor latencies and downtime.
Speaker
OC
Thursday October 30, 2025 10:20am - 11:20am WIB
Socrates
  Track B

10:20am WIB

F16 | Modernizing Db2 for z/OS System Management with Ansible
Thursday October 30, 2025 10:20am - 11:20am WIB
Aristoteles 3
In this session, we will explore how Ansible can be used to modernize Db2 for z/OS system management by automating routine administrative tasks. Db2 System Programmers and DBAs typically perform many day-to-day tasks manually. When these tasks need to be executed across an entire SYSPLEX, they become time-consuming, error-prone, and cumbersome. By utilizing Ansible’s built-in modules and integrating with Db2 RESTful APIs, these processes can be automated, reducing manual effort, and improving accuracy.
This session will focus on:
Introduction to Ansible: A quick start on using Ansible on z/OS, including an overview of Ansible’s built-in modules.
Integration of Db2 RESTful API with Ansible: Demonstrating how to use the Db2 RESTful API with Ansible playbooks to automate common Db2 management tasks.
Practical Use Case: Walkthrough of a real-world example where Ansible playbooks are used to automatically retrieve and compare the Db2 zparm setting from all active Db2 regions, eliminating the need for manual intervention.

Target Audience:

Db2 System Administrators
Db2 DBAs
Mainframe Automation Engineers
IT Operations teams looking to enhance their mainframe automation capabilities.


Key Takeaway :
By the end of this session, attendees will have an understanding of how to write and execute Ansible playbooks on z/OS. This session will empower attendees with the knowledge of modern automation practices that can be applied in their z/OS environments.
Speaker
MK
Thursday October 30, 2025 10:20am - 11:20am WIB
Aristoteles 3
  Track F

11:30am WIB

A17 | Claims, Drains and Automobiles
Thursday October 30, 2025 11:30am - 12:30pm WIB
Rheinlandsaal C
Picture a bustling metropolis: thousands of people crossing streets, driving cars, and getting to work. It would be chaos without traffic lights, police officers, or laws. In Db2 for z/OS, that metropolis is data, transactions, utilities, queries, Units of Work. Claims, Drains, Locks, and Latches are the silent traffic controllers keeping the peace.
This presentation explains these concepts using memorable, amusing, everyday illustrations, and with examples, shows why they matter.
Speaker
MD
Thursday October 30, 2025 11:30am - 12:30pm WIB
Rheinlandsaal C
  Track A

11:30am WIB

B17 | Automating Excellence: Real-world z/OSMF Workflows for Efficient Provisioning and Maintenance (a Db2 Use Case)
Thursday October 30, 2025 11:30am - 12:30pm WIB
Socrates
Discover how z/OSMF workflows are transforming installations and configurations into faster, more cost-effective, and error-free processes. This session highlights the benefits of automation for provisioning, configuration, and maintenance, while addressing common challenges. Learn how to streamline workflows, enhance efficiency, and improve reliability with real-world insights and examples.
Speaker
JR
Thursday October 30, 2025 11:30am - 12:30pm WIB
Socrates
  Track B

11:30am WIB

E17 | Adopting Agile Development Practices with Db2 for z/OS - Customer Perspective
Thursday October 30, 2025 11:30am - 12:30pm WIB
Aristoteles 1
Explore how applications developers can seamlessly leverage self-service tools to make changes, test, commit, push, and automate deployments through a CI/CD pipeline. Such changes typically can only be done within pre-established rules set by DBA and other administrators.
During this session Steven Goedertier of Colruyt Group and Mark Turner of NatWest will share their challenges and benefits from their journey to accelerating delivery of enterprise applications. This includes the process that administrators take to set the framework followed by the steps a developer takes to modify an application, including database changes.
Speaker
SA
Thursday October 30, 2025 11:30am - 12:30pm WIB
Aristoteles 1
  Track E

2:00pm WIB

A203 | Next Generation Services for Db2 for z/OS Administration and Development - Workshop
Thursday October 30, 2025 2:00pm - 6:30pm WIB
Rheinlandsaal C
Join us for an exciting hands-on workshop! Bring your own device, where you will have a chance to dive into the latest features designed to transform the Db2 for z/OS user experience.

Db2 administrator personas can execute some of their daily tasks in a more intuitive way through Db2 Administration Foundation and its integration with Db2 Tuning Services, Query Workload Tuner and IDAA Administration services. Last but not least, administrators can also benefit from Db2 DevOps experience (DBaaS) to “shift-left” database operations to application developers under their rules and administrative directives.
Db2 application developer personas can develop, test and deploy application changes that require database updates, meeting the fast-paced demands of today’s businesses. Using Db2 Developer Extension in an IDE will simplify coding of SQL including native stored procedures. Using Db2 DevOps Experience services (DBaaS), developers can, on demand, self-service database operations under the rules previously established by Db2 administrators.
Speaker
MA
Thursday October 30, 2025 2:00pm - 6:30pm WIB
Rheinlandsaal C
  Workshops
 
From $0.00
AI Era: Shaping Tomorrow’s Intelligence
From $0.00

Get help with the event

Contact event planner Event login
View support guides Find upcoming events
Create an event you'd love to attend!
Explore why organizers choose Sched • Success stories
Event App • Event scheduling • Event registration • Event ticketing • Sched forms • Call for papers • Badges • Conferences
© 2026. SCHED LLC - All rights reserved - Helping events since 2008
Conference Scheduling Software • Privacy • Terms
Share Modal

Share this link via

Or copy link

Filter sessions
Apply filters to sessions.
Saturday, January 4
Sunday, March 16
Saturday, March 22
Sunday, March 23
Thursday, April 24
Tuesday, April 29
Wednesday, April 30
Wednesday, June 25
Thursday, June 26
Friday, June 27
Saturday, June 28
Sunday, June 29
Monday, June 30
Saturday, August 16
Monday, September 1
Thursday, September 4
Tuesday, September 30
Sunday, October 26
Monday, October 27
Tuesday, October 28
Wednesday, October 29
Thursday, October 30
Friday, October 31
Wednesday, November 5
Thursday, November 6
Sunday, November 30
Wednesday, December 31
Thursday, May 14
Monday, June 29
Tuesday, June 30
Aristoteles 1
Aristoteles 2
Aristoteles 3
Aristotle 1
Aristotle 3
Front Desk
Leibniz 1/2/3
MS Rhein Vision
Piedmont
Pool Area
Rheinlandsaal A/B
Rheinlandsaal C
Rheinlandsaal Foyer
Room 201
Socrates
TBA
The Banquet Hall
The Conference Villa
Voltaire 1
Voltaire 2
  • 1-on-1
  • AI in Business
  • AI in Development
  • AI Infrastructure
  • Break
  • Breaks
  • Coffee Break
  • Evening Event
  • Event Kickoff
  • Event Registrations
  • Group A
  • Lunch
  • LUW Essentials
  • Main Stage
  • PSP
  • Reception
  • RUG Leaders
  • Staff Stuff
  • Track A
  • Track B
  • Track C
  • Track D
  • Track E
  • Track F
  • Workshops
  • z/OS Essentials
  • Audience
  • All
  • Beginner
  • Intermediate
  • Level 1
  • Level 2
  • Subject
  • AI / ML
  • AppDev
  • Cross Platform
  • LUW
  • z/OS
  • Popular