Determine feature level

You should determine the feature level of your databases if you are upgrading your schema repository or user database to a new release of Rational® ClearQuest®.

The feature level of a schema repository is stored in the feature_level field of the master_global table. The feature level of a user database is stored in the feature_level field of the dbglobal table.

To verify the current feature level and metaschema version of your databases, use the pdsql tool provided in the Rational ClearQuest directory. This utility is a command-line SQL tool. It can open a SQL session with all supported databases. To display information about the database parameters required for each session, type pdsql at the command prompt.

To check for the current feature level and metaschema version, enter the following commands:
  1. C:\>pdsql [pdsql database operands];
  2. >select feature_level, metaschema_version from master_global;
  3. >quit;

The following table lists the supported feature levels and metaschema versions for every release of Rational ClearQuest.

Table 1. Supported feature levels and metaschema versions
Version Metaschema Version Feature Level
1.0 13 1
1.1 17 2
2.0/2000/2001 20 3
2001A/2002/2003/7.0.0.0 22 5
7.0.1.0 22 5 and 6
7.1 22 5, 6 and 7

The latest level available with Rational ClearQuest version 7.1, feature level 7, enables the following features:
  • Pessimistic record locking
  • Full-text search
Feature level 6 enables the following features:
  • Workspace folder permissions
  • Storing history time stamps in Coordinated Universal Time (UTC)
  • Increase in the number of record IDs for the user database
  • Synchronization of null values with Rational ClearQuest MultiSite
  • Ability to rename a site with the Rational ClearQuest MultiSite

Rational ClearQuest clients running version 7.0.1 or earlier cannot connect to user databases with feature level 7 enabled.

In a Rational ClearQuest MultiSite environment, databases on feature level 7 can read packets received from databases on feature levels 5 and 6, but databases on feature levels 5 and 6 cannot read packets received from databases on feature level 7. You have the following choices:
  • If all databases must accept packets from all other databases in the Rational ClearQuest MultiSite environment, then all databases must be upgraded to feature level 7 at the same time.
  • If some databases do not need to accept packets from the upgraded databases, then the former can remain on feature levels 5 or 6 and be upgraded later.

For more information about raising the feature level and upgrading, see the IBM Rational ClearQuest and ClearQuest MultiSite Installation and Upgrade Guide.


Feedback