Repository tools command to rebuild database indexes

Edit online

Use the rebuildIndices command to rebuild the database indexes.

Purpose

The rebuildIndices command is used to rebuild database indexes in the event of them becoming fragmented. Use the rebuildIndices command if you have the following symptoms:
  • When you see an error in the Database Indicies section of the diagnostics.
Important: You must shut down the server before you run the command.

Parameters

Attribute Description Required Default
dropUnknown Unary argument that drops the indexes that are not known to system. This option cannot be specified if indexName is specified. No Not applicable
indexName Specifies the logical name of the index on the given table for which the rebuildIndices command is to be run. If this option is added in the command, then specifying packageNsUri and tableName arguments are mandatory. No none
logFile Path to the log file. No repotools-application_rebuildIndices.log

where application is jts, ccm, rm, qm, gc, dcc, or relm.
packageNsUri Specifies the namespace URI of the package associated with the schema for which the rebuildIndices command is to be run. No none
preserveKnown Unary argument that creates the missing indexes without dropping the existing indexes that are known to system. That is, the command will not drop and re-create indexes that are known to system; it will instead just create those that are missing. This option cannot be specified if indexName is specified. No Not applicable
tableName Specifies the logical name of the table in the given schema for which the rebuildIndices command is to be run. If this option is added in the command, then specifying packageNsUri argument is mandatory. No none
teamserver.properties The file system path to the teamserver.properties file. No conf/application/teamserver.properties

where application is jts, ccm, rm, qm, gc, dcc, or relm.

Example

The following example is for Jazz® Team Server. To use this command for other applications, run these options from the server directory:
  • IBM® Engineering Workflow Management (Change and Configuration Management application): repotools-ccm
  • IBM Engineering Requirements Management DOORS® Next (Requirements Management application): repotools-rm
  • IBM Engineering Test Management (Quality Management application): repotools-qm
  • Global Configuration Management: repotools-gc
  • Data Collection Component: repotools-dcc
  • IBM Engineering Lifecycle Optimization - Engineering Insights: repotools-relm

For Windows operating system Open a command prompt and enter this command:

cd C:\Program Files\IBM\JazzTeamServer\server\
repotools-jts.bat -rebuildIndices teamserver.properties=conf\jts\teamserver.properties

For Unix operating systems Open a command line and enter this command:

cd opt/IBM/JazzTeamServer/server/
./repotools-jts.sh -rebuildIndices teamserver.properties=conf/jts/teamserver.properties