The March 2026 London Db2 User Group (LDUG) once again demonstrated why it remains a key fixture in the Db2 for z/OS calendar every year. Bringing together Db2 practitioners, architects, and performance specialists, the event delivered a packed agenda covering real‑world challenges, practical guidance, and deep technical insight.
Download Resources
If you were unable to attend — or would like to revisit the material — the presentation slides are now available to download. Among the many expert-led sessions, Triton Consulting delivered two presentations; Gareth Copplestone‑Jones’ session on “Explaining EXPLAIN” and John Campbell’s “Db2 for z/OS Data Sharing Performance Analysis and Tuning”.
In “Explaining EXPLAIN”, Gareth Copplestone‑Jones focused on the basics of Db2 EXPLAIN, building a solid foundation for understanding how Db2 processes SQL and why EXPLAIN remains one of the most important tools in a Db2 professional’s toolkit.
In addition to the Triton Consulting sessions, you can also download the slides from the other speakers, including IBM’s Bart Steegmans and NatWest’s Dhiren Chaudhary.
What Next?
The next LDUG event is on 2 September 2026 at IBM, York Road. Planning has started for the event so watch this space for updates on:
- How to submit a presentation
- Hosting a discussion
- Event registration details coming soon.
To stay in the know, sign up to The Triton Perspective, our new monthly LinkedIn newsletter. Get insights from our Consultants first, before they are published on our website.
Presentation Downloads
Explaining Explain
In his March 2026 presentation at LDUG, Gareth Copplestone-Jones discusses the function of EXPLAIN, the concept of access paths, the process of creating EXPLAIN tables, and how to obtain EXPLAIN output.
Db2 for z/OS Date Sharing Performance Analysis and Tuning
John Campbell looks at Db2's technical architecture, focusing on global locking, the LOCK1 structure, global lock contention, and tuning strategies for group buffer pools to enhance performance.