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
arrow_back View All Dates
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
 
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