Browse Prior Art Database

Automated Repair of Corrupted Data Page of a Table in a Database

IP.com Disclosure Number: IPCOM000122813D
Original Publication Date: 1998-Jan-01
Included in the Prior Art Database: 2005-Apr-04
Document File: 2 page(s) / 35K

Publishing Venue

IBM

Related People

Cuan, J: AUTHOR [+2]

Abstract

Disclosed is a method for repairing corruption in data pages of a table in a database using automated repair capabilities of a repair program.

This text was extracted from an ASCII text file.
This is the abbreviated version, containing approximately 91% of the total text.

Automated Repair of Corrupted Data Page of a Table in a Database

      Disclosed is a method for repairing corruption in data pages of
a table in a database using automated repair capabilities of a repair
program.

      The repair program has the function to perform automated
extraction of valid records out of specific data pages of a table to
an output file in a format readable by the database program.  The
repair program also has the function to perform automated
initialization of specific data pages of a table to an empty state.

      To repair a table with corrupted data pages, these repair
functions are used in the manner described by the following repair
process:
  o  Use the repair function to extract the valid records from
      the corrupted data pages.
  o  Use the repair function to initialize the corrupted data
      pages as empty data pages.
  o  After initialization of the corrupted data pages, access
      the table and save the rest of the data from the table.
  o  Drop the table.
  o  Recreate the table, and insert back the data extracted and
      saved.

      The function to extract valid records will not include overflow
records found in the page being operated on but will include the
overflow records of pointer records in the page being operated on.
The function  to initialize the data page as empty will save overflow
records that are  valid and insert them back into the newly
initialized page using t...