Patent ID: 6163783
Filing Date: 2000-12-19
Classification: G06F,Y10S

Abstract:
A single-phase method of checking DB2 referential integrity, comprising the steps of:(a) extracting, in parallel, (1) all of zero or more instances of one or more specified foreign keys, referred to as FK occurrences, and (2) zero or more insetances of one or more specified primary keys, referred to as PK occurrences;(b) constructing a SORT record for each said FK occurrence, referred to as an FK SORT record, and a SORT record for each said PK occurrence, referred to as a PK SORT record;(c) collating the FK SORT records with the PK SORT records into a single sequence of SORT records to group together the PK SORT records for each primary key, with the respective FK SORT records for each of any foreign key associated with each said primary key; and(d) performing a specified diagnosis routine utilizing said single sequence of SORT records as an input.