Welcome to the Jazz Community Forum
How to properly rebuild and reindex all RTC indices in RTC 6.0.2
We have recently migrated RTC 6.0.2 (with JTS and CCM only) from a SLES to a Red Hat Linux single server with Oracle. I need to properly re build and re index all RTC indices after restoring the Oracle database on the Red hat server from an export of Oracle on the SLES server.
My primary question is:
How do I properly re build and re index all RTC indices?
Details:
My understanding is that, after shutting down RTC, indices can be re-built and re-indexed using a variety of repotools commands such as:
cd <Jazz Server Directory>
./repotools-jts.sh –reindex teamserver.properties=conf/jts/teamserver.properties scope=all
./repotools-ccm.sh –reindex teamserver.properties=conf/ccm/teamserver.properties scope=all
./repotools-jts.sh –reindex all
./repotools-ccm.sh –reindex all
./repotools-jts.sh –rebuildTextIndices
./repotools-ccm.sh -rebuildTextIndices
./repotools-jts.sh –rebuildIndices
./repotools-ccm.sh -rebuildIndices
Detailed questions:
1. Are the commands above correct?
2. Are all the commands above necessary, or are some redundant?
3. In which order should the correct commands be run?
Thank you for any guidance you can provide.
One answer
Christopher,
these are the articles I know explaining the indexes:
https://jazz.net/library/article/1271
https://jazz.net/library/article/1272
There are different types of indexes. Some impact the DB - which you typically won't have to redo.
There are some text indexes, which you sometimes redo. Please note, the repotools commands might have the same commands for all the applications, but not all these applications really have the data. As an example the work item search text index is only available at RTC (as far as I know), even if you could run the command on any application.