IDUG EMEA 2026

This session will share experience from client studies and engagements: sharing proven recommended best practice; learning good, bad and ugly; providing answers ti important, frqeeunt or difficuly questions. This session will cover the following topics: Complacency about component failure and ability to absorb workload failover in a dat asharing environment; missed opportinity for elapsed time performance improvementnfor skip sequnetial batch processing; misteps in evaluating the performance benenfit of CICS-Db2 thread reuse and RELEASE(DEALLOCATE); SQL coding to avoid update anomaly when using cursor stability isolation; misadventures when using High Performance DBATs;monitoring WLM policy achievement; options for mass data recovery following logical data recovery and data loss; performance issue with remote DDF batch workload; tuning ogf GBPs; thorough Disaster Restart testingh.

In the next version of Db2 for z/OS IBM is removing some deprecated functions. I will describe how to find the affected objects and functions and how to convert them. I will also touch on some pitfalls and share our experiences. Some examples are non-UTS tablespaces, but there are more. And there are some more things that is not documented yet.
The presentation will not cover the conversion from VTAM to TCPIP.

This presentation explains how DB2 uses workfiles for a range of purposes, including SORT, scrollable cursors, and temporary tables. It also describes how workfile allocation and usage behave both before and after the enhancements introduced in V13 FL508. Finally, it reviews the workfile monitoring capabilities available today, with particular emphasis on the enhancements introduced over the past decade and how they can be leveraged to identify tuning opportunities.

SQL performance tuning is a core DBA skill, yet many efforts remain reactive and inconsistent. This session presents a practical, end-to-end tuning workflow for Db2 for z/OS from identifying problem SQL to validating improvements. Attendees will walk through real tuning decisions using metrics, access path analysis, and supporting tools to achieve measurable performance gains.