Patent ID: 7181481

Claim:
A method for reorganizing a Large Object (LOB) table space in a database comprising the steps of: (a) identifying a LOB base table space to be reorganized and its associated indexes; (b) identifying auxiliary LOB table spaces and their associated indexes that are related to said identified LOB base table space being reorganized; (c) concurrently allocating a shadow data set for each LOB table space and associated indexes identified in steps (a) and (b); (d) loading rows from said identified LOB base table space into a corresponding shadow data set, and for each row loaded, reading LOB data from each of said identified auxiliary LOB table spaces relating to said loaded row and writing said read LOB data to a corresponding shadow data set; and (e) switching an original data set of each of said LOB table spaces and associated indexes identified in steps (a) and (b) with corresponding shadow data set from step (d).