How can I verify the IBM Rational Team Concert (RTC) repository database?
When a jazz-based server is reporting strange database errors, such as repeating StaleDataExceptions, the first step to debugging is to check your server for database consistency problems.
The Online Verify Tool can be used to determine if the tables in a database are in a consistent state. There are multiple tables used to store any object in CLM. The onlineVerify tool looks at the database entries for each object to make sure they are all in agreement. It does this at a very low level. It does no checking for the validity of the objects themselves; it checks only that the tables are in sync.
Out of box, the command "repotools -verify" can be used to verify your database. This operates at a higher level than the Online Verification tool. It allows logical verification of objects, as well as some mid-level concepts such as context checking.
Depending on your problem or issue, it may be advantageous to use both tools. If you need help deciding which to use, or need help identifying a problem, Contact IBM Support.
|Jazz and Rational Team Concert have an active community that can provide you with additional resources. Browse and contribute to the User forums, contribute to the Team Blog and review the Team wiki.
Refer to technote 1319600 for details and links.