International Business Machines Corporation

John Richard Lyle

Jay A Yothers

William James Franklin

James Zu-Chia Teng

Karelle Lynne Cornwell

Frank Darl Bower

Saiyin Leung

John Marland Garth

Li-Mey P Lee

Frances Hwa Villafuerte

Julie Chen

Roy James Cornford

Roy J Comford

Provided is a method for online reorganization and increasing the page size of a DB2 object. A base table and related auxiliary table spaces are reorganized concurrently via a database utility, DB2 REORG 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; page size of the allocated shadow data sets is dynamically updated during reorganization. The original data sets are switched with the newly built shadow data sets, and DB2 catalog values and control blocks are updated with new page size values.

Method of changing the page size of a DB2 table space while keeping the object available

Provided is a method for online reorganization and increasing the page size of a DBobject. A base table and related auxiliary table spaces are reorganized concurrently via a database utility, DBREORG 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; page size of the allocated shadow data sets is dynamically updated during reorganization. The original data sets are switched with the newly built shadow data sets, and DBcatalog values and control blocks are updated with new page size values.

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

Morgan Hill, CA, United States of America

John Richard Lyle