It's all about the answers!

Ask a question

RTC diagnostic shows CRJAZ2055W missing indices warning


Andrew Clement (7272473) | asked May 09 '18, 11:02 a.m.

I am using CLM 6.0.4 iFix007.
RTC diagnostic shows the following warning:

CRJAZ2055W Some indices were missing from the database, and missing indices can negatively impact application performance. To add the missing indices, you should stop your server and execute the -rebuildIndices command in repotools. 

After I ran repotools-ccm -rebuildIndices, the RTC diagnostic still shows the same CRJAZ2055W warning.

Accepted answer


permanent link
Howard Hsiao (5.5k17) | answered May 09 '18, 11:09 a.m.
JAZZ DEVELOPER

The warning given out by RTC diagnostic seems to be a false warning.
This issue will be fixed in CLM 6.0.4 iFix009 (will be released between May 7~May 11, 2018).

Andrew Clement selected this answer as the correct answer

One other answer



permanent link
SEC Servizi (97123860) | answered Apr 19 '19, 5:20 a.m.
  1. Export the Diagnostics results using the Export Results button from https://localhost/jazz/admin#action=com.ibm.team.repository.admin.serverDiagnostics.
  2. Open the com.ibm.team.repository.service.diagnostics.basic.internal.DBIndexDiagnostic.txt file from the diagnostics.zip file.
  3. This file contains the SQL commands that can be used to add the missing indices.
Cheers.

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.