As usual after an IDUG, I wish to run through the presentations and highlight what I found interesting, newsworthy or just worth propagating to the community at large.
AI or FL511?
This year it was either migrating to FL511 or AI – that was basically it!!!
Location, Location, Location
The food was excellent and the location was great. The AV could have been better, some of the rooms were a bit small, or you were blinded by the sunlight from outside. This never normally happens in late September but the weather was glorious!
Disclaimer
Here is my normal Caveat Emptor – I am going through the downloaded presentations and I did *not* attend anywhere near as many as I wanted but I do also have to work at these events so please accept my apologies if I missed your favorite session or if I quote from a slide that was removed by the presenter or I missed a great quote as the presentation has not yet been updated or is perhaps not even available!
Where are they all?
You must have attended the IDUG and be a member of IDUG to download these! Go to the IDUG web site, login and navigate to:
https://community.idug.org/organization/idug-emea-2026-db2-tech-conference/paths
Here you can download the PDFs in Track sequence.
Off we go!
We start, as always, with the A track for Db2 z/OS
A01 Db2 for z/OS Trends and Directions from Haakon Roberts was the usual great update about all things Db2 for z/OS. Slide 10 with PH69217 is a must-have!
A02 Hard Lessons Learned when using High Performance DBATs with Db2 for z/OS from John Campbell (Now at Broadcom) was a typically great John presentation. Slide 18 all about getting safe before you start is a great tip! The WLM changes are also an absolute must to check and verify when switching to HP DBATs.
A03 What’s New in Db2 for z/OS Performance from Akiko Hoshikawa. A really good update, as usual, about all things performance in Db2. The use of CDDS got a much-needed mention as this really is a “hidden chestnut” at this time! APAR of major interest is PH70190 for work files.
A04 Supercharging Db2 with Generative AI: From Natural Language Queries to Autonomous Performance Optimization from Chris Crone. As well as the longest title ever, this was naturally all about the brave new world of trying to tell newbies that z/OS is not a green-screen dead-end but a VS Code vibrant world ready for the future!
A05 Starter’s Guide to Db2 for z/OS Group Buffer Pool Monitoring and Tuning from Bart Steegmans covered a bunch of Group BP tuning topics very close to my heart as these Baby Brothers of BPs are nearly always, sadly, ignored by most of us! The final slide Summary contains what you must take away!
A06 Strategic Efficiency: Maximizing Db2 Utilities from Denis Tronin was a run-through and update about all the Broadcom utilities that one could possibly use with Db2 for z/OS.
A07 Db2 Utilities: Best Practices from Haakon Roberts was the usual update about all things we should be doing with the IBM utilities today, but are probably not doing! Slide 19 with the “hint” that MODIFY RECOVERY makes REORGs faster was sublime …
A08 AMI Db2 utilities – What’s new was Roberto Cason talking all about the BMC Utilities and what they can do for you.
A09 Db2 z/OS Utility Internals — how to get the most out of them from Preetham Kannan was all about Utilities and which parameters and options are best for doing various tasks. From REORG to RECOVERY all utilities were well covered with examples about why which option should be used and when.
A10 Linuxification of Db2 for z/OS –a journey from ISPF and JCL to Shell and Playbooks from Marketa Muzikova & Emil Kotrc scared me at the title line! Pulls you through Unix on z/OS, ZOAU, Ansible and ends with a string of tips to make sure it all hangs together!
A11 From Pay Slips to P1 Incidents: Db2 for z/OS in a Payroll Company from Tim Vermeulen. A great look into a real company with real applications and real data including some good Buffer pool change results. The BPs were set up years ago and then were basically ignored. The BP, and as Bart said the GBP, are a real gold mine for performance as long as you have the memory for it of course! Then a very nice exposé about HTTP/REST call usage or, as it was put, “API Calls – A solution for the poor” !
A12 Db2 13 for z/OS – DDF Connection Security Controls from Gayathiri Chandran – Everything you ever wondered and more, about DDF and how it securely connects. Basically, we should all be moving to RACF Identity Token (IDT) usage or whichever similar system your security system offers…Or you could go down the road of Client Certificate Authentication for Protected IDs using Trusted Contexts. It was rounded off with a review of SYSTEM Profiles and what they can do to help & control DDF.
A13 was the z/OS expert panel discussion which I missed …
A14 DDF Best Practices from Derek Tempongko was all about DDF and how to find out where everything is coming from! Included is a list of things about VTAM/SNA deprecation which is very useful.
A15 JC Greatest Hits, War Stories and Best Practices 2026 – John’s latest updates about everything! Always worth seeing / reading and reviewing! Once again, GBP Tuning was discussed here in detail…
A16 Get ready for Db2 version 13+1 from Martin Ålund. A presentation after my own heart! The Aha idea DB24ZOS-I-1480 was mentioned about allowing REBIND of PLANs while they are in use and I voted for it straightaway!
A17 DB2 for z/OS Workfile Deep Dive – How to Survive and Thrive from Adrian Collett. A detail-packed deep dive into these very misunderstood beasts of burden that we all take for granted! After the presentation is a ton of data going into crazy detail about all you will ever need to know…
Track B up next!
Onto the B track for Db2 z/OS which starts with B02 as “B01” would have been parallel to A01.
B02 Assessing Your Db2 Security for z/OS Without losing your mind (or Your Data) from Jørn Thyssen. The Six Pillars are all exposed and detailed. Including a step-by-step guide to assessing your current level of security as well as prompts for the AI of your choice to generate stored procs to do some of the heavy lifting for you. Slide 24 is a very nice Ownership best practices review. Included is “the triumvirate” of RACF Classes.
B03 My new besties: the Utilities tables from Soledad Martínez. This interesting presentation includes details on rows that are DELETED by conversion REORG processing. Includes a whole bunch of handy SQLs for doing interesting things and finding stuff out using these tables. Aha ideas get a page as well – so please look and go vote!
B04 Z Data Strategy & Integration Update from Cuneyt Goksu. This was more a C level presentation about how good IBM hardware/software stands at the moment in the business and AI world. Wrapping up with Kafka use cases and Confluent.
B05 Beyond the Basics: Backup and Recovery for Resilient Db2 Environments from Aysen Svoboda. Went into good details about what is a disaster, how are they caused, what you can do about it and how you can recover as quickly as possible. Plan, plan and plan again! REPORT RECOVERY should be your best friend!
B06 From Complexity to Operational Intelligence: Modernizing Database Administration with AI on IBM Z from Akiko Hoshikawa – like A03, no download available here.
B07 Revisiting Query Parallelism: Targeted Use of zIIP Processors for Db2 Queries from Thomas Baumann. Thomas shows us a way to revisit Query Parallelism in the light of the fact that we all have lots of zIIP processors these days as opposed to DB2 V4 in 1995 when it was introduced! Extremely good and interesting query rewrite examples leveraging parallel processing and ending with “in a Nutshell” on slide 41. Great stuff!
B08 Get Cozy with WLM: Why Every Db2 DBA Needs to Understand Workload Management from Denis Tronin. A complete introduction to all things WLM and distributed workload identification possibly requires application changes to actually use the _CLIENT fields. A nice round up of pitfalls and common mistakes followed by examples.
B09 Buffer Pool tuning process with a reverse application analysis from Pawel Hryb. Back to one of my favorite topics but with the twist of working backwards from the IFCID 199 output – Great idea! Good result on slide 26. One of the biggest finds was that simply REORGing SYSCOPY tablespace fixes a huge problem! My personal Mantra is SYSCOPY and SYSLGRNX reorged once a week every week.
B10 Db2 13 latest real customer experiences – new functions, best practices and some more…from Ute Kleyensteuber. Ute’s usual very good presentation about all things Db2 13 FL508 plus a page full of APARs that you should all have written down somewhere! Also included were the details of her on-going migration to 100% UTS and finally a review of early FL509 experiences.
B11 Bringing Mainframe into the Future: OpenTelemetry for Db2 for z/OS from Christoph Theisen. Gave a full introduction to the Whats, Hows and Whys of OpenTelemetry including the APARs PH67971 & PH68073 required for OTel support and the new commands for starting and stopping it all. Finishing off with a lessons-learned section and the difference between IFO and OTel today.
B12 Db2 critical events monitoring from Roberto Cason. This session went through a whole gaggle of messages and codes and how to decode from where and how they were issued, then listing out all critical events that require instant responses!
B13 Introduction to SQL-PL from Les King. This was marked as being “cross platform” but I am pretty certain it is mainly of interest to LUW people. But it does contain a ton of example SQL PL language usage.
B14 The Db2z Game – No download available.
B15 Db2 Analytics Accelerator: V8, Migration experiences, future and customer updates from Cuneyt Goksu. Here we get a run through of the IDAA and Accelerator ecosystem including the IDAA on LinuxONE. Then the V8 update info including SQL Data Insight Pro.
B16 From Lilliput to Brobdingnag. Compression flavors in Db2 for z/OS from Ivan Losada. Absolutely everything you have ever wanted to know and more about Db2 on z/OS compression! Sadly, the graphics did not make it to the presentation but you can still read it all!
B17 Leave the dark side – Turn on the lights in Db2 performance management from Gerald Pfeiffer & Tim Meisner. They ran through the SVA product zInsights showing all the data you can capture and they can post process into clear graphs and drill downs. Snazzy! Lots of WLM set up and modernization data as well.
Track E now
Now onto track E – Themes I, where I have picked out all the z/OS relevant ones.
E02 Db2 Evolution to UTS from Haakon Roberts. Here, he went through the deprecated items again and then went through in great detail how and why to get to a 100% UTS world. The interesting point for me was the comment “Not wise to go beyond 100 tables at a time” during a MOVE TABLE statement. Another good point is to watch out for more open datasets, DSMAX could be hit nowadays! Finally, the old problem of OBID Limits could also easily be hit. You can view my Know your limits presentation where I explain this and other limits in detail.
E03 Autonomous Auditing: High Score on Db2 Security Features from Steen Rasmussen. Steens very last EMEA IDUG after being at 73 different IDUG style of things … impressive!!! The presentation is a quick review of all the autonomous security features that have arrived over the years to enable us to actually get nearly Autonomous Auditing!
E04 Smarter Db2 REORGs: A Real-World User Story from Shivam Pratap Singh. A real deep dive into just REORG! When you should do one, how you should do one and why you should review the reasons why you are doing it, and also: “The best REORG is possibly no REORG”!
E08 No Pain – No Gain: Story of Optimizing DELETE Purge Processing from Tereza Binarova discussed how one delete statement triggered six months of investigation and then this presentation as well! All you ever needed to know about DELETE processing and more! An interesting walk through what you can change or tweak and how it helped or did not – all summed up nicely on slide 29!
E09 Seamless SNA/VTAM migration (preconditioning for next version of Db2) from Derek Tempongko. A lot of firms are being bitten by this deprecated item. I think more than IBM Db2 development figured! So, it is to be expected that we get help in migrating to TCP/IP.
E10 Stabilize your dynamic SQL and don’t let it remain “unpredictable” from Colin Oakhill. Stabilized Dynamic SQL has been around a while but not many shops are leveraging its usefulness. This presentation takes a nice deep dive into Dynamic SQL and how to use and manage Stabilized Dynamic SQL.
E11 Exploring Db2 Explain Facility for the next Gen of Db2 DBAs and using AI to bridge the skills gap from Phill Baker. A deep dive into all about EXPLAIN and what the Optimizer “knows” about things before it decides its best lowest-cost access path. Using AI to help drive EXPLAIN understanding with a ton of prompts and answers.
E12 SQL Injection on SterAIds: Is Your Db2 Ready for AI-Assisted Attackers? from Petr Plavjanik. Showed us that SQL Injection, especially backed by AI, is alive and kicking! The “Is Your Db2 Ready?” checklist on slide 40 is a must-read for us all! All a bit scary, really …
E14 Detect, analyze and reduce IX Splits using RTS History from Laurent Kuperberg. Does what it says on the label! I have seen vast amounts of logging caused by index splits so I know it is a great area to win performance! Includes how to handle the three different IX splits that can occur and how to choose correct values for PCTFREE and FREEPAGE for your indexes based purely on RTS data.
E16 Getting Started with OpenTelemetry for Db2 from Angelika Heinrich and Rabah Beggar. All about OTel and the shift from Monitoring everything to Observing everything. OTel does not replace IFCIDs but it does supplement them and works at the Enterprise level.
E17 Db2 13 for z/OS – Security updates from Gayathiri Chandran. She runs through all the latest security updates with the keywords we should all know these days: Quantum Safe, Audit, Compliance etc. A note about PRIVATE_PROTOCOL as this parameter will die soon: you could start IFCID 374 to tracks its usage and start GRANTing EXECUTE ON PACKAGE now!
Finally Track F
Now onto track F – Themes II, where I have picked out all the z/OS relevant ones.
F03 Connect, Visualize, Predict from Niraj Garudkar. All about using Connect with Python to get and run data from your z/OS using lots of different output types and rendering. Crazy what you can do these days!
F04 Insights and experiences from Garanti BBVA’s Fast Traverse Block index implementation in production from Hakan Kabayel. Here we learn all about FTBs with some SQL to find and select them as well as the tip to keep monitoring. The Conclusion on slide 27 shows you the numbers!
F05 When REORGs Go Wild: Managing Unexpected Partition Growth in Db2 PBG Tablespaces from Zoe Andreopoulou and Michal Bialecki echoed their journey through unexpected partition number growth after a REORG. After discovering the cause, they developed a set of tests to try and find the best way to “fix” the problem, basically a tradeoff between the number of indexes and number of partitions before switching to a TS Level Reorg or even abandon PBG and go PBR, if possible! The SORTNPSI YES parameter and the REORG_PART_SORT_NPSI AUTO/YES ZPARM are “your friends”.
F07 The Anatomy of Universal Tablespaces from Emil Kotrc. A really deep technical deep-dive into everything about UTS including all the usual suspects! Contains a great history of Db2 Tablespace from V1 on up – Nostalgia time! Warning: Contains maths! 😊
F08 Ready Player one? from Roy Boxwell (me!) A run through absolutely everything that will bite you before getting to Db2 13 FL511. I showed how to find the bad guys, how to fix the bad guys (apart from VTAM/SNA!) and how to handle SYNONYMS as they can be especially nasty! I rounded off with a quick review of our freeware MigrationReadiness HealthCheck that does it all for you!
F11 SQL Oldies but Goodies and the Power of the SQL Rewrite from Tony Andrews. Tony gave a review of all the new SQL stuff from DB2 V8 up to today and then concentrating on the power of SQL rewrite.
F12 Hidden in plain sight: Db2 recovery from Dhiren Chaudhary. Here he covers the complete RECOVERY scenario asking good questions especially about COPY YES Index usage pros and cons as well as FLASHCOPY benefits etc. He also has a good Aha idea that you could go and vote for : DB24ZOS-I-1852.
F14 Beyond COPY: Modern Recovery Strategies In Db2 for z/OS from Andrea Boaretto and Martin Crippa. They map and document a complete strategy for RECOVERY at any shop highlighting the elapsed and CPU savings of them all dependent on when the error occurs and how the RECOVERY progresses. Fascinating stuff!
F15 Loading large Db2 tables from Rob Gould. This was all about how you should process large amounts of data, by large he means over 1.7 billion rows! Great little tip was the use of z/OS Jobgroups which are basically a poor man’s job scheduler – Great for such a one off, obviously not great for normal production work!
F16 Db2 Connect – New Challenges and New Opportunities from Christoph Theisen. Starting out explaining licensing was a brave call in my humble opinion! I think the IBM naming commission made a bit of a mess of all this to this day! Important tip was EOF for V11.5 on the 30th April 2027. Another “deprecated” item we must address – In the V12.1 a bunch of changes including to the license were rolled out as well as a lot of new functionality. He also mentioned one of my favorite pains and that is the unuse of CLIENT information fields. Guys & Girls please USE THESE FIELDS! They are fantastic for tracking and monitoring – We all know that the application must be updated here but it should be a C level choice to absolutely know which transaction is “owned” by which “process”. It also enables the WLM to manage critical transactions so, for me, this is a no-brainer and this is all simply done by filling in the CLIENT Id fields.
F17 Architecting the Perfect Restore: Mastering Db2 Copies, and Compliance from Ahmed Hamed. A deep dive into the internals of Full Image Copies, Incremental Image Copies and VSAM-Level (SLB/FLASH) Copies leaning into improving your RTO times and then meeting your compliance goals.
Closing words
The winner of the IDUG EMEA 2026 Best User Speaker was Zoe Andreopoulou with F05 – Congratulations and it is good to see that z/OS rules again!

I managed a respectable “mentioned in dispatches” Top Ten speaker entry for which I am also very happy! On a related note, I am also very happy that my surname starts with a B!!!

I thought that this was a most excellent IDUG as the location was great, the people were, as usual, fantastic and it is always a pleasure to present and to meet and greet colleagues, customers and Db2 professionals. Of course, with the Barista coffee machine next to my booth, my life was better than usual! ☕
After the IDUG is before the IDUG!
The next EMEA IDUG will be held from 26th to the 30th April 2027. Monday the 26th is the pre-conference workshop day. Location is at the new IBM labs in Ehningen, Germany.

As you can see, at the bottom left, we will be south west of Stuttgart next year! Just over a five-hour drive from where I live… Should be fun!
What did you think of the IDUG this year?
TTFN,
Roy Boxwell






