Loading…
Attending this event?
Simple
Expanded
Grid
By Venue
Map
Sunday, October 27
 

09:00 CET

A201 | Infusing Db2 for z/OS with AI: Hands-on lab with IBM Db2 AI 1.6 for z/OS
Sunday October 27, 2024 09:00 - 13:00 CET
1 | Breakout 1
Get hands-on experience with IBM Db2 AI for z/OS, a powerful new offering built on machine learning. Learn how Db2 AI can: optimize SQL statements, provide Db2 system assessments with expert guidance for tuning your subsystem, use the Distributed Connection Controller to learn remote workload traffic and generate Db2 profiles to monitor and control remote connection access of Db2's distributed server for location, user ID, and application name, and monitor system performance with a new performance insight visualization dashboard.
Speakers
avatar for Diego Cardalliaguet
avatar for Vincent Rabsatt
Sunday October 27, 2024 09:00 - 13:00 CET
1 | Breakout 1
  Hands-On Lab

14:00 CET

A202 | Hands-on Lab: IBM Z Anomaly Analytics for Db2 Performance
Sunday October 27, 2024 14:00 - 18:00 CET
1 | Breakout 1
This lab session is provide the attendees the hands-on experience to explore how AI enabled monitoring solution, with a trained ML model, can help manage DB2 and z/OS performance to empower you to become more proactive before the problem damages the system.  The lab is hosted on an IBM live z/OS environment via internet.  The instructor will be on-site providing a lab guide and answering questions.  The lab guide gives step-by-step instructions to take you through Db2 problem solving scenarios with AI-ML scoring in action.  Bring your own laptop device, and we will set it up for you to login to this AI-ML lab on a live IBM Z system.
Speakers
avatar for Lih Wang

Lih Wang

Executive Client Technical Specialist, IBM
Lih M Wang is an Executive Client Technical Specialist at IBM Technology Software Group. She has over 30 years of experience in performance monitoring and tuning for IBM zSystems and Db2 in the software industry. For AI use cases, Lih has performed a variety of Proof-of-Concept projects... Read More →
Sunday October 27, 2024 14:00 - 18:00 CET
1 | Breakout 1
  Hands-On Lab

14:00 CET

C202 | The Building Blocks of Transformation: Bridging the Gap from the 3270 Terminal
Sunday October 27, 2024 14:00 - 18:00 CET
1 | Breakout 3
We hear a lot about the open mainframe, but what does it really mean?  Depending on your role and organization boundary, the definition of open mainframe can vary.  At Broadcom, our point of view on the open mainframe is essentially to enable those capabilities our customers need to effectively manage this critical component of their hybrid IT architecture, as services.  This is supported through our Database Management Data Service (DBM-DS) architecture built to be Zowe compliant, leveraging the many benefits provided by the Zowe API mediation layer (API-ML).  Come join our workshop to learn best practices for standing up a DBM-DS instance and API-ML which will then open the doors to many exciting use cases enabled through a web-based interactive user interface. 
Speakers
avatar for Andrew Badgley

Andrew Badgley

Lead Product Owner - Database Tools, Broadcom
avatar for Samantha Buhler

Samantha Buhler

Product Manager, Broadcom
Samantha Buhler has always worked in and around the mainframe, starting her mainframe career at IBM as a pricing and investment analyst for Db2 for z/OS and IMS.  In that capacity, she not only helped to deliver Db2 versions 8 and 9 to market but was also instrumental in making zIIP... Read More →
Sunday October 27, 2024 14:00 - 18:00 CET
1 | Breakout 3
  Workshop
 
Monday, October 28
 

11:30 CET

F2 | From the Statement Cache with Love
Monday October 28, 2024 11:30 - 12:30 CET
1 | Breakout 3 + 4
In today's modern applications, workload is increasingly shifting from traditional CICS or IMS transactions to Java workload. As a result, analyzing dynamic queries has become more important than ever before. 
In this presentation, I will demonstrate how to systematically analyze dynamic queries using the Global Dynamic Statement Cache, and how to identify queries that require immediate attention. We will develop a tool that allows SQL developers to analyze dynamic queries in their shop from day one after the conference. This tool is designed to be easily accessible and user-friendly, without requiring access to the mainframe. With it, developers can answer typical questions such as "Which queries performed better or worse within the last 30 days?", "Which of my queries were running at a given time and how did they perform?", and "Which of my queries are getting slower over time?" in a self-service mode. Additionally, we will explore how to translate query tuning results to cash savings, demonstrating the financial benefits of query optimization. By the end of this presentation, you will have a clear understanding of how to uncover and monetize hidden insights by analyzing the Global Dynamic Statement Cache.
Speakers
avatar for Thomas Baumann

Thomas Baumann

Data Evangelist, Swiss Mobiliar
Computer scientist by training, data scientist by practice, query tuner by spirit. Thomas is a fast learner with lots of curiosity, passionate about investigating mechanisms, causes and outcomes. Currently, his position is Data Evangelist at Swiss Mobiliar in Berne, Switzerland. When... Read More →
Monday October 28, 2024 11:30 - 12:30 CET
1 | Breakout 3 + 4
  Technical Session

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
avatar for Sowmya Kameswaran

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

16:30 CET

B5 | Db2 12: Amazon RDS for Db2 latest news and tips and tricks
Monday October 28, 2024 16:30 - 17:30 CET
0 | Auditorium 3A
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.
Speakers
avatar for Andrew Hilden

Andrew Hilden

Chief Architect Db2 on Cloud, RDS for Db2, IBM
Monday October 28, 2024 16:30 - 17:30 CET
0 | Auditorium 3A
  Technical Session

16:30 CET

C5 | Adaptive Workload Management: Latest Best Practices for Managing your Database
Monday October 28, 2024 16:30 - 17:30 CET
1 | Breakout 1 + 2
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.
Speakers
avatar for David Kalmuk

David Kalmuk

Distinguished Engineer, Analytical Databases, IBM
David Kalmuk is a Distinguished Engineer & Master Inventor and Chief Architect for Analytical Databases at IBM. David has contributed to the development of numerous technologies in Db2 over the years including BLU Acceleration, Workload Management, Monitoring, as well as much of Db2’s... Read More →
Monday October 28, 2024 16:30 - 17:30 CET
1 | Breakout 1 + 2
  Technical Session
 
Wednesday, October 30
 

16:30 CET

B13 | Db2 Connect - What's new and Best Practices
Wednesday October 30, 2024 16:30 - 17:30 CET
0 | Auditorium 3A
Db2 Connect is supposed to be a well-known topic but it is often not very well understood. This session shows the latest updates to Db2 Connect V11.5 and presents some of the best practices from conversations and interactions with customers. We cover topics such as installation, deployment, license activation, and configuration, including setting up TLS. In addition, we show why direct connectivity to Db2 mainframe servers is the preferred solution over Db2 Connect Servers, a.k.a. as Gateways.
Speakers
avatar for Christoph Theisen

Christoph Theisen

Principal Solutions Advisor, Rocket Software
Christoph is working as Principal Solutions Advisor for Rocket Software and located in Germany. Before joining Rocket in April 2021, he worked for three decades for IBM. Starting in IBM's Global Services unit in 1991 he worked in several client engagements - the majority related to... Read More →
Wednesday October 30, 2024 16:30 - 17:30 CET
0 | Auditorium 3A
  Technical Session

17:40 CET

E14 | Introduction to dashboards for Db2 for z/OS DBAs
Wednesday October 30, 2024 17:40 - 18:40 CET
0 | Auditorium 3B
The ability to explore, analyze, and visualize data is becoming a hot topic. As DevOps is adapted by the mainframe community the developers show an increasing interest in the Ops side, i.e., being able to monitor and view the health of an application. While showing data in 3270 is not bad there are many advantages of using modern tooling to visualize data. 
In the first half of the presentation, we will give a high level introduction to modern open source visualization tools like Kibana and Grafana. 
In the second half of the presentation we will explore several use cases of interest to Db2 for z/OS DBAs and application owners and developers, such as viewing Db2 real time statistics, Db2 utility history and Db2 performance metrics. Ultimately this allows you to build dashboards tailored to individual applications.
Speakers
avatar for Jørn Thyssen

Jørn Thyssen

Principal Solutions Advisor, Rocket Software
Jørn Thyssen joined Rocket in 2017 as a Solutions Advisor specializing in Db2 tools bringing in 16 years of experience working with IBM z technology and Db2 for z/OS. He specializes in mainframe modernization, Db2 administration, and Db2 performance supporting customers across the... Read More →
Wednesday October 30, 2024 17:40 - 18:40 CET
0 | Auditorium 3B
  Technical Session
 
Thursday, October 31
 

09:00 CET

A15 | Exploiting Db2 DDF without fears or revelations
Thursday October 31, 2024 09:00 - 10:00 CET
0 | Auditorium 2
The presentation will concentrate on the use and evolution of Db2 DDF access from its infancy to a leading OLTP transactional model that organizations are relying on. During the session industry infrastructure and application usage best practices will be discussed. Db2 for z/OS SWAT team customer experiences will be shared, what has worked and the challenges that have been experienced. In addition to DDF access dynamic SQL fears and concerns will be targeted. The overall objective of the session is to share best practices and success stories and to calm any revelations around DDF from an infrastructure and application perspective and organizations increasingly exploit the technology.
Speakers
avatar for Anthony Ciabattoni

Anthony Ciabattoni

Db2 for z/OS SWAT Team Leader, IBM
Anthony Ciabattoni is an IBM Certified Executive IT specialist and a current member of the Db2 for z/OS Development SWAT team based out of the Silicon Valley Lab with over 30 years of working directly with Db2 for z/OS. His experience includes be a customer lead Db2 architect as well... Read More →
Thursday October 31, 2024 09:00 - 10:00 CET
0 | Auditorium 2
  Technical Session

09:00 CET

C15 | A new way to migrate your Db2 for z/OS systems has arrived!
Thursday October 31, 2024 09:00 - 10:00 CET
1 | Breakout 1 + 2
In this session we will demonstrate how you can exploit recent innovations to automate the generation of Db2 migration artifacts for a traditional or with the usage of IBM Z/OSMF workflows to install and / or migrate a Db2 subsystem or members of a data sharing group. We will demo to you how the artifacts can be generated. Next, we will show how these artifacts are assembled into a workflow. Finally, we will give a preview how we are evolving to auto-discover all the Db2 installation configuration parameters.
Speakers
avatar for Sueli Almeida

Sueli Almeida

IBM Certified Thought Leader, IBM
Thursday October 31, 2024 09:00 - 10:00 CET
1 | Breakout 1 + 2
  Technical Session

09:00 CET

D15 | I REST my case! Exploit API's for productivity
Thursday October 31, 2024 09:00 - 10:00 CET
1 | Breakout 8
Come to this session to learn about the value that REST APIs can bring to your shop. You will find that it is not nearly as tough as it may look. I will explain the how using some working examples.
Speakers
avatar for Toine Michielse

Toine Michielse

Solutions Architect, Broadcom
I have been working with Db2 for z/OS ever since V1. In my career I have worked as COBOL/IMS/DB2 programmer, IMS/DB2 DBA and DB2 system engineer. I have worked a number of years as a Db2 Lab advocate, supporting IBM customers worldwide. Before joining Broadcom I worked at SwissRe... Read More →
Thursday October 31, 2024 09:00 - 10:00 CET
1 | Breakout 8
  Technical Session

09:00 CET

E15 | Beyond DB2 Comfort Zone: From Performance Optimization to Automation to Cloud
Thursday October 31, 2024 09:00 - 10:00 CET
0 | Auditorium 3B
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.
Speakers
avatar for Nemi Agrawal

Nemi Agrawal

IT Executive, Raindrops Inc.
emi Agrawal has extensive experience in leading strategic and complex solutions often cutting across organizational lines for mission critical systems at the Department of Homeland Security/Customs and Border Protection (DHS/CBP) and financial industry. His expertise in leading databases... Read More →
Thursday October 31, 2024 09:00 - 10:00 CET
0 | Auditorium 3B
  Technical Session

09:00 CET

F15 | Example of Disaster Recovery config in Mainframe&Distributed environment
Thursday October 31, 2024 09:00 - 10:00 CET
1 | Breakout 3 + 4
The presentation will be divided into 3 parts:
1. DR recommendation for Mainframe environment focusing on DB2 z/OS
DR cosiderations: What technology? What data? What purpose?
- popular DR myths word thinking about
- is there any recommendation other than 'It depends'?
2. DR configuration in mixed environmentPresentation will cover real production configuration for core banking application from Disaster Recovery point of view. Applications runs on Mainframe and Linux/Windows environment, both parts of app are important and data consistency between them is crucial. 
Application consumes :
a.      few thousand of MSU on Mainframe
b.     about 100 TB of data on Mainframe
c.      more than 50 physical intel servers 
d.     about 150 TB of data on distributed
Presentation describes the approach for db2 z/os and files data consistency between two platform. The approach for building and testing disaster recovery procedures will be presented. 
3. Golden Copy verification in mixed environmentsPresentation will cover the idea of creating consistent backup before each batch processing, short description of configuration will explain the idea of approach for backup.
All aspects of configuration and testing (consistency) Golden copy backup will be described.
Speakers
avatar for Mateusz Książek

Mateusz Książek

Db2 Administrator, PKOBP
Technical Leader in mainframe modernization project - Cross platform monitoring design & performance analysis(mainframe/distributed) - Application migration to distributed env - Dr architecture for cross platform env - TroubleshootingDB2 system AdministratorDB2 performance monitoring... Read More →
Thursday October 31, 2024 09:00 - 10:00 CET
1 | Breakout 3 + 4
  Technical Session

10:20 CET

F16 | R.I.P. IBM Data Studio
Thursday October 31, 2024 10:20 - 11:20 CET
1 | Breakout 3 + 4
Data Studio has long been the standard desktop interface for Db2 for z/OS (alongside traditional ISPF). But  with Data Studio support for Db2 for z/OS ceasing in March 2025 what is replacing it?
This session will look at the 2 (free) products that are replacing Data Studio - Db2 Admin Foundation, and the Db2 for zOS Developer Extension for VSCode. We will look at the prereqs for the solution's, discuss the personas that each is targeted at, and look at the functionality available in each product.
If technology is on my side I will also attempt to do a live demo.
Speakers
avatar for Mark Turner

Mark Turner

Db2 Technical Lead and Mainframe Devops Lead, NatWest
Mark Turner is the Senior Technical Lead for Db2, responsible for Db2 strategy and roadmap at NatWest. He has more than 35 years’ experience working with Db2 on z/OS covering many areas including general database administration, Db2 infrastructure design, application and system... Read More →
Thursday October 31, 2024 10:20 - 11:20 CET
1 | Breakout 3 + 4
  Technical Session

14:30 CET

B203 | The next generation of services for Db2 administration and development workshop
Thursday October 31, 2024 14:30 - 18:30 CET
0 | Auditorium 3A
Bring your own device to this workshop, where you will have a chance to perform a hands-on lab to experience the latest deliverables towards Db2 user transformation. 

Db2 administrator personas can execute some of their daily tasks in a more intuitive way via Db2 Administration Foundation and its integration with Db2 Tuning Services, Query Workload Tuner and IDAA Administration services.  Last but not least, administrators can also benefit from Db2 DevOps experience (DBaaS) to “shift-left” database operations to application developers under their rules and administrative directives.
Db2 application developer personas can develop / test and deploy application changes that also require database change in a speed that business demand. Using Db2 Developer Extension in IDE will simplify coding of SQL including native stored procedure code. Using Db2 DevOps Experience services (DBaaS), developers can, on demand, self-service database operations under the rules previously established by the Db2 administrators. 
Speakers
avatar for Sowmya Kameswaran

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 →
Thursday October 31, 2024 14:30 - 18:30 CET
0 | Auditorium 3A
  Hands-On Lab

14:30 CET

C203 | The HADR with Pacemaker for Cloud Deployments Workshop
Thursday October 31, 2024 14:30 - 18:30 CET
0 | Auditorium 3B
Db2 databases support the High Availability needs of many customers today. Db2 v11.5.5.0 saw the general availability of High Availability with Pacemaker on the Linux platform, providing a newer, Cloud-ready alternative to the TSA implementation. Newer releases have added support for AWS, Azure and Google Cloud environments, and many other refinements.
This workshop will give you hands-on experience for managing a Db2 HADR with Pacemaker Cluster on Microsoft Azure, Google Cloud or AWS. The session will cover the Cloud specific Implementation of Fencing and virtual IP Addresses. It will help you understand the information provided by the cluster utilities, across basic operations, diagnostics, and best practices from the IBM Labs This workshop will also demonstrate basic problem scenarios, troubleshooting and collection of essential support data to accelerate problem resolution in emergency cases.
Speakers
avatar for Thomas Rech

Thomas Rech

IT Architect, IBM Germany
Thomas has been working in the Db2 area since 1996. Starting as a Db2 course instructor, he soon moved to the SAP on Db2 environment in 1997. He joined the SAP/IBM Db2 Development Team, followed by a role as technical sales consultant. He led several lighthouse projects like the... Read More →
Thursday October 31, 2024 14:30 - 18:30 CET
0 | Auditorium 3B
  Workshop
 
Share Modal

Share this link via

Or copy link

Filter sessions
Apply filters to sessions.
Sunday, October 27
Monday, October 28
Tuesday, October 29
Wednesday, October 30
Thursday, October 31
0 | Auditorium 2
0 | Auditorium 3A
0 | Auditorium 3B
1 | Breakout 1
1 | Breakout 1 + 2
1 | Breakout 2
1 | Breakout 3
1 | Breakout 3 + 4
1 | Breakout 8
1 | Multi 1A
1 | Multi 1C
1 | Multi 1D
2 | Multipurpose Room / Solution Center
Los Toros at Les Arts
Melia Rooftop
TBA
  • Badging & Certification
  • Break
  • Coffee Break
  • Expert Panel
  • Hands-On Lab
  • IDUG Fundamentals
  • Keynote
  • Lunch
  • Opening Comments
  • Partner-Sponsored Presentation
  • Solution Center
  • Special Event
  • Technical Session
  • Workshop
  • Company
  • BMC
  • Broadcom
  • IBM
  • SEGUS
  • Subject
  • AI / ML
  • AppDev
  • Cross Platform
  • LUW
  • z/OS
  • Area
  • AI and GenAI
  • AI Generation and Machine Learning
  • AppDev
  • Automation
  • Back to Basics
  • Badging & Certification
  • Best Practices
  • Data Movement and Analytics
  • Data Movement and Integration
  • Database Resiliency
  • Db2 Cloud and Warehouse
  • Expert Panel
  • Fundamentals
  • Latest and Features LUW
  • Latest and Features z/OS
  • Machine Learning
  • Modernization in Development
  • Modernization in Operations
  • Performance and Monitoring
  • Security and Compliance
  • User Stories
  • Utilities
  • Working with SQL