Repository tools command to partition the database tables
Use the partitioning command to partition the database tables.
Purpose
In version 6.0.6.1 and later, you can use the partitioning command to partition a non-partitioned REPOSITORY.VERSION table in a configuration-enabled system. The enable command partitions by range based on item types. You can also use the disable command to remove partitioning from a REPOSITORY.VERSION table. Database table partitioning helps manage the performance, availability, and scalability of large amounts of data (millions of artifacts) in a repository. To use the partitioning features, you must install an Enterprise edition of a Db2, Oracle, or SQL Server database. Standard, Workgroup, Personal, or Express editions of these databases, or the default Apache Derby database, do not support partitioning. The command fails if the underlying database does not support partitioning.
- Db2: REPOSITORY.VERSION
- Db2 for z/OS: <SchemaPrefix>_REPOSITORY.VERSION. The <SchemaPrefix> can be obtained from the Quality Management application teamserver.properties file. Open the conf/qm/teamserver.properties file and under the DB2z configuration section, look for com.ibm.team.repository.db.schemaPrefix=<SchemaPrefix>.
- Db2 for i: RPSTR_VRSN
- SQL Server: REPOSITORY.VERSION
- Oracle: REPOSITORY_VERSION
During an upgrade, tables can be duplicated as part of the migration process and dropped after the process is complete. Ensure that you have enough disk space for the data migration and for partitions to increase after the initial copy and cleanup. Your free disk space should be the approximate size of the database you are migrating.
Parameters
Attribute | Description | Required | Default |
---|---|---|---|
teamserver.properties | Path to the teamserver.properties file. | No | conf/qm/teamserver.properties |
enable | Enable table partitioning. Back up the database before you run this command. | Either enable or disable is required | N/A |
disable | Disable table partitioning. Back up the database before you run this command. | Either enable or disable is required | N/A |
noPrompt | Do not prompt before partitioning. | No | N/A |
logFile | Path to the log file. | No | repotools-qm_partitioning.log |
The following examples are to enable partitioning a Quality Management application database tables. To disable partitioning, switch enable with disable.
Open a command prompt and enter this command:
cd C:\Program Files\IBM\QM_Server\server\ repotools-qm.bat -partitioning teamserver.properties=conf\qm\teamserver.properties enable
Open a command line and enter this command:
cd /opt/IBM/QM_Server/server/ ./repotools-qm.sh -partitioning teamserver.properties=conf/qm/teamserver.properties enable