IDUG NA 2025

The joining of two or more tables in SQL is a great feature of the SQL language.  So often we need to combine data from more than one table into the same row output.  Depending on your logic needed, the language provides us with different types of joins.  This presentation starts off basic and builds into more in–depth logic and performance when having the need to process more than one table in a query. The different types of joins presented are: 
Inner Joins (Inner join vs comma delimited syntax) 
Left Outer Joins
Right Outer Joins
Full Outer Joins
Outer Joins with 'On clause Extensions'
Self Joins (Same table in FROM clause more than once)
This presentation will:

Take you deeper into SQL join logic
Help udertstand when specific joins are needed 
Understand the performance of joins
Understand 'On Clause Extensions' and when to use them
Understand the need for the same table in FROM clause more than once *Self Joins)

Every enterprise, with Db2 for z/OS as core database, have application modernization modernization plans in the context of Db2 for z/OS. Topics like, hybrid cloud, data fabric, data lakehouse are all bringing architecture and product level topics in front of the Db2 DBA. 
In this presentation following topics will be presented with technical details to prepare a Db2 for z/OS DBA for

Modernizing direct access to Db2 for z/OS data from the cloud via ODBC, JDBC, Rest
Architectural alternatives to provide Db2 z/OS data into the cloud native applications world
Virtualization options to access mainframe data including Db2 for z/OS
How to provision a copy of Db2 for z/OS data in the cloud for high–volume query and/or analytics use cases.
Technical details of Integrated Synchronization which is the core replication protocol from Db2 for z/OS to the cloud in the context of Db2 DBA 

Technical and business use cases will be part of the presentation so that Db2 for z/OS  DBA will be aware and contribute to the decision making process

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.

Db2 Family Tools Update
In this Db2 family topic we will delve into two key areas of tooling for Db2 LUW including the new and exciting Db2 AI Assistant, leveraging GenAI to bring value to DBAs – and – a common, simplified Db2 data movement tool called Db2 Bridge which will help manage all the different ways in which data can be moved around the Db2 ecosystem.

SQLDI and Db2zAI Update
In this topic two key AI capabilities of Db2 for z/OS will be provided in detail.

Join the IDUG Content Committee for this fun interactive session where you will deepen your knowledge of SQL. This session will focus on the use of table expressions. We will have a short presentation and there will be an opportunity to sharpen your skills with others dojo style.