Repository tools command to partition the database tables

Edit online

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 partition command partitions by range based on item types. You can also use the unpartition 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. The partitioning feature is supported on the following databases:
  • Db2 Enterprise edition
  • Db2 11.5 Advanced edition
  • Oracle Enterprise edition
  • SQL Server Enterprise edition
The default Apache Derby database or the Standard, Workgroup, Personal, and Express editions of the above databases, 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 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
partition Partition the database table. Back up the database before you run this command. Either partition or unpartition is required N/A
unpartition Unpartition the database table. Back up the database before you run this command. Either partition or unpartition 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, replace partition with unpartition.

For Windows operating system 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 partition

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

cd /opt/IBM/QM_Server/server/
./repotools-qm.sh -partitioning teamserver.properties=conf/qm/teamserver.properties partition