IDUG EMEA 2024

In the ever-evolving landscape of database management, ensuring the availability and swift recovery of critical data has become paramount. This presentation dives into the latest enhancements and changes upcoming in availability and recovery with Db2’s Next Release to help you get the most out of your investment and defend against potential disruptions.

There are many migration scenarios in which common tools like Backup/Restore or LOAD cannot be used, whether because of compatibility issues, too much manual doing, or lack of downtime.
In this session, I will go into detail of a self-made tool, which on top of Q-Replication makes it possible to migrate almost any DB, regardless of size, complexity, endianness or encoding in an effortless manner with near-zero downtime

This presentation will provide the ongoing success story Db2 z/OS Version 13 and covers the latest experiences with Db2 13 at Commerzbank AG. It will talk about some key important areas which are essential for the success and how to prevent some known avoidable pitfalls. We share the important latest experiences of the last 12 months, explains the upcoming and validated best practices in several key areas. This session will also dive into Function Level details and dependencies up to the latest FL 504 (/505), maintenance aspects, some tooling dependencies and some performance aspects as well as base utilities and system functionalities.

In recent years, the Db2 for z/OS Utilities development team has delivered many exciting features in availability, usability and performance improvements, as well as the utility history support that empowers further automation and optimization in utility execution. This session will cover what you need to know about these exciting features, many of which you can take advantage of today.

We need to move our production database to a new “machine”, or upgrade it to a new version of Db2.   But, we cannot take an outage (longer than a very few minutes).  How can we do that?  What tools are available?   This presentation is a follow-up to last year’s “AIX to RHEL conversion” presentation.  In that case, we were moving small dev environments from AIX to RHEL.  Now it’s SHOW TIME!   It’s time to do Production environments.   What are the strengths and weaknesses of each available tool?   What should we use and what challenges will we encounter?

Quickly and Easily solve your most demanding Db2 utility challenges using the latest capabilites available in the BMC AMI Db2 utilities. This presentation covers the latest enhnacements in the BMC utilities for Db2 zOS. Come learn how BMC customers solve their hardest operational problems every day using the Db2 utilities from BMC. Gain deep insights on the advanced performance, useability and automation features available today in the BMC Db2 Utilities that set us apart from the competion. 

In a 24×7 world, the expectation is that databases are always available, especially those that target OLTP workloads. Within the Db2 family, pureScale is the shared-disk clustering solution that aims to achieve zero downtime for this 24x7 world through an architecture that provides the highest availability for the most demanding OLTP workloads. In this talk we will discuss the improvements we made to pureScale's Index Reorg Rebuild, one of the fundamental day-2 maintenance operations, to allow an index to be completely rebuilt without taking an outage. The architect of the feature will cover the nuts and bolts of the new Db2 pureScale Online Index Reorg Rebuild feature's design, including its processing stages, configuration and monitoring options, and best practices to use it and achieve the highest availability.

A well-established Test Data Management (TDM) ensures the availability of realistic and representative data for testing purposes. DBAs benefit from an efficient test data provisioning process, while developers leverage diverse test data sets to validate application functionality, performance, and scalability, ultimately leading to higher-quality software releases. In this session, we will explore best practices for establishing TDM processes for Db2 for z/OS data. We will review and discuss possible approaches and techniques, including the additional value those with Broadcom Utilities can derive.

In the Db2 world, there are many choices when it comes to Data Movement Utilities. But what's the difference, and which one should you choose? This presentation will discuss the various Data Movement Utilities: LOAD, IMPORT, INGEST, EXPORT and others. We will go over the key differences and which utility is right for your job. Find out about performance comparisons of the various utilities, and how to monitor your job.

Let Db2 take care of the audit data automatically, w/o having to run external Jobs in order to archive and extract the audit logs.This is a presentation about the handling of audit data in a customer project at REWE digital in Germany. Since Db2 10.5 FP4 (Cancun), it's possible for the extract of audit logs, to write that data to SYSLOG on Unix (AIX & Linux) systems.
Customer wants to get rid of scheduled external jobs, which have to run in intervalls against every db2 instance (more than 150) in their environment in order to archive and extract the audit data for instances and databases.
The session will give insight into the realisation of the project using Db2's internal administrative task scheduler and procedures in oder to extract the audit data directly to SYSLOG files and let QRADAR take the data directly from that single source per system for further processing.
Monitoring of the audit processing will be another main aspekt of this session.