Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

RTC diagnostic shows CRJAZ2055W missing indices warning

Questions
Tags
Users
Badges
Andrew Clement
(727●24●73) 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.

0 votes

2 answers
2,307 views
0 votes

Accepted answer

Permanent link
Howard Hsiao
JAZZ DEVELOPER (5.5k●1●7) May 09 '18, 11:09 a.m.

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

3 votes

One other answer

Permanent link
SEC Servizi
(971●2●38●60) 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.

1 vote

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: May 09 '18, 11:02 a.m.

Question was seen: 2,307 times

Last updated: Apr 19 '19, 5:20 a.m.

Confirmation Cancel Confirm