Identifying and repairing problems with the integrity of the database

Use the Database Integrity Checker to identify and repair data integrity problems.

About this task

You can check:

When the database integrity check is complete, use the wizard to repair any inconsistencies in the database and move or restore any recovered data.

You can 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:

Procedure

  1. Log in to Rational DOORS as the Administrator user. The Administrator user is the only user who can run the database integrity checker.
  2. To check all the data in the database, select the database database icon. To check the data in a particular project or folder, select the project or folder and click File > Check Integrity.

    The Database Integrity Check wizard is displayed.

    Note: You cannot check the integrity of data if the database server is version 7.0 SP1 or earlier. An error is displayed if the database server is not compatible.
  3. Follow the steps in the wizard to check and optionally repair problems with the integrity of the data. For more information about any of the pages in the wizard, click Help.

What to do next

If you chose to create a log file, you can view the results of the integrity check.
The log file is created in the directory you specified when you ran the integrity checker. It contains three sections:
  • The first section contains a list of all the items that were checked, along with the date and time of the check. Items that have integrity problems are marked with ***, and a brief description of the problem is given.
  • The second section contains a summary of each problem that was detected. The summary provides details of the parent and child references that existed for each item when it was checked.
  • The final section contains details of the repairs you made to the database. Any repair that failed is marked with ***.

Feedback