Loading…
Welcome to The AI Era Conference 2026: Shaping Tomorrow’s Intelligence Today!

Join us as we navigate the transformative landscape of AI, forge connections, and unlock the potential of tomorrow’s possibilities. Let’s embark on a journey towards a more intelligent future together!
Audience: Intermediate clear filter
arrow_back View All Dates
Monday, October 27
 

11:30am WIB

D2 | Turn red into blue
Monday October 27, 2025 11:30am - 12:30pm WIB
Database migration from one relational database management system to another can be a challenging task and risky for the business.
In this session, we will explain a step-by-step process of a real world BaFin scenario to migrate databases from Oracle to Db2.
In addition to the technical challenges, there are other important tasks that are part of a database migration, such as the assessment of self-developed and third-party software, test concepts, and the automation of data transfer.
We will talk about the most important considerations, migration tools and best practices to ensure a successful migration.
Speaker
Monday October 27, 2025 11:30am - 12:30pm WIB
Aristoteles 2
  Workshops

2:00pm WIB

A3 | Db2 13 for z/OS - Five Key Features to Drive Performance and Innovation
Monday October 27, 2025 2:00pm - 3:00pm WIB
Db2 for z/OS continues to evolve with features that make database management more efficient, scalable, and responsive. Recent enhancements in Db2 for z/OS focus on making database administration more efficient, with tools and features that automate processes, improve performance, and minimize downtime.
Description:
1. Package Validity at Statement Level (FL502 & FL504)

Introduces statement-level package validation.
Valid statements in a package remain executable even when some are invalidated.Enhances performance with incremental binding, reducing the need for full package rebinding.
New catalog table SYSPACKSTMTDEP records package dependencies at the statement level.

2. SQL Data Insights (FL500)

Leverages AI and deep learning with vector-embedding models to enhance query insights.
Functions like AI_ANALOGY, AI_COMMONALITY, and AI_SIMILARITY help detect data patterns, offering cognitive intelligence directly within SQL queries.


3. Current Lock Timeout Register

New CURRENT LOCK TIMEOUT register allows setting lock timeouts at the application or SQL statement level.
Offers better control over lock waits, overriding system-wide defaults for more efficient handling of transaction concurrency.

4. Online Conversion of Tables from PBG to PBR (FL500)

Simplifies online conversion of Partitioned-by-Growth (PBG) tables to Partitioned-by-Range (PBR) tables.
Reduces performance impact with minimal downtime, using ALTER and REORG utilities for smoother conversion.

5. Deadlock Resolution Priority Variable (FL501)

Introduces DEADLOCK_RESOLUTION_PRIORITY to define thread priority for deadlock resolution.
Higher priority threads are less likely to be terminated, enhancing application stability during deadlock situations.

Speakers:
Primary Speaker:
Preetham Kannan

Secondary Speaker:
Vishwa Pratap Thakur
Monday October 27, 2025 2:00pm - 3:00pm WIB
Rheinlandsaal C
  Track A

2:00pm WIB

D3 | Review key enhancements for Db2U in modernizing Db2 containerization footprint.
Monday October 27, 2025 2:00pm - 3:00pm WIB
Come and hear the latest and greatest the Db2 Universal Container (Db2U) has to offer, ready to be deployed to OpenShift, Kubernetes or Cloud Pak for Data that includes AWS/IBM Cloud (SaaS or Self managed), AKS, EKS, ARO, ROSA, SMP/MPP deployments for transactional or analytical workloads.
Monday October 27, 2025 2:00pm - 3:00pm WIB
Aristoteles 2
  Track D

3:20pm WIB

B4 | Taming Page Splits: Reduced Stress for DBAs in Db2 13
Monday October 27, 2025 3:20pm - 4:20pm WIB
Index page splitting in Db2 for z/OS has long been a source of performance stress for DBAs, particularly in high-volume insert environments. Prior to Db2 13, identifying and resolving these issues was a frustrating process. This session delves into the enhancements introduced in Db2 13 that simplify the management of index page splits. We will explore new capabilities and enhanced real-time statistics provide DBAs with actionable intelligence, enabling them to quickly pinpoint and address problematic page splitting activity. Discover how Db2 13 reduces the stress associated with index performance tuning, offering practical strategies to minimize page splitting and optimize Db2 performance.
This abstract was submitted in GSE Virtual 2025 as well.
Speaker
Monday October 27, 2025 3:20pm - 4:20pm WIB
Socrates
  Track B

3:20pm WIB

D4 | Becoming an Expert DBA: Best use of Db2 Features, Improvements & Tips
Monday October 27, 2025 3:20pm - 4:20pm WIB
This session is to share the technical journey for the advance feathers, especially when the database became very complex structure, very active and large OLTP/Warehouse.

- Advanced techniques: Db2 uses advanced techniques such as parallel processing, compression, partitioning, and indexing
- Mixed workload performance optimization
- Data security: Db2 offers modern data security and multi-factor authentication (MFA).
- Query and transaction handling: Db2 can handle complex queries and transactions.
- Encryption
- Federations
- HADR / Resiliency
- Table partitioning
- workload management
Speaker
Monday October 27, 2025 3:20pm - 4:20pm WIB
Aristoteles 2
  Track D

4:30pm WIB

A5 | Db2 Analytics Accelerator: product updates, new version V8, and experiences from the customers and health checks
Monday October 27, 2025 4:30pm - 5:30pm WIB
This is deep dive technical session about Db2 Analytics Accelerator on IBM Z with latest product updates, including software and new z17 hardware from development and product management perspective.

New release of IDAA is V8. When this session is presented in IDUG EMEA 2025, V8 ESP Program will be completed, product will be GA and speaker will talk about new features and early customer experiences of V8 release.

This session will also contain IBM Z platform specific details (z16 and z17) in the context of Accelerator such as machine configuration, CBU and Flex Capacity usage, different architecture alternatives for different business needs including GDPS usage with 2-, 3-, 4- site GDPS alternatives.

There will be solid, real experiences and lessons learned during PoCs, production implementations, architecture discussions and health checks
Speaker
Monday October 27, 2025 4:30pm - 5:30pm WIB
Rheinlandsaal C
  Track A

4:30pm WIB

B5 | Build a lightweight monitor to identify SQL workload tuning potential
Monday October 27, 2025 4:30pm - 5:30pm WIB
In this session, you will learn how to capture SQL statistics from Db2’s dynamic statement cache and how to combine them with the information from your EXPLAIN tables. The code that we use will be available for download after the session. Discover how to identify the queries that will benefit most from tuning, allowing you to focus your valuable time on those that matter. We start with simple metrics like RID list errors and work our way up to other performance metrics like top consumers, I/O statistics, lock contention, and more. You will learn how to track the performance and resource consumption of a given SQL statement over time, which makes it possible to spot trends. Finally, we will show how to detect access path changes in dynamic SQL workload. This is a common problem in environments with heavy dynamic workload. Something as simple as a single RUNSTATS execution on one of the involved tables can cause unexpected changes to the access path that Db2 chooses. Using historic explain information, these changes become visible, and you can take immediate action.
Speaker
Monday October 27, 2025 4:30pm - 5:30pm WIB
Socrates
  Track B
 
From $0.00

AI Era: Shaping Tomorrow’s Intelligence
From $0.00
Share Modal

Share this link via

Or copy link

Filter sessions
Apply filters to sessions.
Filtered by Date -