Browse Prior Art Database

Minimizing Logging to Facilitate Recovery of Tablespace

IP.com Disclosure Number: IPCOM000038450D
Original Publication Date: 1987-Jan-01
Included in the Prior Art Database: 2005-Jan-31

Publishing Venue

IBM

Related People

Authors:
Cowdery, LR Mellow, C Reinsch, RA [+details]

Abstract

This invention relates to a method for minimizing logging required to facilitate the recovery of tablespace reorganization. In relational data base management systems such as DB2, recoverability of a tablespace is achieved by making a copy of the tablespace as it exists at a checkpoint, and then logging changes to the tablespace after the checkpoint. When the copy of the tablespace is made, a description of the copied data set and the current location of the log are added to a designated storage, such as the DB2 SYSCOPY table.