×

Method of checking index integrity in a DB2 database

  • US 5,579,515 A
  • Filed: 12/16/1993
  • Issued: 11/26/1996
  • Est. Priority Date: 12/16/1993
  • Status: Expired due to Term
First Claim
Patent Images

1. A method of testing DB2 index integrity, comprising the steps of:

  • (a) reading, in parallel, (1) a plurality of DB2 data records from a DB2 table space, and (2) a plurality of DB2 index entries from each of at least one DB2 indexes associated with said DB2 table space, normally each said index entry being nominally associated with exactly one said DB2 data record;

    (b) constructing a SORT record for each said data record and each said index entry;

    (c) collating the SORT records for the data records and said SORT records for the index entries into a single sequence of SORT records to group together (1) the SORT records for each data record, with (2) the one or more SORT records for said one or more index entries associated with said respective date record; and

    (d) performing a specified diagnosis routine utilizing said single sequence of SORT records as an input.

View all claims
  • 11 Assignments
Timeline View
Assignment View
    ×
    ×