Loading…
arrow_back View All Dates
Wednesday, October 28
 

10:20am EDT

A10 | Revisiting Parallelism: Targeted Use of zIIP Processors for Db2 Queries
Wednesday October 28, 2026 10:20am - 11:20am EDT
Magnificent 3
This presentation explores the nuances of query parallelism in Db2, focusing on how to effectively tune queries for optimal zIIP exploitation. Attendees will gain insights through real-world query examples, highlighting the critical distinction of query access paths between iterative and merge strategies that are key to achieving successful query parallelism. Practical use cases will illustrate these principles in action, showcasing tangible improvements. Additionally, we will discuss how ChatGPT can assist in the query tuning processs. Join us to rediscover the power of parallelism and leverage zIIP processors to their fullest potential.
Speakers
avatar for Thomas Baumann

Thomas Baumann

Data Evangelist, Swiss Mobiliar
As Data Evangelist at Swiss Mobiliar in Bern, Switzerland, Thomas is dedicated to optimizing databases and managing database risks. When he's not in the office, he can be found sharing his expertise on database optimization and risk management at various speaking engagements. Thomas... Read More →
Wednesday October 28, 2026 10:20am - 11:20am EDT
Magnificent 3
  Track A, Technical Session

10:20am EDT

B10 | Hard Lessons Learned with High Performance DBATs for Db2 for z/OS
Wednesday October 28, 2026 10:20am - 11:20am EDT
Magnificent 1
High Performance DBATs (HP DBATS) is a very important performance feature of Db2 for DDF workloads. If applied and used intelligently this feature can generate significant savings in CPU resource consumption. This session will cover the following topics: what is a connection?; what is a DBAT (THREAD)?; thread (DBAT) pooling and DRDA inactive connections; what are High Performance DBATs; good candidate application workloads for High Performance DBATs; general guidance for configuring High Performance DBATs; performance metrics and monitoring; WLM and High Performance DBATs; Issues; Summary.
Speakers
avatar for John Campbell

John Campbell

Distinguished Technical Consultant, Broadcom
John is an IBM Alumni, a retired IBM Distinguished Engineer, and now works as a Distinguished Technical Consultant for Broadcom Inc. He has worked with Db2 for z/OS for over 40 years and has extensive experience with Db2 in terms of systems, database and application design. He specialises... Read More →
Wednesday October 28, 2026 10:20am - 11:20am EDT
Magnificent 1
  Track B, Technical Session

11:30am EDT

A11 | RTS-/Utility History and preparations for Vnext
Wednesday October 28, 2026 11:30am - 12:30pm EDT
Magnificent 3
This presentation will cover how to benefit from using Real Time Statistic (RTS) and Utility History. I will explain a useful established example of Real Time Statistic History, share which usecases are covered by RTS History and why RTS Temporal out of the box is not sufficient for everyone.
Second part will share some necessary preparations for Vnext and will cover one path and best practices to get rid of deprecated non-UTS tablespaces, what to consider and why utility history is really helpful. It will give some early experiences on FL509 support to migrate remaining Catalog&Directory tablespaces. Relevant topics like “workfile separation” will be covered as well.
Speakers
avatar for Ute Kleyensteuber

Ute Kleyensteuber

Principal Product Owner, Commerzbank AG
Ute Kleyensteuber is a Principal Product Owner, Senior Infrastructure Engineer and Director at Commerzbank AG in Germany, responsible for Db2 for z/OS since more than 35 years. Knowing and working with Db2 since Version 1.2 I've extensive experiences of Db2 in terms of system- and... Read More →
Wednesday October 28, 2026 11:30am - 12:30pm EDT
Magnificent 3
  Track A, Technical Session

2:00pm EDT

C12 | Efficiently Finding and Fixing High Resource Consuming SQL
Wednesday October 28, 2026 2:00pm - 3:00pm EDT
Magnificent 4
This presentation will demonstrate how to find, analyze and tune the top 40 expensive queries. Special emphasis will be on finding the cursors that could benefit from multi-row fetch. In addition, discussions on designing perfect indexes, MQTs and AQTs, along with manual query rewrite, SQL exploitation and most important, proper use.
Speakers
avatar for Sheryl Larsen

Sheryl Larsen

President, Sheryl M Larsen LLC
Sheryl Larsen is an internationally recognized researcher, consultant and lecturer, specializing in DB2 and is known for her extensive expertise in SQL. Sheryl has over 30 years’ experience in DB2, has published many articles, several popular DB2 posters, and co-authored a book... Read More →
Wednesday October 28, 2026 2:00pm - 3:00pm EDT
Magnificent 4
  Track C, Technical Session
 

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
Monday, October 26
Tuesday, October 27
Wednesday, October 28
Thursday, October 29
IBM TechXchange
Magnificent 1
Magnificent 2A
Magnificent 2B
Magnificent 2C
Magnificent 3
Magnificent 4
Magnificent 5
Magnificent 6
Magnificent 7
Magnificent Foyer
Triumph A/B
Triumph C/D
  • Badging
  • Essentials
  • Expert Panel
  • IDUG
  • Keynote
  • Track A
  • Track B
  • Track C
  • Track D
  • Track E
  • Track F
  • Audience
  • All
  • Beginner
  • Intermediate
  • Subject
  • AI / ML
  • AppDev
  • Cross Platform
  • LUW
  • z/OS
  • Area
  • AI GenAI and Machine Learning
  • AppDev
  • Automation
  • Back to Basics
  • Best Practices
  • Data Movement and Analytics
  • Data Movement and Integration
  • Database Resiliency
  • Db2 Cloud and Warehouse
  • Latest and Features LUW
  • Latest and Features z/OS
  • Modernization in Development
  • Modernization in Operations
  • Performance and Monitoring
  • Security and Compliance
  • User Stories
  • Utilities
  • Working with SQL