International Business Machines Corporation

William James Franklin

Jay A Yothers

Jeffrey Allen Berger

Laura Michiko Kunioka-Weis

Haakon Roberts

Thomas Majithia

John Richard Lyle

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

A database recovery and index rebuilding method involves reading data pages for a database to be recovered as recovery bases; retrieving all log records from stored post-backup updates and sorting the retrieved log records; as the data pages to be recovered are read, applying the sorted log records to their respective data pages; as the applying completes for individual data pages, extracting and sorting index keys from the individual data pages for which the applying is complete, until all index keys have been extracted from all individual data pages and sorted; on an individual recovered page basis, writing the recovered individual data pages into the database; and when all index keys have been extracted and sorted from all of the recovered individual data pages, rebuilding indexes of the database using the sorted index keys and writing the rebuilt indexes to the non-transitory storage.

Relational database recovery

A database recovery and index rebuilding system involves at least one processor coupled to memory, storage, a database, and sets of image copies and post-backup updates. When database reconstruction is required, the processor will i) access the image copies; ii) access post-backup updates to be re-applied; iii) without regard to 'ii)', read data pages to be recovered into objects; iv) concurrently with 'iii)', retrieve and sort log records from the post-backup updates; v) as the data pages to be recovered are read in &#x201c;iii)&#x201d;, apply the sorted log records; vi) as &#x201c;e)&#x201d; completes and concurrently with &#x201c;v)&#x201d;, extract and sort index keys; vii) concurrently with &#x201c;vi)&#x201d; and on an individual recovered page basis, write the recovered data pages into the database; viii) when all index keys have been extracted and sorted, initiate database index rebuilds; and ix) when rebuilt, store the rebuilt indexes without regard to whether &#x201c;vii)&#x201d; has completed.

A database recovery method involves: a) accessing image copies; b) accessing updates to be re-applied to reconstruct the database; c) reading into objects, from the image copies, data pages to be recovered; d) concurrently with 'c)' retrieving and sorting log records from the updates; e) as the data pages are read into the objects in 'c)', applying the sorted log records, in timestamp order; f) as &#x201c;e)&#x201d; completes for individual pages, and concurrently with &#x201c;e)&#x201d; with respect to pages for which applying is not complete, extracting and sorting index keys, from pages for which the applying is complete, until all index keys have been extracted and sorted; g) concurrently with &#x201c;f)&#x201d;, writing recovered pages into the database; h) initiating a rebuild of database indexes using the extracted and sorted index keys; and i) when the database indexes have been rebuilt, writing them to storage without regard to whether &#x201c;g)&#x201d; completed.

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.

Growing community of inventors

San Ramon, CA, United States of America

William James Franklin