Skip to Content

Reclaiming Space from Multidimensional Clustering (MDC) Tables – Enhancements for DB2 9.7

To allow the reclamation of free space in MDC tables without sacrificing concurrency demands, DB2 9.7 introduced the “RECLAIM EXTENTS ONLY” option in the REORG TABLE command. This new feature can be run manually through the REORG TABLE CLP command or it can be configured to be run automatically through the existing automatic maintenance infrastructure. In this paper, we are going to talk about how this feature works and how to configure it to be run automatically.

View this Document

Former Member

No comments