International Business Machines Corporation

Julie Chen

James Zu-Chia Teng

Jay A Yothers

John Marland Garth

Bryan Frederick Smith

Akira Shibamiya

John Joseph Campbell

Li-Mey P Lee

Frances Hwa Villafuerte

William James Franklin

John Richard Lyle

Michael John Bracey

A method and article of manufacture, implementing the method, allocates space for a dataset. The dataset has an initial area and zero or more additional allocated areas to provide space for storing the dataset. The size of a new additional area is determined. The new additional area is associated with a new area number, and the size of the new additional area is based on the new area number. Additional space for the dataset is allocated based on the size of the new additional area.

Computer-implemented method for allocating new additional area for the dataset in storage based on the size of the new additional area wherein if the new area number does not exceed clipping threshold, the size of a new additional area being greater than the size of each previously allocated additional area of the dataset

A base table and related auxiliary table spaces are reorganized concurrently via a database utility. The database utility determines which auxiliary tables are related to the base table and automatically includes their respective auxiliary table in the same invocation of the utility. The reorganization is performed via allocated shadow data sets. The original data sets are switched with the newly built shadow data sets including the LOB shadows.

System and method for concurrently reorganizing logically related LOB table spaces

Growing community of inventors

San Jose, CA, United States of America

Julie Chen