IDUG EMEA 2024

Db2 12 on Amazon RDS for Db2 will be discussed along with a set of tips and tricks on getting the most of Db2 running in AWS.

Db2’s Adaptive Workload Management technology vastly simplifies the task of dividing your database resources across workloads to ensure they meet their performance objectives. Unlike traditional workload managers it manages the admission of jobs based on their actual resource needs and intelligently schedules them based on the resource targets you assign, ensuring stable and reliable performance even in the face of the most highly concurrent workloads. Join David Kalmuk, the architect of the Adaptive Workload Manager, for an update on new enhancements in the latest release and best practices that will allow you to get the most out of this technology.

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.

Learn about the new features and improvements for Data Warehousing in Db2 12.1

How much data could your organisation afford to lose?
Is your current backup and recovery strategy good enough?
With the mainframe being the system of record for 80% of the world’s data, it is imperative that your data resilient under any scenario, including the dreaded ransomware attack. Please join us as we walk through what the impending DORA legislation means for you. You will gain an understanding of the current state of Db2 Security and Backup and Recovery strategies, an awareness of DORA, its implications to your recovery strategy, and the consequences of not being prepared for it.

Complex database operation on Power system to support very high transactional volume of 80,000/secondsNear realtime HA/DR with a split seconds recoveryAutomated upgrades and configuration to maintain 500 plus databases with few resources and high level resilienciesSharing the best practices to work with IBM L3, CritSit and special teams to improve IBM/DB2 for this complex and mission critical databaseAll migrations efforts with current offering from IBM and AWSIn-house CDC solution where market driven tools like DMS/Infospehere fails.

I already showed howto work on Db2-Databases with Ansible and Python in previous IDUG sessions. This time around I'm going to guide you through the process on how to use Db2 as a configuration repository for Ansible. Runtime configuration for Ansible playbooks is usually done by the ansible inventory (usually requires a pull request) and, for runtime configuration, "extra-vars". This can be cumbersome in large environments and does not bear much flexibility. The result is usually an increase of AWX/Ansible-Tower templates for different configurations and targets. Furthermore, the templates (and surveys) get increasingly complex and uncomfortable to handle. Keeping runtime configuration data in a centralized database gives ample oportunity to create and maintain arbitrarily complex runtime configurations in one or multiple Databases with SQL so that the user does not need to know anything about Ansible at all, minimizing operational overhead.I will show how to implement this with the help of a few lines of python code. Live-elements will be pre-recorded if needed. Code will be available on GitHub.

Db2 Warehouse (on prem and on cloud) as well as Db2 11.5 FP9 now allows users to work directly with the datalake tables, using open data file format- Parquet - ORC- Avro- Text and JSON
Presentation will show how Db2 works with the open data formats organized as both Hive and Iceberg tables, how the data is stored internally in the object store and compare this type of data to native Db2 tables. It will also explain topic of metadata and metastore integration with other query engines available in watsonx.data

Every enterprise, with Db2 for z/OS core database, have plans for application and data modernization in the context of Db2 for z/OS. Topics like, Hybrid cloud, data fabric, data lakehouse are all bringing new architectures and product level topics in front of every Db2 DBA and Db2 Sysprog. 
This session prepares all Db2 for z/OS DBAs for the following topics in detail. 

Modernizing direct access to Db2 for z/OS data from the cloud via ODBC, JDBC, Rest APIs 
How analytics infrastructures implemented inside or outside of IBM Z will be managed, administered, and monitored by Db2 DBAs.
What are the virtualization options of the mainframe data and specifically Db2 for z/OS. How the DBA will control this virtualized access? 
How to provision a copy of Db2 for z/OS data in cloud for high-volume query and/or analytics use cases. 
Technical details of Integrated Synchronization which is the essential replication protocol from Db2 for z/OS to the cloud.