IDUG EMEA 2024: Full Schedule

08:45 CET

IDUG Opening Comments

Monday October 28, 2024 08:45 - 09:00 CET

0 | Auditorium 2

Monday October 28, 2024 08:45 - 09:00 CET
0 | Auditorium 2

Opening Comments

Subject AppDev

16:30 CET

A5 | Automate Db2 database changes into a DevOps pipeline

Monday October 28, 2024 16:30 - 17:30 CET

0 | Auditorium 2

We will illustrate how in an agile cloud native environment, applications developers can easily use the self-service facilities to make changes, test, commit, push, automate deployment with automated CI/CD pipeline. Such changes can only be done within pre-established rules set by DBA and other administrators.This presentation will show the steps a developer would take to modify an application including database changes and additional objects. A central part of the presentation will be a demo of DevOps facilities.
We will illustrate how in an agile cloud native environment, applications developers can easily use the self-service facilities to make changes, test, commit, push, automate deployment with automated CI/CD pipeline. Such changes can only be done within pre-established rules set by DBA and other administrators

Speakers

Sowmya Kameswaran

Technical Leader, IBM

I lead the modernization portfolio for IBM Db2 product line. My charter encompasses product design & development, vendor & customer relationship, external & internal product communication. As part of my leadership role, I mentor and manage full-stack software developers. I am responsible... Read More →

Monday October 28, 2024 16:30 - 17:30 CET
0 | Auditorium 2

Technical Session

Subject AppDev
Area AppDev, Automation, Data Movement and Integration, Best Practices, Modernization in Operations, Modernization in Development

11:30 CET

D11 | Optimization 101: What Makes Db2 Choose Certain Access Paths

Wednesday October 30, 2024 11:30 - 12:30 CET

1 | Breakout 8

What makes Db2 chose certain access paths? Why that index? Why that join method?
There are many things that the optimizer code looks at when determining an access path to retrieve the requested data for a query. This presentation will focus on the main areas that drive the optimizer choices, what control we might have over some of them, and some of the defaults that take place. This is a 'must see' for those that want to get stronger in performance and tuning and undertand many of the basics.

Speakers

Tony Andrews

Developer, Trainer, Performance and Tuning Consultant, P&T Solutions, Inc.

Tony Andrews has more than 25 years’ experience in the development of relational database applications. Most of this time, he has provided development and consulting services to Fortune 500 companies and government agencies. Tony has written literally thousands of queries and programs... Read More →

Wednesday October 30, 2024 11:30 - 12:30 CET
1 | Breakout 8

Technical Session

Subject AppDev
Area Back to Basics, Performance and Monitoring, Working with SQL