Repository tools command to rebuild database indexes
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
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
Open a command line and enter
this command:
cd opt/IBM/JazzTeamServer/server/ ./repotools-jts.sh -rebuildIndices teamserver.properties=conf/jts/teamserver.properties