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!
Audience: Intermediate clear filter
Monday, October 27
 

11:30am WIB

D2 | Turn red into blue
Monday October 27, 2025 11:30am - 12:30pm WIB
Aristoteles 2
Database migration from one relational database management system to another can be a challenging task and risky for the business.
In this session, we will explain a step-by-step process of a real world BaFin scenario to migrate databases from Oracle to Db2.
In addition to the technical challenges, there are other important tasks that are part of a database migration, such as the assessment of self-developed and third-party software, test concepts, and the automation of data transfer.
We will talk about the most important considerations, migration tools and best practices to ensure a successful migration.
Speaker
OS
Monday October 27, 2025 11:30am - 12:30pm WIB
Aristoteles 2
  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

D3 | Review key enhancements for Db2U in modernizing Db2 containerization footprint.
Monday October 27, 2025 2:00pm - 3:00pm WIB
Aristoteles 2
Come and hear the latest and greatest the Db2 Universal Container (Db2U) has to offer, ready to be deployed to OpenShift, Kubernetes or Cloud Pak for Data that includes AWS/IBM Cloud (SaaS or Self managed), AKS, EKS, ARO, ROSA, SMP/MPP deployments for transactional or analytical workloads.
Speaker
VK
Monday October 27, 2025 2:00pm - 3:00pm WIB
Aristoteles 2
  Track D

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

D4 | Becoming an Expert DBA: Best use of Db2 Features, Improvements & Tips
Monday October 27, 2025 3:20pm - 4:20pm WIB
Aristoteles 2
This session is to share the technical journey for the advance feathers, especially when the database became very complex structure, very active and large OLTP/Warehouse.

- Advanced techniques: Db2 uses advanced techniques such as parallel processing, compression, partitioning, and indexing
- Mixed workload performance optimization
- Data security: Db2 offers modern data security and multi-factor authentication (MFA).
- Query and transaction handling: Db2 can handle complex queries and transactions.
- Encryption
- Federations
- HADR / Resiliency
- Table partitioning
- workload management
Speaker
NA
Monday October 27, 2025 3:20pm - 4:20pm WIB
Aristoteles 2
  Track D

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

C6 | SQL in Action - Mastering & Measuring Data Removal
Tuesday October 28, 2025 10:20am - 11:20am WIB
Leibniz 1/2/3
Effective data removal is a critical aspect of data management in Db2, ensuring optimal performance and compliance with organizational policies. This presentation explores various techniques for data deletion in Db2 like SQL DELETE, stored procedures for delete as well as data rollout with MDC tables or partitioned tables. Addtionally performance measurements of the different options will be shown and attenees will gain insights into best practices and potential pitfalls.
Speaker
MT
Tuesday October 28, 2025 10:20am - 11:20am WIB
Leibniz 1/2/3
  Track C

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

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

D9 | Monitoring the new multi-tier storage architecture when using Native Cloud Object Storage
Tuesday October 28, 2025 4:30pm - 5:30pm WIB
Aristoteles 2
Db2 v11.5.9 introduced a new Native Cloud Object Storage (NCOS) feature for Db2 Warehouse to decouple compute and storage, and improve scalability, reliability, and performance. This feature introduces a new multi-tier storage hierarchy with a local cache to compensate for the difference I/O characteristics of Cloud Object Storage. For this reason, the feature also introduced new monitoring elements that allow the users to see the physical input/output (I/O) activity in each layer. In this talk, we will dive into the new multi-tier storage architecture, and the new monitoring metrics introduced to discover what they cover, how they work, and how they can be used to get useful feedback for your running applications. We'll go through example use cases. Lastly, we’ll explore the enhancements introduced in the latest Db2 V12.1 release.
Speaker
RH
Tuesday October 28, 2025 4:30pm - 5:30pm WIB
Aristoteles 2
  Track E
 
Wednesday, October 29
 

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

10:20am WIB

F10 | How to access Db2 for z/OS and other Z data in the cloud
Wednesday October 29, 2025 10:20am - 11:20am WIB
Aristoteles 3
Every enterprise, with Db2 for z/OS as core database, have application modernization plans in the context of Db2 for z/OS. Topics like, hybrid cloud, data fabric, data lakehouse are all bringing architecture and product level topics in front of the Db2 DBA.
In this presentation following topics will be presented with technical details to prepare a Db2 for z/OS DBA for

What are the possible direct access ways to Db2 for z/OS from the cloud such as JDBC, RestAPI. What are the challenges.
Architectural alternatives to provide Db2 z/OS data into the cloud native applications
Virtualization options to access relational and non-relational mainframe data including Db2 for z/OS, IMS, VSAM
How to provision a copy of Db2 for z/OS data in the cloud for high-volume query and/or analytics use cases.
Differences between direct access, replication, virtualization. Which access method makes more sense with which use case

Technical and business use cases will be presented in this presentation so that Db2 for z/OS DBA will be aware and contribute to the decision making process
Speaker
CG
Wednesday October 29, 2025 10:20am - 11:20am WIB
Aristoteles 3
  Track F

11:30am WIB

F11 | Desperate Measures - How to Relieve the Db2 Optimizer of its Duties
Wednesday October 29, 2025 11:30am - 12:30pm WIB
Aristoteles 3
Optimal query access plans are essential for good database performance and it is the query optimizer's job to choose the best one. However, sometimes even the best statistics or tricky query tuning will produce the access plan you want. Or your application is effectively down, due to a poorly-performing query, and there isn't time to implement best practices. When these situations arise, Db2 optimization profiles and guidelines can be used to correct the access plan and get your application performing well again - quickly. Optimization profiles can specify various aspects of an access plan, can control automatic query rewriting or can control the optimizer's plan search space. Guidelines can be specified with or without modifying your application. This presentation will show you what options are available and how to use them effectively.
Speaker
CZ
Wednesday October 29, 2025 11:30am - 12:30pm WIB
Aristoteles 3
  Track F

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

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

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

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

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

C17 | Restoring Encrypted Db2 LUW Databases in an OpenShift + AWS Ecosystem
Thursday October 30, 2025 11:30am - 12:30pm WIB
Leibniz 1/2/3
This isn't just another restore tutorial. It's a live-fire tale of encrypted Db2 databases, AWS mounts, and GSK gremlins — all tamed in OpenShift’s wild, wild west. Key elements to weave into the hook (without sounding too dry or overly technical):
* Using GSK commands to manage keystore entries (view, add, delete)
* Pulling encrypted backups from S3 and restoring them to EFS-mounted volumes
* A real-world troubleshooting moment (resolved, with one-liner flavor referencing tech stack)
* Running all of this in a containerized OpenShift environment
Speaker
BP
Thursday October 30, 2025 11:30am - 12:30pm WIB
Leibniz 1/2/3
  Track C
 
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