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 B clear filter
arrow_back View All Dates
Monday, October 27
 

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
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.
Monday October 27, 2025 2:00pm - 3:00pm WIB
Socrates
  Track B

3:20pm WIB

B4 | Taming Page Splits: Reduced Stress for DBAs in Db2 13
Monday October 27, 2025 3:20pm - 4:20pm WIB
Index page splitting in Db2 for z/OS has long been a source of performance stress for DBAs, particularly in high-volume insert environments. Prior to Db2 13, identifying and resolving these issues was a frustrating process. This session delves into the enhancements introduced in Db2 13 that simplify the management of index page splits. We will explore new capabilities and enhanced real-time statistics provide DBAs with actionable intelligence, enabling them to quickly pinpoint and address problematic page splitting activity. Discover how Db2 13 reduces the stress associated with index performance tuning, offering practical strategies to minimize page splitting and optimize Db2 performance.
This abstract was submitted in GSE Virtual 2025 as well.
Speaker
Monday October 27, 2025 3:20pm - 4:20pm WIB
Socrates
  Track B

4:30pm WIB

B5 | Build a lightweight monitor to identify SQL workload tuning potential
Monday October 27, 2025 4:30pm - 5:30pm WIB
In this session, you will learn how to capture SQL statistics from Db2’s dynamic statement cache and how to combine them with the information from your EXPLAIN tables. The code that we use will be available for download after the session. Discover how to identify the queries that will benefit most from tuning, allowing you to focus your valuable time on those that matter. We start with simple metrics like RID list errors and work our way up to other performance metrics like top consumers, I/O statistics, lock contention, and more. You will learn how to track the performance and resource consumption of a given SQL statement over time, which makes it possible to spot trends. Finally, we will show how to detect access path changes in dynamic SQL workload. This is a common problem in environments with heavy dynamic workload. Something as simple as a single RUNSTATS execution on one of the involved tables can cause unexpected changes to the access path that Db2 chooses. Using historic explain information, these changes become visible, and you can take immediate action.
Speaker
Monday October 27, 2025 4:30pm - 5:30pm WIB
Socrates
  Track B
 
From $0.00

AI Era: Shaping Tomorrow’s Intelligence
From $0.00
Share Modal

Share this link via

Or copy link

Filter sessions
Apply filters to sessions.
Filtered by Date -