IDUG EMEA 2026: Full Schedule

arrow_back View All Dates

10:20am BST

A10 Linuxification of Db2 for z/OS - a journey from ISPF and JCL to Shell and Playbooks

Wednesday September 30, 2026 10:20am - 11:20am BST

This session will be about bridging existing legacy programs with "modern"interfaces, such as the Unix shell and Ansible. Next-generation mainframers are typically well-versed in Unix shells and scripting, largely due to Linux's dominance in the server market. But how does this apply to traditional mainframe tools? That is what we want to show you.

Speakers

Emil Kotrc

Principal Software Architect, Broadcom

Emil is a software architect at Broadcom Mainframe Software, he holds a Ph.D. in Mathematical Engineering, is a member of the IDUG Content Committee, and an IBM Champion since 2015.

Marketa Muzikova

Software Architect, Broadcom

Markéta is an experienced software engineer with expertise in mainframe automation, including Ansible and Zowe. Markéta is a recognised expert on Ansible and facilitates the Broadcom Ansible Collection.

Wednesday September 30, 2026 10:20am - 11:20am BST
Infante

Track A, Technical Session

Topic Automation, Latest and Features z/OS, Modernization in Operations
Audience Beginner
Platform z/OS

10:30am BST

IDUG Db2 for LUW Essentials

Wednesday September 30, 2026 10:30am - 5:30pm BST

Glass 1

Speakers

Davor Rodnis

IDUG Db2 for LUW Essentials Instructor

Davor is an expert trainer and consultant with 30+ years’ experience in Db2. He specialized in providing Db2 and other training services for IBM customers in over 25 countries according to global standards. He has taught over 300 courses on IBM software products as an IBM Authorized... Read More →

Wednesday September 30, 2026 10:30am - 5:30pm BST
Glass 1

Essentials, Essentials

Audience Beginner

10:30am BST

IDUG Db2 for z/OS Essentials

Wednesday September 30, 2026 10:30am - 5:30pm BST

Noble

Speakers

Dougie Lawson

IDUG Db2 for z/OS Essentials Instructor

Wednesday September 30, 2026 10:30am - 5:30pm BST
Noble

Essentials, Essentials

Audience Beginner

11:30am BST

E11 Exploring Db2 explain facility for the next Gen of Db2 DBAs and using AI to bridge the skills gap.

Wednesday September 30, 2026 11:30am - 12:30pm BST

Luis

Poorly written or optimized Db2 SQL queries can use huge amounts of CPU and render applications unusable causing business impact.
This session will cover the different types of access paths the Db2 Optimizes uses to return data for queries and discuss their merits and use cases. We will look at the data written by the DB2 optimizer in the EXPLAIN tables and how we can interpret the data using AI to determine if an SQL is going to be cheap or expensive to run.
The session will cover filter factors and the role of RUNSTATS on access path selection and cover how one can influence the access path.

Speakers

Phill Baker

Software Consultant, BMC

A passionate technologist specializing in BMC mainframe solutions. Twenty plus years experience working as a Database engineer across Db2, SQL Server, MySQL and Oracle. Working on mainframe z/OS, AIX, Linux, UNIX and Windows, supporting large scale data warehouse applications to... Read More →

Wednesday September 30, 2026 11:30am - 12:30pm BST
Luis

Track E, Technical Session

Topic Back to Basics
Audience Beginner
Platform z/OS

4:30pm BST

B13 Introduction to SQL-PL

Wednesday September 30, 2026 4:30pm - 5:30pm BST

Arrabida

In this session, we'll go back to basics and look at SQL-PL, Db2's built in server-side application logic. We'll take a look at the code constructs and how to leverage in stored procedures, user defined functions and triggers. We'll also look at more complex scenarios like code for a Data Partitioning Feature (DPF) environment. The majority of this session will be looking at and executing source code.

Speakers

Les King

DBA, Db2 technical lead, Les King Learning, Seneca College

Les King is a part-time professor at multiple Ontario Colleges, offering courses in Mathematics, Programming and Data Management. Les has also been an instructor at the University of Toronto in the Mathematics department. Les effectively draws a connection between what the marketplace... Read More →

Wednesday September 30, 2026 4:30pm - 5:30pm BST
Arrabida

Track B, Technical Session

Topic AppDev, Modernization in Development, Working with SQL
Audience Beginner
Platform LUW

IDUG EMEA 2026

10:20am BST

Emil Kotrc

Marketa Muzikova

10:30am BST

Davor Rodnis

10:30am BST

Dougie Lawson

11:30am BST

Phill Baker

4:30pm BST

Les King

Get help with the event