Validating a user database and schema repository

Validate the cq_schema.mdb schema repository and the cq_users.mdb user database against all rules in the rules.xml rules file.

This topic shows how to validate the cq_schema.mdb schema repository and the cq_users.mdb user database against all rules in the rules.xml rules file. Unless you specify otherwise, the ClearQuest Diagnostics utility processes all rules in the rules file. You must edit the cqdiagnostics.pl script to specify which subcommand to run and which parameters to use; then run the script. In addition to checking the integrity of the schema repository and user database, the utility determines whether the user database is synchronized with the schema repository.

The –logfile and –resultsfile options identify the names of the log file and results file, respectively. The results file contains the information that the utility prints to the console as it processes the command. If you do not specify the –resultsfile option, the utility creates one with the name result_number_number.txt in the directory where you invoke the command. The log file contains more detailed information, which is useful for diagnosing and repairing problems.

Use the –dbinfoschemarepo option to identify the schema repository's name, location, and vendor database. Use the –dbinfouser option to identify the user database's name, location, and vendor database.

validatedb -rulefile configuration\rules.xml -logfile testlog.txt -resultsfile testresults.txt -dbinfoschemarepo MS_ACCESS C:\cq_schema.mdb -dbinfouser SAMPL MS_ACCESS C:\cq_users.mdb

The following example uses the –rulenames option to direct the utility to validate the schema repository and user database against only the rule named master_usage_table_name_id_rule.

validatedb -rulefile configuration\rules.xml -logfile testlog.txt -resultsfile testresults.txt -rulenames master_usage_table_name_id_rule -dbinfoschemarepo MS_ACCESS C:\cq_schema.mdb -dbinfouser SAMPL MS_ACCESS C:\cq_users.mdb


Feedback