Repository tools command to partition the database tables

Use the partitioning command to partition the database tables.


In version 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 for z/OS: <SchemaPrefix>_REPOSITORY.VERSION. The <SchemaPrefix> can be obtained from the Quality Management application file. Open the conf/qm/ file and under the DB2z configuration section, look for<SchemaPrefix>.
  • Db2 for i: RPSTR_VRSN
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.


Attribute Description Required Default Path to the file. No conf/qm/
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.

For Windows operating system Open a command prompt and enter this command:

cd C:\Program Files\IBM\QM_Server\server\
repotools-qm.bat -partitioning\qm\ enable

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

cd /opt/IBM/QM_Server/server/
./ -partitioning enable

video icon Video channel
Software Education channel

learn icon Courses

IoT Academy
Skills Gateway

ask icon Community forums library

support icon Support

IBM Support Community
Deployment wiki