E
dit
A
ttach
P
rintable
r6 - 2019-03-11 - 16:48:22 -
RichardWatts
You are here:
TWiki
>
Deployment Web
>
DeploymentInstallingUpgradingAndMigrating
>
RQMPartitioning
<div id="RQM Partitioning" style="padding: 10px 15px; border-width:1px; border-style:solid; border-color:#FFD28C; background-image: url(<nop>https://jazz.net/wiki/pub/Deployment/WebPreferences/TLASE.jpg); background-size: cover; font-size:120%"> ---+!! Leveraging Database Partitioning in RQM for Data Growth <img src="https://jazz.net/wiki/pub/Deployment/WebPreferences/todo.png" alt="todo.png" width="50" height="50" align="right"> %DKGRAY% Authors: Richard Watts, Prabhat Gupta, Gary Johnston, Vishwanath Ramaswamy <br> Build basis: Rational Quality Manager, 6.0.6.1 %ENDCOLOR%</div></sticky> <!-- Page contents top of page on right hand side in box --> <sticky><div style="float:right; border-width:1px; border-style:solid; border-color:#DFDFDF; background-color:#F6F6F6; margin:0 0 15px 15px; padding: 0 15px 0 15px;"> %TOC{title="Page contents"}% </div></sticky> <sticky><div style="margin:15px;"></sticky> Starting in 6.0.6.1, we introduced a new feature for customers using Rational Quality Manager with configuration management called database partitioning. This is not a product feature but the necessary configuration steps to enable table partitioning in your enterprise database. *Note:* Database partitioning is an *enterprise feature*, which means you need to determine if the version/license of your enterprise database supports this feature before you attempt to turn it on. All three enterprise databases we support, have a version that supports table partitioning. The best resource to determine the features your enterprise database supports is your database administrator. ---++ What is partitioning? Partitioning is the division of a logical table (or database) into distinct independent parts. It is normally done for manageability, data scale, availability or load balancing. In our case, we are partitioning tables for data scale. Meaning, we partition the table to keep the same levels of performance as data grows. In this case, we are partitioning the version table based on item type. Future releases will include recommendations for other high growth tables, but we decided to focus on one for our initial release of this feature. ---++ When should I consider partitioning There are two ways to determine how much data you have in your version table. We provide a managed bean, Project Metrics MBean that you can enable and monitor for data growth. In addition, we provide vendor specific queries that can be run to check the number of rows in the version table. These queries can be run from the repodebug User Interface in Rational Quality Manager. Either of these approaches will tell you the size of the version table, which is the key factor on when to consider enabling table partitioning. When considering whether to enable partitioning, you need to evaluate the size of the version table. As the size of the table grows beyond 2GB, it is recommended by database vendors that you consider data growth strategies for your table. In our case, *25 million rows* in the version table is approximately 4.5 gb and you should consider partitioning your version table. Database Administrators should be aware that enabling database partitioning does incur an approximate 20% increase in table index size. Below are techniques for determining the size of your version table. ---+++ Project Metrics MBean How to enable the mbean The specific attribute ---+++ Repodebug Queries *Microsoft SQL Server* <verbatim> SELECT COUNT(1) FROM REPOSITORY.VERSION; </verbatim> *Oracle DB* <verbatim> SELECT COUNT(1) FROM REPOSITORY.VERSION; </verbatim> *DB2 LUW* <verbatim> SELECT COUNT(1) FROM REPOSITORY.VERSION; </verbatim> *DB2z* <verbatim> SELECT COUNT(1) FROM RPSTR_VRSN; </verbatim> *DB2i* <verbatim> SELECT COUNT(1) FROM <SchemaPrefix>_REPOSITORY.VERSION; </verbatim> Where *SchemaPrefix* can be obtained from QMs teamserver property : com.ibm.team.repository.db.schemaPrefix <br> *Example:* teamserver.properties for QM have -> com.ibm.team.repository.db.schemaPrefix=QMX <br> So the SQL would look like -> SELECT COUNT(1) FROM *QMX_REPOSITORY.VERSION*; <br> ---++ How to enable partitioning Enabling table partitioning is done while the system is shut down using a repotools command. <verbatim> repotools-qm.sh -partitioning [teamserver.properties=tspFile] [logfile=logFile] enable [noPrompt] </verbatim> ---++ How to disable partitioning Disabling table partitioning is done the same way. The system is shut down and a repotools command is executed to disable the table partition. <verbatim> repotools-qm.sh -partitioning [teamserver.properties=tspFile] [logfile=logFile] disable [noPrompt] </verbatim> ---+++++!! Related topics [[DeploymentWebHome][Deployment web home]], [[https://jazz.net/wiki/bin/view/Deployment/ProjectMetricsCollectorTask ][Project Metrics MBean]] <br> [[https://www-03preprod.ibm.com/support/knowledgecenter/en/SSYMRC_6.0.6.1/com.ibm.jazz.install.doc/topics/r_repotools_partitioning.html][repotools-qm -partitioning command]] <br> ---+++++!! External links: * [[https://www.ibm.com][IBM]] ---+++++!! Additional contributors: Michael Afshar, Susan Yeshin, Chris Austin <sticky></div></sticky>
E
dit
|
A
ttach
|
P
rintable
|
V
iew topic
|
Backlinks:
We
b
,
A
l
l Webs
|
H
istory
: r6
<
r5
<
r4
<
r3
<
r2
|
M
ore topic actions
Deployment
Deployment web
Planning and design
Installing and upgrading
Migrating and evolving
Integrating
Administering
Monitoring
Troubleshooting
Community information and contribution guidelines
Create new topic
Topic list
Search
Advanced search
Notify
RSS
Atom
Changes
Statistics
Web preferences
NOTE: Please use the Sandbox web for testing
Status icon key:
To do
Under construction
New
Updated
Constant change
None - stable page
Smaller versions of status icons for inline text:
Copyright © by IBM and non-IBM contributing authors. All material on this collaboration platform is the property of the contributing authors.
Contributions are governed by our
Terms of Use.
Please read the following
disclaimer
.
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more
here
.