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

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

10:20am WIB

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

10:20am WIB

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

10:20am WIB

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

10:20am WIB

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

11:30am WIB

A7 | Db2 13 latest real customer experiences - new functions, best practices and some more…
Tuesday October 28, 2025 11:30am - 12:30pm WIB
Rheinlandsaal C
This presentation will provide the ongoing success story Db2 z/OS Version 13 and covers the latest experiences with Db2 13 at Commerzbank AG. It will talk about some key important areas which are essential for the success and how to prevent some known avoidable pitfalls. We share the important latest experiences of the last 12 months, explains the upcoming and validated best practices in several key areas. This session will also dive into Function Level dependencies, maintenance aspects, some tooling dependencies and some performance aspects as well as base utilities and system functionalities.
Speaker
UK
Tuesday October 28, 2025 11:30am - 12:30pm WIB
Rheinlandsaal C
  Track A

11:30am WIB

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

11:30am WIB

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

11:30am WIB

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

2:00pm WIB

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

2:00pm WIB

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

2:00pm WIB

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

2:00pm WIB

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

4:30pm WIB

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

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

4:30pm WIB

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

4:30pm WIB

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