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.

The REPOSITORY.VERSION table has a different name in different databases:
  • 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
Important: Back up the database before you enable or disable partitioning. After the successful completion of this command, database administrators should collect statistics for the REPOSITORY.VERSION table and its indexes to help improve the performance of the database.

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