How the Rational ClearQuest Diagnostics utility works

The ClearQuest Diagnostics utility works by validating a schema repository or user database against a set of predefined rules. This topic describes the types of rules used by the tool.

The Rational ClearQuest Diagnostics utility uses a rules-based system to examine your schema repository and/or user database for conditions that might cause performance problems. The utility validates a database by processing a set of rules that are defined in an XML file. Rules ensure that the various tables that make up the schema repository database and user database are defined correctly. Each rule belongs to one of the following rule types shown in Table 1.

Table 1. Rule types
Rule type Description
Database Defines the type and versions of databases supported, and database-specific parameters.
Constraints Defines table-level constraints, such as the number of rows or columns allowed in a table; referential integrity rules; and rules where a column must have unique values across the table.
Table existence Defines the tables allowed in a schema repository. Some tables are mandatory and others are optional.
Columns and attributes Defines the attributes for table columns.
Field values Defines rules where a column must have specific values or a range of values.
Field value and referential integrity Defines rules where referential integrity depends on the value of a specific column.
Informational Defines rules that collect information to be displayed when you run the utility.

When you run the utility you specify whether to process all rules, one or more rule groups, or one or more specific rules. A rule group is a collection of rules designed to check a specific aspect of database integrity, such as user or MultiSite information. Rules in a rule group span rule types.

Related information
Supported platforms and databases
Using the Rational ClearQuest Diagnostics utility
Reviewing the results

Feedback