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

Join us as we navigate the transformative landscape of AI, forge connections, and unlock the potential of tomorrow’s possibilities. Let’s embark on a journey towards a more intelligent future together!
Audience: Intermediate clear filter
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

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

10:20am WIB

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

10:20am WIB

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

2:00pm WIB

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

4:30pm WIB

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