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

C201 | Hands-On: Building AI Systems with IBM Db2
Sunday October 26, 2025 9:00am - 1:00pm WIB
Leibniz 1/2/3
IBM Db2 offers a wide range of AI features, both built-in and external tools, for creating AI systems and solutions. These include over 200 built-in AI stored procedures and tools that work seamlessly with open-source AI ecosystems. In this workshop, participants will explore Db2’s AI support and use a selection of these features to implement practical AI models. The workshop consists of two parts. In the first module, participants will learn how to develop a supervised AI model using Db2’s built-in AI stored procedures. The entire model development and usage will be done using SQL within the database. In the second module, participants will learn how to create a Python model using popular Python packages outside of the database, and then deploy that model back into a Db2 database. By the end of the workshop, participants will have gained fundamental skills and hands-on experience in utilizing these AI capabilities. They will be able to apply these skills to their future AI projects. This workshop is designed to be beginner-friendly and does not require participants to have extensive knowledge in AI. Basic SQL skills and some Python programming skills are sufficient for attending and benefiting from this workshop.
Speaker
SQ
Sunday October 26, 2025 9:00am - 1:00pm WIB
Leibniz 1/2/3
  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
 
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

10:20am WIB

C1 | Db2 Latest from the Lab
Monday October 27, 2025 10:20am - 11:20am WIB
Leibniz 1/2/3
Both an overview and a deep dive of recently shipped / announced Db2 content, and then a look into what is coming soon.
Speaker
MS
Monday October 27, 2025 10:20am - 11:20am WIB
Leibniz 1/2/3
  Track C

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

C2 | Latest from the Lab on Db2 Warehousing + Lakehouse
Monday October 27, 2025 11:30am - 12:30pm WIB
Leibniz 1/2/3
Learn about our vision for Data Warehousing + Lakehouse with Db2 and cover exciting new features and improvements in the latest releases.
Speaker
DK
Monday October 27, 2025 11:30am - 12:30pm WIB
Leibniz 1/2/3
  Workshops

11:30am WIB

E2 | Performing Db2 HADR Upgrades Made Even More Easy
Monday October 27, 2025 11:30am - 12:30pm WIB
Aristoteles 1
Moving to a new version of Db2 should not be a scary event for databases using the high availability disaster recovery (HADR) feature. Fear of an outage or re-initialization of your standby is no longer a concern. New in our upcoming release, allow read only access on your standby while upgrading the primary.
This presentation will introduce to you and detail the procedures to perform a major release upgrade of your HADR single standby, HADR multiple standby and HADR pureScale databases. A detailed step by step analysis, with examples, from start to end so that you can get your database to the latest version of Db2 with the least amount of concern.
Speaker
MR
Monday October 27, 2025 11:30am - 12:30pm WIB
Aristoteles 1
  Workshops

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

2:00pm WIB

C3 | The evolution of the AI Query Tuner agent behind DBAssist
Monday October 27, 2025 2:00pm - 3:00pm WIB
Leibniz 1/2/3
This presentation Is a preview of the AI Query tuner. Given a query, relevant information will be provided related to hot spots in the Query Execution Plan along with some recommendations on how one could improve the performance of the query. The functionality involves analyzing the plan and doing a sensitivity analysis to provide recommendations. Analysis using AI models and feedback information will be added to refine the recommendations.
Speaker
CZ
Monday October 27, 2025 2:00pm - 3:00pm WIB
Leibniz 1/2/3
  Track C

2:00pm WIB

E3 | DB2 Universal Translator between z/OS and LUW
Monday October 27, 2025 2:00pm - 3:00pm WIB
Aristoteles 1
The intent of this presentation is to allow DBAs with either Db2 z/OS or Db2 LUW skills apply thier knowledge to the other Db2 platform. There is a lot of commonality between these versions of Db2, however there are some huge differences. Deployment models, differences in functionality and how each is structured will be explained in detail.
Speaker
DM
Monday October 27, 2025 2:00pm - 3:00pm WIB
Aristoteles 1
  Track E

2:00pm WIB

F3 | Db2 12.1: Ready for Workloads and Deployments of the Future
Monday October 27, 2025 2:00pm - 3:00pm WIB
Aristoteles 3
Welcome to Db2 12.1 ! In this session we will walk through the many investments Db2 has made to ensure Db2 is ready for modern workloads and deployments. Modern workloads includes capabilities such as mixed workloads, multi-model capabilities, NoSQL capabilities, enabling columar to handle all types of analytic workloads, AI/ML capabilities and more. Modern deployments includes our SaaS capabilities, containerization investments, capabilities to integrate Db2 12.1 into a Lakehouse environment to be ready for AI projects and deployment options and more. This is a good session for all Db2 users who are working to take modernization steps in their environments.
Speaker
LK
Monday October 27, 2025 2:00pm - 3:00pm WIB
Aristoteles 3
  Track F

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

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

C5 | Db2 Availability & Recovery: 12.1 Highlights of What's New
Monday October 27, 2025 4:30pm - 5:30pm WIB
Leibniz 1/2/3
In the ever-evolving landscape of database management, ensuring the availability and swift recovery of critical data has become paramount. This presentation dives into the latest enhancements that can be found since the release of Db2 Version 12.1, including all new content released and planned in 2025. We will also provide a glimpse into what’s upcoming in the near future in availability and recovery to help you get the most out of your investment and defend against potential disruptions.
Speaker
MR
Monday October 27, 2025 4:30pm - 5:30pm WIB
Leibniz 1/2/3
  Track C

4:30pm WIB

D5 | Range Partitioning - Overview, Use cases, Tips and Tricks
Monday October 27, 2025 4:30pm - 5:30pm WIB
Aristoteles 2
Db2 range partitioned tables are used for various purposes. They address performance aspects but also they can be used to overcome Db2 limits like the size of Large Binary Objects (LOBs) within a table. The session will introduce into the concepts and showcase some examples e.g.: how to introduce hash partitioning with ranges; how to introduce range partitioning without data movement and gives a cheat sheet for an emergency and how range partitioned tables can help.
Speaker
CL
Monday October 27, 2025 4:30pm - 5:30pm WIB
Aristoteles 2
  Track D

4:30pm WIB

E5 | User Experiences with Pacemaker
Monday October 27, 2025 4:30pm - 5:30pm WIB
Aristoteles 1
The purpose of this presentation, most of all, is to talk about the experiences with Pacemaker used in different configuration options, such as HADR and Mutual Failover. But we will start at the beginning, describing what exactly Pacemaker is, how it compares to older technology (TSAMP), and explain the differences between those different configuration options (HADR, MF) and their advantages and disadvantages.
Speaker
DW
Monday October 27, 2025 4:30pm - 5:30pm WIB
Aristoteles 1
  Track E

4:30pm WIB

F5 | SQL Joins - In Depth
Monday October 27, 2025 4:30pm - 5:30pm WIB
Aristoteles 3
The joining of two or more tables in SQL is a great feature of the SQL language. So often we need to combine data from more than one table into the same row output. Depending on your logic needed, the language provides us with different types of joins. This presentation starts off basic and builds into more in-depth logic and performance when having the need to process more than one table in a query. The different types of joins presented are:
Inner Joins (Inner join vs comma delimited syntax)
Left Outer Joins
Right Outer Joins
Full Outer Joins
Outer Joins with 'On clause Extensions'
Self Joins (Same table in FROM clause more than once)
This presentation will:
Take you deeper into SQL join logicHelp udertstand when specific joins are needed Understand the performance of joinsUnderstand 'On Clause Extensions' and when to use themUnderstand the need for the same table in FROM clause more than once *Self Joins)
Speaker
TA
Monday October 27, 2025 4:30pm - 5:30pm WIB
Aristoteles 3
  Track F
 
Tuesday, October 28
 

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

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

C7 | Tuning Queries for Performance Using Examples
Tuesday October 28, 2025 11:30am - 12:30pm WIB
Leibniz 1/2/3
This session looks at various examples of poor performing queries in order to show how query performance can be improved. It covers both row oriented tables and column oriented tables. Some of these aspects will be part of the recommendations in the AI Query tuner.
Speaker
CZ
Tuesday October 28, 2025 11:30am - 12:30pm WIB
Leibniz 1/2/3
  Track C

11:30am WIB

D7 | Db2 – the database of choice for High Availability in a Hybrid/Multi-Cloud Environment
Tuesday October 28, 2025 11:30am - 12:30pm WIB
Aristoteles 2
It is evident from recent market reports that the Hybrid/Multi-Cloud market size is in billions of dollars and growing. Reliability and High Availability are amongst the factors that are driving this growth. Indeed, there are numerous recent examples of one of the major public clouds going offline for a number of hours. Indeed, this is a concern one of our customers came to us with – can Db2 be used for HA across multiple clouds? The answer was, yes, absolutely! In this presentation, we showcase Db2 as the database of choice in a Hybrid/Multi-Cloud environment to provide high availability using the HADR feature. We show how workloads can very quickly and efficiently be moved between different cloud environments in case the primary cloud environment becomes offline, sharing hints, tips, and gotchas along the way. We will look at primarily two use cases – the first involves the primary being on-premises and standbys being on multiple public clouds (for example, AWS, Azure, GCP). The second use case is an all-cloud environment, with the primary being one of the public clouds and standbys being on other multiple public clouds.
Speaker
DW
Tuesday October 28, 2025 11:30am - 12:30pm WIB
Aristoteles 2
  Track D

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

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

D8 | Exploring GenAI, RAG, and Semantic Search with Db2 12.1’s Vector Store
Tuesday October 28, 2025 2:00pm - 3:00pm WIB
Aristoteles 2
Db2 continues its foray into the world of generative AI with the ability to store and work with vector data. This enables use cases, such as retrieval-augmented generation (RAG), a popular AI framework that combines information retrieval with large language models (LLMs). In this session you’ll learn about vector databases, LLMs, embeddings, RAG, semantic search, and how Db2 brings these concepts to data in your database.
Speaker
MM
Tuesday October 28, 2025 2:00pm - 3:00pm WIB
Aristoteles 2
  Track D

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

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

C9 | Db2 Performance and Tuning
Tuesday October 28, 2025 4:30pm - 5:30pm WIB
Leibniz 1/2/3
This presentation will cover over 25 years of Db2 performance and tuning tips, techniques and recommendations using Db2 provided monitoring and tuning facilities. Setting recommendations will be provided for DBM, DB CFG parameters, registry settings and bufferpools. Recommendations will be based on actual production examples. SQL monitoring and Tuning facilities will be discussed and examples and recommendations provided. OS RAM and CPU monitoring will be discussed and recommendations provided .
Speaker
PG
Tuesday October 28, 2025 4:30pm - 5:30pm WIB
Leibniz 1/2/3
  Track D

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

4:30pm WIB

F9 | Modernize Db2 for z/OS Development with VS Code
Tuesday October 28, 2025 4:30pm - 5:30pm WIB
Aristoteles 3
In this session, discover how to leverage VS Code, one of the most popular Integrated Development Environments (IDE), for Db2 for z/OS development. Using a sample CICS DB2 COBOL application, you’ll learn to check out code from SCM, fix errors, and utilize debugging tools for a thorough walkthrough. We’ll also set up a test script for further evaluation before deploying the application to the CICS region for final testing—all within VS Code. Enhance your skills and streamline your development process!
Speaker
SD
Tuesday October 28, 2025 4:30pm - 5:30pm WIB
Aristoteles 3
  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

C10 | Evolution of Db2 into Cloud environments at Allianz.AT!
Wednesday October 29, 2025 10:20am - 11:20am WIB
Leibniz 1/2/3
ABS is the one of the core insurance applications used in Allianz insurance entities worldwide running on Db2 on Linux. Because of Allianz's strategy to migrate all systems to cloud where possible, it had to be investigated how to move ABS to the cloud. A First step was to use a lift and shift approach, where an ABS backend was created as an EC2 instance. But the target is to have a Db2 service as native cloud service available that meets the customer specific requirements specially in relation to ABS because currently available SaaS services failed on this. This presentation describes how various challenges have to be addressed to achieve this.
Speaker
HW
Wednesday October 29, 2025 10:20am - 11:20am WIB
Leibniz 1/2/3
  Track C

10:20am WIB

D10 | Working with EXPLAIN - Alternatives to Command line and Visual Explain
Wednesday October 29, 2025 10:20am - 11:20am WIB
Aristoteles 2
Being a Db2 consultant for more than 25 years I often face the challenge that I had to use EXPLAIN as part of a Performance analysis.
Now we have Tools like Visual Explain in IBM Data Studio and Data Management Console (DMC) as well as db2exfmt and db2caem as command line tools - but what do I do when I have no IBM Data Studio or DMC around and no access to a Db2 command line?
In my presentation I will show how to do EXPLAIN on a SQL statement and analyze the SQL Access Plan from within almost any SQL Frontend tool (DBeaver, Squirrel, DBVisualizer and others)
I will show that for

"normal" EXPLAIN
EXPLAIN from a Section in Package Cache or Sections in Activity Event Monitor tables
EXPLAIN with Section Actuals
and more ...

Speaker
JK
Wednesday October 29, 2025 10:20am - 11:20am WIB
Aristoteles 2
  Track D

10:20am WIB

E10 | A Deep dive into Db2 Connect Best Practices
Wednesday October 29, 2025 10:20am - 11:20am WIB
Aristoteles 1
This presentation will deep dive into Db2 Connect best practices right from determining the type of connectivity between application and Db2 for z/OS / Db2 for LUW, choosing the right driver package, installation and licensing methods. This topic will also recommend the configuration parameters to get best performance and security for your applications.
This will discuss the effective configuration methods for high availability/workload environments such as Sysplex, Purescale using Db2 Connect drivers. Best practices to follow in application development/coding while using Db2 Connect drivers is also an important part of this topic.
Speaker
SM
Wednesday October 29, 2025 10:20am - 11:20am WIB
Aristoteles 1
  Track E

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

11:30am WIB

C11 | DB2 Always on architecture
Wednesday October 29, 2025 11:30am - 12:30pm WIB
Leibniz 1/2/3
In this presentation we will discuss what is required to build an "always on" architecture. This is not limited to Db2 LUW, but rather spans the entire software and hardware stack. Systems are only as reliable as thier weakest point, so how to we work around this limitation? Technology is the easiest part of an Always On architecture, so what makes it so difficult to implement? There are many aspects that need to examined such as:
Can the "CAP" theorem be disproved? Stop by this presentation and find out for yourself.
Speaker
DM
Wednesday October 29, 2025 11:30am - 12:30pm WIB
Leibniz 1/2/3
  Track C

11:30am WIB

D11 | Using GenAI to quickly build Db2 live monitoring
Wednesday October 29, 2025 11:30am - 12:30pm WIB
Aristoteles 2
With the use of GenAI functionality, more and more available to users, this session will show ways of implementing Db2 live monitoring. It will furthermore show advantages and disadvantages of such GenAI approaches, when trying to use specialties of Db2.
Some live demonstration will offer an overview of potential problems and workarounds.
Speaker
MH
Wednesday October 29, 2025 11:30am - 12:30pm WIB
Aristoteles 2
  Track D

11:30am WIB

E11 | The Db2 for z/OS Agent - Lets have a Chat with the Catalog!
Wednesday October 29, 2025 11:30am - 12:30pm WIB
Aristoteles 1
Agents and Agentic AI are all the rage, but what can I do with Agents and Db2? How are agents built? Can they help with DBA tasks? How can I build agentic applications that need Db2 z/OS data?
We will try to answer these questions, alongside a description of the journey we have been on so far to explore the possibilities agentic AI opened for Db2 for z/OS.
Speaker
DM
Wednesday October 29, 2025 11:30am - 12:30pm WIB
Aristoteles 1
  Track E

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

C12 | Db2 and S3 Object Storage : Why? What? How?
Wednesday October 29, 2025 2:00pm - 3:00pm WIB
Leibniz 1/2/3
Over the last few years, IBM has built in more exploitation of S3 object storage into Db2. This presentation explores why this is important to customers, what can be done with S3 in Db2 and how to achieve it. It will also look at pros and cons of using S3 as compared to more traditional methods.
Speaker
PN
Wednesday October 29, 2025 2:00pm - 3:00pm WIB
Leibniz 1/2/3
  Track C

2:00pm WIB

D12 | V12 Db2 SQL Extensions: Tenant, Vectors, Lakehouse and more
Wednesday October 29, 2025 2:00pm - 3:00pm WIB
Aristoteles 2
A look at the new SQL capabilites added to Db2 v12 and its mod packs as well as what is coming in future mod packs. Will also take a look back at some of the lesser known additions in 11.1 and 11.5 mod packs. A deep dive into new namespace isolation capabilities provided via the TENANT concept. A overview of the Vector store extensions both delivered and coming to Db2 and a look at how Db2 can integrate into a lakehouse strategy.
Speaker
MS
Wednesday October 29, 2025 2:00pm - 3:00pm WIB
Aristoteles 2
  Track D

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

4:30pm WIB

B13 | Db2 Basics: An introduction to External Tables including remote storage 💾
Wednesday October 29, 2025 4:30pm - 5:30pm WIB
Socrates
Learn about External Tables in Db2 and how to use them to load and unload data. By utilizing the remote storage option, External Tables (and Db2!) can be a building data lake and lakehouse architectures.
Speaker
HL
Wednesday October 29, 2025 4:30pm - 5:30pm WIB
Socrates
  Track B

4:30pm WIB

D13 | Db2 for Agentic AI: New Capabilities, Frameworks, and Real-World Use Cases
Wednesday October 29, 2025 4:30pm - 5:30pm WIB
Aristoteles 2
Many enterprise AI projects still rely on moving data out of databases into separate systems for training and inference. This often adds delays, increases risk, and makes it harder to maintain secure and reliable applications. Db2 takes a different approach. It has long supported in-database machine learning and AI, and it continues to evolve. New features—such as vector search, model inference, and integration with AI frameworks—make Db2 well-suited for building modern enterprise AI systems. In this talk, I’ll walk through the AI capabilities available in Db2 today—both existing and newly added. I’ll show how they help teams build AI applications more efficiently, keep data secure, and reduce complexity across the stack. A special focus will be on how these features enable the development of modern AI agents—applications that combine reasoning, retrieval, and structured data to solve real business problems inside the enterprise.
Speaker
SQ
Wednesday October 29, 2025 4:30pm - 5:30pm WIB
Aristoteles 2
  Track D

4:30pm WIB

E13 | Here's Looking at YOU, Db2!
Wednesday October 29, 2025 4:30pm - 5:30pm WIB
Aristoteles 1
There are many tools to gather information and many ways to monitor things as they happen in Db2.
What works best?
This presentation will look at what works best in what scenarios, which tools are deprecated, and which are still being improved. What things should we be looking at? What should we be running to gather historical data, and what tools should we have near the top of our toolbox for emergencies? Since no one tool is best in all scenarios, we will try to present use cases that demonstrate when to reach for which tool.
Speaker
KS
Wednesday October 29, 2025 4:30pm - 5:30pm WIB
Aristoteles 1
  Track E

4:30pm WIB

F13 | Unusual indexes and their usage in Db2
Wednesday October 29, 2025 4:30pm - 5:30pm WIB
Aristoteles 3
Indexes in Db2 cannot only index simple relational columns to speed up scans and joins, but it is also possible to index more complicated data like JSON or XML documents or spatial data. Indexes can also be built on expressions. This presentation not only looks at these more unsual indexes and how they can be used to speed up queries, but also investigates index variations like Multi-Dimentional Clustering indexes and index processing techniques like index anding and index oring.
Speaker
AW
Wednesday October 29, 2025 4:30pm - 5:30pm WIB
Aristoteles 3
  Track F

5:40pm WIB

C14 | LUW Expert Panel
Wednesday October 29, 2025 5:40pm - 6:40pm WIB
Rheinlandsaal C
Wednesday October 29, 2025 5:40pm - 6:40pm WIB
Rheinlandsaal C
  Track C

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

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

C15 | A Db2 governance solution with a modern twist
Thursday October 30, 2025 9:00am - 10:00am WIB
Leibniz 1/2/3
A story of a solution, that collects information of the hosts our Db2 servers run on, the instances, databases etc using an Ansible Automation Platform, presents the information using a Node.js application and provides it to other consumers for all sorts of compliance/capacity/cost management reports that are always up to date. It is also an experiment of new features like using a JSON Web token for database connection.
Speaker
PH
Thursday October 30, 2025 9:00am - 10:00am WIB
Leibniz 1/2/3
  Track C

9:00am WIB

D15 | Taking Db2 pureScale to the next level, deploying on z/Linux or LinuxONE
Thursday October 30, 2025 9:00am - 10:00am WIB
Aristoteles 2
Db2 pureScale is the functional equalivent of Db2 z/OS sysplex. PureScale is now available on z/Linux and LinuxONE environments. We will discuss some of the unique requires for deploying Db2 LUW in this environment and what benefits customers could achieve.
Speaker
DM
Thursday October 30, 2025 9:00am - 10:00am WIB
Aristoteles 2
  Track D

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

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

C16 | Db2 V12.1.x: New Security Features and Changes
Thursday October 30, 2025 10:20am - 11:20am WIB
Leibniz 1/2/3
Db2 LUW V12.1 Modpack 1 and 2 have multiple changes in the area of security and this session will highlight everything new. This includes features such as alternative mask-at-read masking behaviour, new monitoring metrics for TLS encryption, and further enhancements enhancements to audit and tablespace administration. Db2 V12.1.2 also addresses world-writable permissions for files and directories in Db2. Be sure to attend to learn about all of these changes.
Speaker
NP
Thursday October 30, 2025 10:20am - 11:20am WIB
Leibniz 1/2/3
  Track C

10:20am WIB

D16 | BACKUP/RESTORE performance insights.
Thursday October 30, 2025 10:20am - 11:20am WIB
Aristoteles 2
The presentation goes through a real case of backup/restore performance improvement challenge for multi-terabyte DB (20+Tb) and offers a general approach of how to analyse ongoing backup/restore processes and how to affect them to reduce overall backup/restore time.
Presentation plan:
1. Introduction into a BACKUP/RESTORE task. BACKUP/RESTORE parameters affecting performance. Types of BACKUP/RESTORE parallelization. 2. Pre-requisites.3. Barstats statistics understanding.4. Barstats deltas.5. What we can see from barstats deltas. Backup/restore behavior. Work distribution between agents.(for both Buffer Manipulators and Media Controllers). Idle agents.6. Differences between backup agents behavior for BACKUP to specified device(s)/target folder(s) and for BACKUP using VENDOR library.7. Balancing parallelisation parameters to get the best backup/restore time.8. Parallel backup/restore between hosts. Named pipes magic.
Speaker
AV
Thursday October 30, 2025 10:20am - 11:20am WIB
Aristoteles 2
  Track D

10:20am WIB

E16 | Native cloud object storage in Db2 Warehouse: AWS or Azure ?
Thursday October 30, 2025 10:20am - 11:20am WIB
Aristoteles 1
The The availability of low cost with effectively unlimited capacity cloud object storage has given rise to modern cloud architectures that exploit this independently scalable storage in combination with compute servers with ephemeral local NVMe caches. Join the development team behind the release of native object storage support in Db2 Warehouse as they share their experience with the new storage layer in both AWS and Azure. Explore the design of this new component as the developers explain how it enables a multi-tier storage architecture for the data warehouse, unearthing the potential of contemporary, low cost, scalable object storage to reshape the traditional database management system. Come to learn about the differences with Cloud Object Storage between AWS and Azure.
Speaker
RH
Thursday October 30, 2025 10:20am - 11:20am WIB
Aristoteles 1
  Track E

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

D17 | Advanced Performance Diagnostics for SQL
Thursday October 30, 2025 11:30am - 12:30pm WIB
Aristoteles 2
The Db2 family of products including Db2, Db2 Warehouse, and BigSQL provide a number of important features for diagnosing and solving your SQL problems. Through a series of practical examples, this session will bring you up speed on the latest capabilities available for SQL diagnostics and show you how you can leverage them to solve query problems in your own environment. You will learn how to identify your most expensive SQL statements using the package cache table functions, and how to use Db2's "time spent" metrics to analyze where your problem queries are spending their time. You will also learn some new tips for monitoring sort memory metrics and query memory consumption in order to tune your analytic workloads. Finally you will learn how to use the runtime explain capabilities in conjunction with the activity event monitor to capture actual query plan cardinalities as well the per object metrics.
Speaker
DK
Thursday October 30, 2025 11:30am - 12:30pm WIB
Aristoteles 2
  Track D

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

11:30am WIB

F17 | REST API: A New Way to Access Db2
Thursday October 30, 2025 11:30am - 12:30pm WIB
Aristoteles 3
Applications may use Db2 not only via traditional drivers like JDBC or ODBC but also via a REST API. A big advantage of the REST API is that there is no need to install a driver at the client side since most programming languages come already with REST support. This presentation shows how to set up the REST API of Db2 and gives an overview how the REST API of Db2 can be used to build such “driverless” applications. It demonstrated the power of the REST API for Db2 applications with several examples and use cases.
Speaker
AW
Thursday October 30, 2025 11:30am - 12:30pm WIB
Aristoteles 3
  Track F

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

2:00pm WIB

B203 | Amazon RDS for Db2 Workshop
Thursday October 30, 2025 2:00pm - 6:30pm WIB
Socrates
This workshop will give you the education and information you need to use existing and new features of Amazon RDS for Db2. Some of the topics covered during this workshop will include provisioning, scaling, backup, monitoring, migration and beyond. Each module will be introduced and presented and then participants will be provided an environment they can use and go through a series of instructor led exercises to practice what they have learned and explore. This will be a joint workship between the IBM and AWS RDS teams.
Speaker
AH
Thursday October 30, 2025 2:00pm - 6:30pm WIB
Socrates
  Workshops

2:00pm WIB

C203 | Hands-on with Db2’s Vector Store and Similarity Search
Thursday October 30, 2025 2:00pm - 6:30pm WIB
Leibniz 1/2/3
In this hands-on lab, you’ll experience the generative AI capabilities made possible by Db2 12.1’s new vector data store. You’ll see how to generate multi-dimensional vector embeddings, how to create tables to store and work with these embeddings, and how to use semantic search in a retrieval-augmented generation use case to find and retrieve the most similar or relevant information requested by a user.
Speaker
MM
Thursday October 30, 2025 2:00pm - 6:30pm WIB
Leibniz 1/2/3
  Workshops

2:00pm WIB

D203 | MaaS - Db2 Monitoring as a Service in AWS, Azure, GC and IBM Cloud
Thursday October 30, 2025 2:00pm - 6:30pm WIB
Aristoteles 2
A cloud native resource without monitoring (or with a very complex monitoring setup) is like driving a car without a dashboard - you wouldn't know if you are speeding or low on fuel! Db2 needs a concise and simplified monitoring solution that gives a bird eye's view on the performance metrics and Db2 diagnostics. We present here a solution that is available in AWS, Azure, Google Cloud and IBM Cloud while running Db2 with a Infrastructure as a Service model.
The speaker will cover her experience of collaboration with all cloud vendors, Db2 development and customers like SAP. The session will share the findings from that reserach and development project and it is based on the cloud native monitoing solutions currently available. The solution consists of a smart combination of Db2 monitoring capabilities, Operating System scheduling and Cloud logging functionality resulting in an out-of-the-box Db2 monitoing solution.
The solution has the following features:
Displays the most important metrics (based on customer data) of a database instance namely, Bufferpool quality, Activities per second, Activity wait time and Logging performance.Information regarding Db2 Diagnostics by providing the count of increasing errors that can be easily extended for a comprehensive diagnostic analysis. Whether or not the database is alive. This solution introduces the Monitoring as a Service infrastructure and ables you to build your own cloud native monitoring solution with a few fingertips.
Speaker
NC
Thursday October 30, 2025 2:00pm - 6:30pm WIB
Aristoteles 2
  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