IBM Support

About the DOORS Database Integrity Checker

Question & Answer


Question

What does the Database Integrity Checker do in IBM Rational DOORS?

Cause

There are problems accessing DOORS data but the integrity check did not flag any problems.

Answer

The database integrity checker will verify the following:

  • Each reference from a parent item to a child item has a corresponding reference back from the child to the parent.

  • No child item is referenced as a child of two different parent items.

  • Every item in the database is referenced as the child of another item.


If an item is not referenced by a parent, it (and any children it has) is not displayed in the Rational DOORS Database Explorer. This type of incorrect referenced data is recovered to a Lost and Found folder.

Every project in the database has an entry in the Project View list, which is the list Rational DOORS uses to generate the Project View in the database explorer. Once the database integrity check is complete, you can use the wizard to repair inconsistency in the database and move or restore
any recovered data.

You can also run a restricted integrity check on the contents of a selected folder or project.
An integrity check on a project or folder cannot check for data that is not referenced by any other item.

It can check for:

  • Missing data

  • Items that are not referenced by more than one parent

  • Projects that are not included in the project list

Related Information

[{"Product":{"code":"SSKR2T","label":"IBM Engineering Requirements Management DOORS"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"General Information","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.3;9.0;9.1;9.1.0.2;9.2;9.2.0.1;9.2.0.2;9.2.0.3;9.2.0.4;9.2.0.5;9.3;9.3.0.1;9.3.0.2;9.3.0.3;9.3.0.4;9.3.0.5;9.3.0.6;9.3.0.7;9.4;9.4.0.1;9.5;9.5.0.1;9.5.1;9.5.1.1;9.5.1.2","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
01 May 2020

UID

swg21403353