After a reorg of a LOB table space the space of the VSAM LDS data set remains the same and the data set is not re-allocated using Rapid Reorg

Products

• Rapid Reorg for DB2 for z/OS

Issue/Introduction

During a Rapid Reorg for Db2 for z/OS (PRR) execution against a LOB table space, the underlying VSAM LDS dataset is not re-allocated.
How is the free space reclaimed?

Resolution

After a reorg of a LOB table space its size does not change. This gives the impression in Rapid Reorg that the space is not freed in LOB table spaces
as they are not deleted and re-allocated. The internal pointers are just updated but the space remains the same as before the reorg.
Rapid Reorg of a LOB table space will only compress the existing LOB data, in other words an unload and reload of data does not occur.
Data rows are rolled up eliminating any unused space similar to a compress of a PDS.