IDUG NA 2025

The increased regulatory requirements following the banking crisis in 2007 required Finanz Informatik (the IT service provider of the Sparkassen–Finanzgruppe which contains all 353 German savings banks) to make some changes to its data warehouses:In addition to being able to generate reports for any point in time in the past, it was also necessary to support the requirement for ad–hoc reports. Finanz Informatik decided to address these challenges by using Db2 on AIX with BLU Acceleration and bitemporal tables.This presentation will discuss the experiences and lessons learned which Finanz Informatik gained during this project with these technologies.

Want to allow real–time representations of your Db2 for z/OS, Db2 for LUW or even db2 Warehouse on Cloud data to be leveraged as Data Lake, Event Streaming, Cloud Database, and more destinations?  Want to be free to create tables, alter them, apply data and have these changes seamlessly represented in a multitude of data formats and destinations? 
The IBM Data Replication Cartridge is a brand–new cloud architected solution leveraging cloud native convenience while leveraging more than 20 years’ experience with the definitive data replication product, IBM’s IIDR CDC. 
Learn the convenience, robustness, simplicity, and performance that the new cloud native architecture provides.  
We’ll highlight:
1)        Sate of the art functionality:  Never before seen replication functionalities, such as seamless DDL replication and intuitive intention–based user semantics.
2)        The Key to Performance: Highlights of the product architecture that simultaneously parallelizes workload applies Kafka while adaptively applying OLTP changes to aggregate apply preferring WatsonX Data Lake destinations.
3)        Demonstration of data replication showing ease of use and robustness of a cloud based replication architecture.
4)        Customer use cases highlighting the best patterns for using replication to perform real–time event streaming and contrasting WatsonX Data Lake Analytics scenarios.

A look at the new SQL capabilites added to Db2 v12 as well as a look back at some of the lesser known additions in 11.1 and 11.5 mod packs.  A deep dive into new namespace isolation capabilities provided via the TENANT concept. A peek into the Vector store extensions coming to Db2 and a look at how Db2 can integrate into a lakehouse strategy.

Amazon RDS for Db2 provides a managed Database on AWS. While this makes the solution really easy to get started with, there is a lot of things under the covers that can help you better use the system.  This session will go over some of the technical details under the covers of RDS for Db2 and also provide a series of Tips and Tricks when using RDS. It will go over some money saving strategies you can use as well as give an introduction on how you can migrate workloads to Amazon RDS for Db2.