Join us for an insightful discussion on 24 February, 2026 at 11:00 AM ET.
In the era of AI and massive feature stores, efficient data lifecycle management is a foundational requirement for analytical performance and operational stability. This session demystifies Range‑Partitioned Tables (RPTs) in Db2, demonstrating how to design, operate, and maintain large‑scale datasets organized by ranges.
The session begins with the core principles and design patterns of range partitioning, including roll‑in and roll‑out strategies for high‑velocity data ingestion and archival.
Attendees will learn how to use ATTACH, DETACH, and SET INTEGRITY, along with Asynchronous Index Cleanup (AIC), to make new data available quickly or retire historical data with minimal logging and near‑zero downtime.
We will explore how Data Partition Elimination significantly reduces I/O by accessing only relevant data ranges - an essential optimization for model training, feature extraction, and time‑series analytics - while also addressing locking, concurrency, and backup/recovery considerations specific to partitioned environments.
The session further examines indexes on range‑partitioned tables, including when to use partitioned versus non‑partitioned indexes and how index design impacts both query performance and maintenance costs.
Finally, attendees will gain practical guidance on ongoing maintenance and optimization, covering REORG and REORG INDEXES for RPTs, effective use of REORGCHK, and a review of recent Db2 enhancements relevant to partitioned table management.
By the end of this webinar, participants will have a clear, end‑to‑end blueprint for building and operating a Db2 range‑partitioning strategy that scales reliably to meet the demands of modern AI and analytics workloads.
Click here to register and add the event to your calendar.
Where is the link to join? Check your email the day before the event!
How to get the most out of this webinar:
-
Explore the Db2 Community.
-
Ask questions for the presenters by replying to this discussion post before, during and after the webinar. Sakthi Vickram and Neelakandan S S G will be happy to answer your questions and share insights.
-
Check out upcoming Db2 events here.
We look forward to seeing you there!
------------------------------
Db2 Community Admin
------------------------------