Enable database partitioning

In version 6.0.6.1 and later, you can use the partitioning repotools command to partition a non-partitioned REPOSITORY.VERSION table in a configuration-enabled system.

To determine whether you need to enable database table partitioning, see Leveraging Database Partitioning in Engineering Test Management for Data Growth on the Deployment wiki.

The command partitions by range based on item types. 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 (or Advanced edition if using Db2 11.5, Db2 12.1.1, or Db2 12.1.2) database. Standard, Workgroup, Personal, or Express editions of the database, or the default Apache Derby® database, do not support partitioning. The command fails if the underlying database does not support partitioning.

Important: Back up the database before you use this command. 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 data migration, the original table is duplicated until the end of the migration process, when the old table is dropped. Ensure that you have adequate disk space for data migration and for growing partitions after the initial copy and cleanup.

To enable the Engineering Test Management application database table partitioning, open a command window and enter the following commands:

cd /server
./repotools-qm.sh -partitioning teamserver.properties=conf/qm/teamserver.properties enable

For details about the partitioning repotools command, see Repository tools command to partition the database tables.