Index integrity checking

This feature was replaced in 22.04 (Felicity) and onward by a more extensive database health checking and self-healing capability.

This feature checks the current index state of the database and compares it to the reference definition packaged in the distribution.

The health of the codebeamer system depends from the presence of correct index definitions on application database tables. Absence of these can result in severe performance limitations or in some cases even failure of queries.

Database integrity checker validates the following:

• presence of all named indices, with the exact column definition (multiplicity and order)
• presence of indices covering primary key columns
• presence of indices covering foreign key columns

Triggering validation

codebeamer automatically validates index definitions each day 5 minutes after midnight.

In case a manual check is necessary, it's possible to manually trigger a new check on the System Admin > Database Performance monitoring job page using the "Recheck indices" link found on the action bar.

If the current index configuration is incorrect, this page also shows an error message:

Resolving index issues

Please contact our support to help resolving any issues encountered with index validation.

To speed up the process of investigation, please manually execute an index validation (see previous section on how to do this), then export a daily database server log from System Admin > Server Status Dashboard > Download logs > Export daily logs and attach it to your support request.