2023-10 IDUG EMEA – Roy’s report

Ahhh! So good to get back on the road again… I am now back to my pre-COVID travelling and it catches up with you! I am soooo glad that I only have the German GUIDE in December and then I have *no* more planned travelling this year – Hoorah!

I have not heard of any outbreaks of COVID from IDUG yet, unlike TechExchange where I heard a bunch of Champions all got the lurgy again…

Back to Tech Stuff!

Tons of really good technical talks all started for me on Sunday already, as I flew in to Prague

I met „The Usual Suspects“ at the hotel bar, including Julian Stuhler who was there, as a retired guy, to hold the keynote on Monday morning. We had a nice night chatting and drinking. Then early the next day, off I was to the Prague Conference Center (PCC) to register and get the booth built.

Once there, I met the dynamic duo! Dan had flown in after winning Best Speaker at the IDUG 2023 NA and it was great to see him, and Denis, again!

Of course, as I was busy building the booth, I missed Julian’s key note but I heard it was very good indeed. I hope that someone uploads the PDF to the IDUG site so I can actually read what he said! I heard that it was all about Past, Present and Future – the Evolution of Db2 and IDUG and it must have been really good as it overran and was full!

Due Diligence

Please remember two important things:

1) To get the links to work you must be registered at IDUG *and* entitled to the content. Otherwise you will get a „forbidden“ screen popping up! If that is the case you can then think about buying the „Premium“ version of IDUG membership which does allow downloading of conference files without having to wait around two years.

2) I am only one person, so I did not get to see every presentation at the IDUG. If the presenter was swapped or the session cancelled I might not have caught that, so I apologize if I have forgotten anyone or anything!

Track A is Where it Always Starts!

A01 with Haakon Roberts doing his usual fantastic stuff about Db2 Past, Present and Future. For me, the highlight was the Db2 13 FL504 new Built-in Function (BiF) for SQL Data Insights (SQL DI) AI_COMMONALITY that I had seen rumors about but now it is coming this month! UPDATE! Now Available, Dec 2023

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=42c241e6-1e16-740c-ee14-940c436994c7

A02 was Akiko with a 40-Year review of performance, including some very nice comparisons from the IBM Benchmarks of 13 years ago and today. Amazing how fast things get in just 13 years – 4.2 times faster but with 2.5 times more logging! Another nugget from this was that SQL Data Insights goes into fake parallel mode to enable ZiiP eligible workloads…

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=67afc3f7-6ae7-72af-ff96-71726cf5a7b7

A03 was Haakon again, this time showing us the Past, Present and Future of schema evolution. My take-away from this, is due to moving from multi-table tablespaces (Think QMF here!) you might well start running out of OBIDs in your Database. We at SEG have a Migration Health Check that tells you if you are indeed going to be knocking on the door of some nasty internal limits!

https://www.seg.de/produkte/produktliste/migration-healthcheck/

His presentation is here: https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=f85bd909-f1db-c0d8-c3d9-650cd6300554

A04 Rotate away your problems from Johan Sundborg. This includes nearly all the JCL you need to set-up and run Partition Rotation for your good candidates. You can save massive amounts of CPU if you have the right Use Case.

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=16518129-de14-7a39-9b96-6b13e660eb01

A05 Decompressing the Compression in Db2 for z/OS. Everything you ever wanted to know but were afraid to ask about compression on Db2!

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=e161d84b-a78c-b73b-ac00-652ffd4f0d2c

A06 Utilities What’s new? Haakon Roberts telling us all the new stuff!

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=05227c1c-b4a3-e053-df8b-8c7227fecca9

A09 Establishing Db2 recovery procedures using redirected recover. A very good overview of doing RECOVERY using REDIRECTED as well. A good list of nasty little APARs where „old“ table defs can get ya! Plus, a page about Rookie mistakes…

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=9c3a3538-4f41-7d8c-b818-f2ad4343f182EU23A11S.pdf

A13 Monitoring your distributed workload for Db2 for z/OS. This was all about the fascinating world of trying to figure out who is connecting with which type and version of connector to your Db2 sub-system. A brief overview of the new IFCIDs 411 and 412 with the very good data that they have is also included. A bunch of example SQLs rounded off a very good presentation indeed!

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=55f37cfe-f5b6-54fc-b826-f0348daeb32b

A15 Implicitly or Explicitly Defined Db2 Objects the Good, the Bad and the Ugly. Steen doing his thang! A good detailed look at the pro’s and con’s of implicit spaces and the many pitfalls of PBGs with LOBs – I avoid them at all costs!

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=9826831b-9fe7-0e17-f39c-fd98aae967e0

A16 How to avoid the loss of data and minimize the costs associated with a Db2 outage. Top tips all about Backup and Recovery. Including the separation of catalogs that is required for successful BACKUP SYSTEM.

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=4fb8d50b-6dea-c1ca-99e4-8b7ff550462d

A17 Sun Up to Sun Down The Chase to Achieve 24-7. This was a peek into parallel sysplex and how to guarantee you do not fail! Also includes a bunch of Db2 13 enhancements for continuous availability.

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=cbadeaf5-ccf9-8cf7-a48d-670977187d23

Track B

B02 The A-Z of Logging for Db2 for z/OS explained everything about what is on and not on the Log and really contained an A to Z list. However, the values for J, K and Y were missing – Perhaps my trusty readers can come up with some values? E.g. J – JCL, K – KB and Y – Yottabyte! Further to this, we have at SEG another freeware that reads your archive logs and tells you what you have! You may well be surprised at the amount of stuff that gets logged!

https://www.seg.de/produkte/produktliste/db2-archive-log-viewer/

Julia’s presentation is here: https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=e70efe05-a89a-0821-3a8e-1251a36665cc

B03 Recovery From Z To A was a great presentation full of useful info all about doing the dangerous job of RECOVERY. Well worth a review!

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=3bc5b1c9-030f-124c-dfaa-0b61b037549d

B04 A day in the life of a Db2 for z/OS schema was a really nice explanation of schema life from three different perspectives: Developer, DBA and System! Pretty neat!

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=8ed0f8be-7c05-c9d5-913e-98ddde18e5e2

B05 Reorg Rabobank biggest Db2 table from APN to RPN. A really good real-life story about REORGing epically large tables. My highlight, was the fact that the elapsed time output of the reload message „rolls over“ after 99 hours!!!

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=6988c781-886b-a050-7803-34324f86a2b1

B06 Db2 For z/OS and Unicode – What you need to know. A complete review and overview of the ever-present Unicode code pages that are always with us all these days!

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=02855744-2e25-19fd-8f3b-da0fa934430f

B07 Getting Ready For Db2 13 – Updates. This was a review of Db2 12 Agile, continuous delivery and the steps required for a painless migration to Db2 13.

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=5c02aa69-074d-9e84-4901-b0dfdd4ace75

B08 Measuring is knowing – Db2 for z/OS instrumentation enhancements you may have missed. A very nice recap of all IFI changes in the past few years and also Commands and message changes. Please note that „Miscellaneous“ was about 50% of the presentation!! Great data here and a reminder about being careful about RID overflows not actually being RID overflows.

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=1f694955-7512-7476-8b09-0abe6b9394e4

B09 Who’s afraid of DDF? An explanation about DDF and how to get a handle on it. Another call to arms about using the PROFILE functionality (One of the best kept secrets in Db2 for z/OS IMHO!)

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=14ceba96-91a9-ce4b-9456-0fe782b3e735

B10 “Run it Back” Db2 for z/OS All new “2023 SWAT Tales” Was another great list of things from Anthony which you all should be doing. Included is a great visualization of Cyber Resiliency/”Safeguarded” Copies which we did not even need a few years ago! A very important point that he mentioned, is the PTFs that we must all apply. I can happily recommend you subscribe to my APAR Newsletter where I update, every month, all the APARs of interest including HIPER and PE ones! Just go here to see the latest and, if you want to, you can then register for email updates:

https://www.seg.de/apar-update/

Here’s Anthony’s presentation:

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=f4733d55-8200-318f-ea86-cbf08a3ca779

B11 Db2 13 for the production DBA. Has three points for the DBA today. PBG – PBR Conversion. DDL break in using the PROFILE tables again. Finally, Dynamic Query Stabilization. Great stuff!

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=c14e1ec6-df91-734f-075f-2960700b287a

B12 How to Hack Db2 for z/OS – Lessons Learned from Mainframe Hackers. That grabbed your attention didn’t it? Slide 19 makes me laugh every time I see it! Seriously, the major problems are allowing uncontrolled access to APF load libraries (This has been true for decades of course, but these days with the new twist of USS +a usage! Slide 55 is extremely useful here.) the use of Magic SVCs (These I have used in the past…) and basic user id protection.

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=e9815b49-c30f-6bb4-f19f-d8d23971ce7a

B13 Modernise your Db2 Environment – Top 20 Features People are Still not using. Adrian doing a great job of reminding us of what we have but are stubbornly ignoring! Slide 21 contained a very simple way of seeing if Parallel Access is for you! Slide 31 also reflects my opinion with RAM availability on z/OS. I am sure we (the DBAs) have much more RAM available than we are aware of. It can be *much* better used as an increased size for your buffer pools! Then slide 34 showed the real benefits…

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=79d5a8f5-cf4a-8b7f-e021-a61e328795a0

B14 Recovering to another subsystem with DSN1COPY. Sadly, not available at this time. A09 is lurking here!

B15 Db2 13 for z/OS: What is new in Security and Compliance? All about SMF type 1154 and its usage in compliance. Then the use of various caches within Db2 for Authorizations finally discusses PROFILE tables again!

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=988aca9c-18f8-b088-efc3-7796b2c09374

B16 When reality “derails” capacity planning for Db2 zOS. No link available yet, but it is in the zip file as a download. My mantra – slides 26 – 35! Especially slide 35…

B17 Db2 13 for z/OS Utility History :What is it and how to use it. All about the new Utility History table and example SQLs about how to use it.

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=cba21c87-c999-7f8b-950a-eab25d9c7b60

Track E

E02 SQL tuning : A business Case. Where Kurt held a plaidoyer for SQL Tuning and Training.

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=b3baae65-1eab-c9ae-33b1-6850a9de028f

E04 Fun with Ansible and Db2 for z/OS. If it is possible to have fun… A ton of examples, tips and tricks etc. If you are going down the road of Ansible this should be your starting point!

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=f505a697-6df7-1965-b91d-ee781a426a9d

E07 Near real time reporting system with Db2 data sources from both mainframe and AIX. Al about ELT and transferring data!

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=88c98e8d-bb33-c3a7-c7d6-0afd4b3610df

E08 Db2 Analytics Accelerator – What is New, what are customers doing with that! Hard numbers and data from real life customer usage of the Accelerator. The performance boost of NVMe is impressive! Ending with a sneak peek at 7.5.12.

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=b07fe65a-770f-9480-1f86-fc1989458db9

E11 Successfully migrate from CDC to Integrated Synchronization IBM Db2 Analytics Accelerator. A nice plan to migrate from CDC to InSync, listing out the steps to take and how to get there.

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=be93c0fa-44f1-80b0-1aad-b87897fe9bd7

E12 It’s AI Jim, but not as we know it! My little presentation all about the Hype and the Reality of AI and then showing how useful the three (four!) SQL Data Insights Built-in Functions that are supplied free of charge with Db2 13 for z/OS are.

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=40c942dc-b33d-57b4-f6f0-3aacb125a58a

E13 Db2 and the Magic of Disk – This was all about Disk I/O from way back when to today. Very interesting indeed. Gotta try and reserve a table at Katja’s restaurant one day!

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=218288ec-3859-b5f3-696a-0d14b0bf780e

E14 Db2 for z/OS and LUW Big Buttons for Application Performance. DanL strutting his stuff and basically trying to get us to reduce the number of SQL calls or the number of SQLs by using joins, views etc. as these are, by definition, the best way to save time and cpu!

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=ba91de38-706e-3aa3-9575-746afea05b9d

E15 ‘The Art of War’ against Bad SQL. Cool title indeed! A very good presentation with real world examples about how simple changes can save mega-bucks – Plus plenty of cool quotes!

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=a2269a6d-6186-5511-cd3d-e918da572510

E16 Accelerator on Z Monitoring and workload assessment update. A review of how to monitor the Accelerator(s) you have and make sure enough disk and memory are available and used!

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=400e832d-08a6-29db-fc9b-e4f27b84ddf3

E17 How to Drive Down Database Development Dollars. An absolutely wonderful mix of tips and tricks in a wide variety of languages, all about getting more performance and less pain out of your system.

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=df73726d-e847-88d1-4af3-9c19fcdf2d7b

Track F

F01 Db2 DevOps, Zowe CLI plugins, VS Code extensions and more! As the name suggests, a ton of stuff about DevOps, Zowe and VS Code extensions!

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=61a09bac-0245-1c93-cf1e-c774363165bd

F05 SQL on Db2 for zOS: The Missing Parts and how to deal with them. Thomas lists a few SQL challenges he has had, how he solved them and how he would *like* them solved by IBM development! There is also a nice list of AHA! Ideas you may wish to vote for.

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=3bb44f98-bf17-2a78-94df-835bc1498f13

F07 Db2 13 Application Development Topics. Gives a great review of Db2 13 and what SQL changes are contained within as well as PROFILE table again! Get the hint? Included at the end are 12 pages all about the „history“ of SQL fitting in to the overall theme of „40 Years“

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=c2bc2f2d-5f8c-8089-2938-6c08c7166dfe

F08 The Business Value of Db2 SQL Data Insights. All about how to use the SQL DI in a real business case. Starts with football but ends with an Insurance Case. Well worth looking into for the examples contained within!

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=f5a2dba5-3d4d-703e-d8dd-f1ededcfbb96

F09 Application Modernization – Considered those Db2 for z/OS Capabilities? Going modern but incrementally. She showed how many JAVA, Python, node.js and Go developers there are out there… Loads! As a bonus it mentions PROFILEs again…

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=7d923e7b-fc7b-b64b-3c93-433479360d1f

F11 Lessons learned while enabling DDF in an existing Db2 Datasharing environment. A good way to show how to set up DDF including security and log performance. The recommendations for application name and accounting to be used are very good and I can also recommend it! It is the *only* real chance to see which application is connecting to your host Db2 subsystem! Guess what? They also used PROFILE tables ….

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=130dc657-f750-d913-f1a4-9c1a9f4bd3c4

F12 CLPPLUS : The Other Db2 Client. A cross platform presentation and it contains what you need to know about getting LOAD on z/OS to work from LUW. Very cool and thin – unlike me …

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=faa4ba63-5ede-be6f-d791-2b1c439aaf35

F13 Back to Basics with Db2 buffer pools. This is a great intro and explanation of buffer pools. What they are, what to look for and what to do! I held a vendor presentation P06 which covers *exactly* the same ground! My vendor presentation is here:

https://www.seg.de/event/idug-2023-emea-db2-tech-conference/

And the original IDUG presentation is here:

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=96e5107b-1b98-bb4d-e533-a527937698a5

F14 Encrypting Db2 Connections with TLS/SSL. Everything about TLS/SL – It gets really interesting for z/OS people around slide 15 when „keyrings“ get mentioned! Slides 41 to 44 are also very handy for trouble shooting.

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=5161c4be-93d8-0809-6355-20d087a4e2cf

F16 Get Cozy with Ansible for z/OS. Apart from having the absolute coolest session code of the IDUG, this was all about going Ansible on the Mainframe. This is an introduction into the world of Ansible automation on the mainframe including all that goes with it. Impressive stuff!

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=0305ef2d-6900-8f96-660b-040c9265bda9

F17 Rock & Roll with Db2 for z/OS “Hey Db2, suggest music like zzTop” – This was a deep dive into SQL Data Insights on z/OS using Spotify as an example. It also shows the internals of the ML system used. It finishes with a „call to arms“ to get other people interested in the Host side of things. Slide 19 is very handy for all the Prereqs you will need.

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=7db8326f-7170-2c94-0f8f-03782f103ee7

Track G

G01 Database Design Basics. An excellent intro into DBMS’s and very good ideas about design especially for OLTP and OLAP and, one of my faves, naming standards for columns and tables!

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=7fd0c83e-9248-2500-5c5f-9062f282ee9b

G02 The Basics of SQL Queries: From Fetches to getpages and I/Os. Basically, an SQL 101 but contains a lot of good data. The use of buffer pools is well explained and how they can really help (see earlier presentations!) Strangely PROFILEs were *not* mentioned this time!

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=1119b400-8b89-71e9-f2da-7c08a7076eb5

G03 DB2 SQL – go beyond the usual – My current TOP 40 SQL tips, tricks, and opinions. Brian gave a great presentation about the modern features of SQL that you all should be using! Well worth reading.

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=2f992cd6-976a-f790-7cbf-09993cdce0ca

G04 Advanced Db2 Performance Tuning for Beginners. Joe doing his usual great work of showing how to really do SQL tuning. I especially liked the Filter Factors page!

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=c1a5c6dd-8771-78fa-507b-fb242ac3b7b3

G05 Back To Basics Real Time Statistics: What are they and how are they used? Another 101 style presentation but this time covering everything about the RTS tables and how you can, and should, use the data within.

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=33ac07e5-7967-60ec-b75c-2c9f6386ec9f

G10 IBM watsonx.data & Db2 Warehouse: Scale analytics and AI across the enterprise. All the low-down about watsonx including the „new“ governance part that we will all need to get full transparency.

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=3c9aa700-57c9-efb4-23d4-f18f30e239e6

G15 Db2 for z/OS administrative tooling strategy : Customer feedback, Roadmap, future direction & DEMO!! Naturally no demo here, but I am sure you can request one! All about Admin Foundation and the EOS of Data Server Manager in March 2024. It then went on to tell us why we should all be using Visual Studio Code and then adding in all the various extensions (Db2, SQL, COBOL etc. etc.). Here lies the future!

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=5f4fcb40-c631-d784-8da4-dace8ce19ee8

G16 Db2 AI for z/OS Strategy and Technical Deep Dive. Akiko took us on a tour! The two AIs out there now for Db2: SQL Data Insights (For free) and Db2 AI for z/OS (Not for free) now at version 1.6 and the latter was the topic that was discussed including System Assessment.

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=3142d8ef-7b0a-6695-f2f1-e6a0cb6c6885

G17 Db2 and Zowe. Everything, everywhere at once ! A run-through of Zowe over the years and also Developer extensions. If you are starting down the road of Zowe or Admin Foundation and Visual Code this is a good starting point!

https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=13479e3a-344f-82f8-9c28-4783c710f2d2

It was another really good IDUG with loads of excellent and interesting z/OS sessions. I hope to see you in Valencia in 2024 for EMEA or Charlotte for NA !

Please remember: You must be authorized to access the IDUG data and if the links fail please contact IDUG and not me 🙂

TTFN,

Roy Boxwell