IDUG EMEA 2026: Full Schedule

arrow_back View All Dates

10:20am BST

D6 Permitting, masking and trusting, a deep dive into 3 new Db2 12.1 security features

Tuesday September 29, 2026 10:20am - 11:20am BST

This session is a deep dive into 3 new Db2 12.1 security features, Reduce file permissions, RCAC mask at read enhancements, and defining a Trusted Context using the new trust procedure and client callbacks. This will be a face paced session offering practical details on how to make use of these new features in more depth than a what's new session can cover. Reduced file permissions address the common concern of everyone having access to the db2diag.log (and others). Mask at read offers an alternative masking behaviour with fundamental changes to SQL behaviour. And Trust Procedures allow custom definitions of trust for determining a trusted connection.

Speakers

Greg Stager

Senior Software Engineer, IBM

Greg Stager is the security architect for Db2 LUW at the IBM Toronto Lab. Greg has been a member of the Db2 security development team since 2000, where he has worked on all aspects of security within Db2, including authentication, authorization, auditing and encryption.

Tuesday September 29, 2026 10:20am - 11:20am BST
Maria

Track D, Technical Session

Topic Best Practices, Latest and Features LUW, Modernization in Operations, Security and Compliance
Audience Intermediate
Platform LUW

11:30am BST

D7 Near zero downtime migration to Db2 12.1

Tuesday September 29, 2026 11:30am - 12:30pm BST

Maria

When upgrading to Db2 12.1 additional activities like OS upgrade or cluster technique change might occur. In addition, test migrations should be possible with no or minimal impact on a productive system. The presentation shows, how Db2 can be migrated to 12.1 including OS upgrade scenarios and cluster technology changes, build on pure Db2 functionality. It describes a near zero downtime solution. With it's repeatability, the solution can easily be used for pre-migration testing.

Speakers

Christiane Beyer

Senior Solution Engineer, Arvato Systems GmbH

Experienced IT professional with over 25 years experience in database administration on LUW.
Specialized in IBM Db2 on Linux over 10 years. Supporting High Availability Systems in health care & financial sector, which are based on IBM Db2 HADR TSAMP & Pacemaker Cluster.

Tuesday September 29, 2026 11:30am - 12:30pm BST
Maria

Track D, Technical Session

Topic Best Practices
Audience All
Platform LUW

2:00pm BST

D8 SQL in Action: One Statement to Rule Them All - MERGE and integrated SQL operations

Tuesday September 29, 2026 2:00pm - 3:00pm BST

Maria

If multiple statements can be combined into a single one it will be more efficient.
In this session we will explore multiple options to combine different SQL statements. Have you ever used the FINAL TABLE clause or selected the data you just deleted? Besides this the main focus is on the MERGE stamement which is probably the most powerful SQL operation which offers a lot of processing options and can even be used in ETL architectures and with temporal tables. Practical use case will be shown and explained.

Speakers

Michael Tiefenbacher

Distinguished Engineer, Broadcom

Michael Tiefenbacher holds a Master of Science degree from the Munich Institute of Technology. He began his career as a Db2 trainer and was instrumental in introducing IBM’s Business Intelligence course curriculum in Germany.
With more than 25 years of experience in projects an... Read More →

Tuesday September 29, 2026 2:00pm - 3:00pm BST
Maria

Track D, Technical Session

Topic AppDev, Data Movement and Integration, Working with SQL
Audience Intermediate
Platform LUW

3:20pm BST

D101 Coming Soon

Tuesday September 29, 2026 3:20pm - 4:20pm BST

Maria

Tuesday September 29, 2026 3:20pm - 4:20pm BST
Maria

PSP, PSP

Topic PSP

4:30pm BST

D9 More SQL tricks with Db2

Tuesday September 29, 2026 4:30pm - 5:30pm BST

Maria

SQL is a very powerful language. But to make best use of it one has to come to a "set-oriented" thinking to solve problems instead of the procedural thinking most application programmers are used to. This presentation discusses some important problems for which a set-oriented solution is initially not obvious, and shows how solutions of these problems can be developed with SQL in Db2. This presentation is a continuation with new problems and solutions of the presentation "SQL tricks with Db2" shown at IDUG EMEA 2024.

Speakers

Andreas Weininger

Principal Information Architecture Technical Specialist, IBM

Andreas Weininger is part of the Information Architecture team of IBM in Munich. He has more than 20 year of experience with scalable solutions for data intensive solutions focussing especially on the performance aspects. He is a regular speaker at database and data warehousing events... Read More →

Tuesday September 29, 2026 4:30pm - 5:30pm BST
Maria

Track D, Technical Session

Topic AppDev, Best Practices, Working with SQL
Audience All
Platform LUW

IDUG EMEA 2026

10:20am BST

Greg Stager

11:30am BST

Christiane Beyer

2:00pm BST

Michael Tiefenbacher

3:20pm BST

4:30pm BST

Andreas Weininger

Get help with the event