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!
Type: Track F clear filter
Monday, October 27
 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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