(r29) CollaborativeLifecycleManagementPerformanceReportRDNG60Migration < Deployment

Engineering Lifecycle Management Wiki - Deployment
Community information and contribution guidelines
~~EditAttach~~Printable
TWiki > Deployment Web > DeploymentPlanningAndDesign > PerformanceDatasheetsAndSizingGuidelines > CollaborativeLifecycleManagementPerformanceReportRDNG60Migration
Revision 29 - 2015-06-02 - 23:13:23 - VaughnRokosz
<div id="header-title" 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%">
---+!! <img src="https://jazz.net/wiki/pub/Deployment/WebPreferences/new.png" alt="new.png" width="50" height="50" align="right"> Migration guide for Rational DOORS Next Generation 6.0</br>
%DKGRAY% Authors: Main.GustafSvensson, Main.VaughnRokosz <br>
Date: May 29, 2015 </br>
Build basis: Rational Doors Next Generation (RDNG) 6.0

%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>

---++ Introduction
This document summarizes the results of our performance testing of the upgrade to IBM® Rational® DOORS® Next Generation (RDNG) 6.0.   We look at the time required to upgrade from RDNG 5.0.2 to 6.0 in a variety of configurations, and identify the factors that most influence upgrade time, including:
   * the total number of artifacts in the repository
   * the number of comments and links
   * the impact of baselines in the 5.0.x data
   * the network latency to the database server
   * using Oracle vs. DB2

We also look at how the size of the database is impacted by the upgrade.

Upgrade times in your environments may be different that what we observed.   Please be sure to review our [[#StandardDisclaimer][standard disclaimer]].

---++ Summary of test results
---+++ General considerations
There are two general considerations for upgrade performance:
   * Keeping the [[#DatabaseStatistics][database statistics]] updated
   * Adjusting the [[#RepotoolsHeap][heap size for the repotools-rm command]]
#DatabaseStatistics
---++++ Database statistics
Because there are significant changes to the schema of the DNG database for the 6.0 release, it is important to be sure that the database statistics are kept up to date.    Some of the new DNG tables will start out empty and then grow during upgrade.    This change in table size can degrade performance of the SQL queries that are executed during upgrade if your database is not configured to update statistics automatically.    

If you update your database statistics manually, you may need to update the statistics during the upgrade process.   You can use the following commands:

DB2
<verbatim>DB2 REORGCHK UPDATE STATISTICS ON TABLE ALL </verbatim>

Oracle
<verbatim>EXEC DBMS_STATS.gather_schema_stats('RMSCHEMA');</verbatim>
(where RMSCHEMA is the name of the RM database).
#RepotoolsHeap
---++++ Repotools JVM heap size

For larger repositories (> 100K artifacts), the default heap size in the repotools-rm command is too small.   The upgrade will fail unless you raise the heap size from the default of 1.5G to 8G.    Our tests also suggest that the 8G heap size can improve upgrade performance by 20%, for smaller repositories.

The repotools script was updated with the following line; VMARGS="$VMARGS -Xmx8G"  <!-- See technote "link" for additional details. -->

---+++ Impact of repository size and shape

The main factor that impacts upgrade time is the total number of artifacts of the following types:   requirements, comments, and links.   It takes roughly 5 minutes per 100K artifacts to upgrade with no baselines present.    In our largest test with 4.9 million total requirements, comments, and links, the migration time for those artifacts was 4 hours.

<!--
A secondary factor that impacts upgrade time is total number of comments.   There is an additional upgrade step which deals with comments.    In our largest test, we migrated 1.6 million comments and this took 71 minutes.    The total upgrade time for this configuration was 5 hours and 26 minutes.
-->

A secondary factor that impacts upgrade time is the number of artifacts with comments.   There is an additional upgrade step which deals with comments.    In our largest test, we migrated 1.6 million comments associated with 551,000 artifacts and this took 71 minutes.    The total upgrade time for this configuration was 5 hours and 26 minutes.

Baselines and reviews will add additional cost.  There are several factors that determine the time it takes to migrate baselines and reviews.  The number of artifacts included in baselines and reviews do not impact the migration time but the number of artifacts with revisions do.  Each baseline and review also adds extra processing time.

When we upgraded a repository with 2 baselines per module (where each baseline included 10% of the module artifacts), the time to upgrade doubled.

---+++ Database growth during upgrade
You can expect the DNG database to grow at least 10% during the upgrade process.   The 6.0 release introduces several major new features, and these features involve changes to the database schema.  
In our testing the database size grew with 0.4GB for every 100,000 artifacts.  In our most [[#DatabaseGrowth][extreme result]] (with almost 5 million artifacts), the size of the DNG database nearly doubled (from 22G to 40G).  Customer data shows this ratio can vary.
<!--
    You may see more growth if there are large numbers of comments in your repository.   In our most [[#DatabaseGrowth][extreme result]] (with 1.6 million comments), the size of the RM database nearly doubled (from 22G to 40G).
-->

---+++ Impact of network latency to the database server

We looked at the [[#LatencyImpact][impact of increasing the network latency]] between the system where we ran the upgrade to the database server.    There is a linear increase in total upgrade times as the network latency increases, and the upgrade times double for each additional 2 milliseconds of network latency.    

<img src="%ATTACHURLPATH%/Latency.png" alt="Latency.png" width="35%" height="35%">

For best upgrade performance, be sure that the network connection to the database service is fast.     

---+++ Comparing Oracle and DB2

We compared the upgrade times for two systems:  [[#DB2vsOracle][one using DB2 and one using Oracle]].   There was no significant difference in upgrade times.    
<br>


---++ Appendix A:  Standard disclaimer
#StandardDisclaimer

The information in this document is distributed AS IS. The use of this information or the implementation of any of these techniques is a customer responsibility and depends on the customer’s ability to evaluate and integrate them into the customer’s operational environment. While each item may have been reviewed by IBM for accuracy in a specific situation, there is no guarantee that the same or similar results will be obtained elsewhere. Customers attempting to adapt these techniques to their own environments do so at their own risk. Any pointers in this publication to external Web sites are provided for convenience only and do not in any manner serve as an endorsement of these Web sites. Any performance data contained in this document was determined in a controlled environment, and therefore, the results that may be obtained in other operating environments may vary significantly. Users of this document should verify the applicable data for their specific environment. 

Performance is based on measurements and projections using standard IBM benchmarks in a controlled environment. The actual throughput or performance that any user will experience will vary depending upon many factors, including considerations such as the amount of multi-programming in the user’s job stream, the I/O configuration, the storage configuration, and the workload processed. Therefore, no assurance can be given that an individual user will achieve results similar to those stated here. 

This testing was done as a way to compare and characterize the differences in performance between different versions of the product. The results shown here should thus be looked at as a comparison of the contrasting performance between different versions, and not as an absolute benchmark of performance. 

---++ Appendix B:   Summary of all test runs
 
The test results

<table id="_1222" style="margin-left: 5px; " cellpadding="0" cellspacing="0" border="1">
   <tbody>
#CountImpact
      <tr>
         <td colspan="1" id="_1223" rowspan="1" style="width: 222px; vertical-align: center; ">
            <p dir="ltr" id="_1224" style="margin-left: 5px; "><b>&nbsp;Repository</b></p>
         </td>
         <td colspan="1" id="_1413" rowspan="1" style="width: 75px; vertical-align: center; ">
            <p dir="ltr" id="_1226" style="margin-left: 5px; "><b>&nbsp;Database vendor</b></p>
         </td>
         <td colspan="1" id="_1225" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1226" style="margin-left: 5px; "><b>&nbsp;Total migration time</b></p>
         </td>
         <td colspan="1" id="_1400" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1226" style="margin-left: 5px; "><b>&nbsp;Artifacts with comments / time to migrate</b></p>
         </td>
         <td colspan="1" id="_1400" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1226" style="margin-left: 5px; "><b>&nbsp;Time to migrate 10,000 artifacts with comments</b></p>
         </td>
         <td colspan="1" id="_1400" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1226" style="margin-left: 5px; "><b>&nbsp;Total number of artifacts</b></p>
         </td>
         <td colspan="1" id="_1400" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1226" style="margin-left: 5px; "><b>&nbsp;Time to migrate 100,000 artifacts</b></p>
         </td>
         <td colspan="1" id="_1227" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; "><b>&nbsp;Database size before/after migration</b></p>
         </td>
         <td colspan="1" id="_1406" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; "><b>&nbsp;Database size change GB/%</b></p>
         </td>
         <td colspan="1" id="_1406" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; "><b>&nbsp;Database size increase for 100,000 artifacts</b></p>
         </td>
         <td colspan="1" id="_1406" rowspan="1" style="width: 80px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; "><b>&nbsp;Latency</b></p>
         </td>
      </tr>
      <tr>
         <td colspan="1" id="_1229" rowspan="1" style="width: 222px; vertical-align: center; ">
            <p dir="ltr" id="_1230" style="margin-left: 5px; ">1 project shape 1</p>
         </td>
         <td colspan="1" id="_1414" rowspan="1" style="width: 75px; vertical-align: center; ">
            <p dir="ltr" id="_1238" style="margin-left: 5px; ">DB2 10.1</p>
         </td>
         <td colspan="1" id="_1401" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1238" style="margin-left: 5px; ">40 minutes</p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; ">85,930 / 11 minutes </p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; ">1 minute 17 seconds </p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; "> 823,441 versions took 27 minutes</p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; "> 3 minutes 17 seconds</p>
         </td>
         <td colspan="1" id="_1233" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1234" style="margin-left: 5px; ">4.9GB / 7.98GB</p>
         </td>
         <td colspan="1" id="_1407" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; ">3.08GB / 63%</p>
         </td>
         <td colspan="1" id="_1407" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; ">0.374GB</p>
         </td>
         <td colspan="1" id="_1407" rowspan="1" style="width: 80px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; ">0.2 ms</p>
         </td>
      </tr>
#DatabaseGrowth
      <tr>
         <td colspan="1" id="_1235" rowspan="1" style="width: 222px; vertical-align: center; ">
            <p dir="ltr" id="_1236" style="margin-left: 5px; ">6 projects shape 1</p>
         </td>
         <td colspan="1" id="_1415" rowspan="1" style="width: 75px; vertical-align: center; ">
            <p dir="ltr" id="_1238" style="margin-left: 5px; ">DB2 10.1</p>
         </td>
         <td colspan="1" id="_1402" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1238" style="margin-left: 5px; ">5 hours 26 minutes</p>
         </td>
         <td colspan="1" id="_1237" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1238" style="margin-left: 5px; ">550,580 / 71 minutes</p>
         </td>
         <td colspan="1" id="_1237" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1238" style="margin-left: 5px; ">1 minuted 17 seconds</p>
         </td>
         <td colspan="1" id="_1237" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1238" style="margin-left: 5px; ">4,940,678 versions took 4 Hours</p>
         </td>
         <td colspan="1" id="_1237" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1238" style="margin-left: 5px; ">4 minutes 51 seconds</p>
         </td>
         <td colspan="1" id="_1239" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1240" style="margin-left: 5px; ">22.24GB / 40.28GB</p>
         </td>
         <td colspan="1" id="_1408" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; ">18.04GB / 81%</p>
         </td>
         <td colspan="1" id="_1407" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; ">0.365GB</p>
         </td>
         <td colspan="1" id="_1407" rowspan="1" style="width: 80px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; ">0.2 ms</p>
      </tr>
      <tr>
         <td colspan="1" id="_1241" rowspan="1" style="width: 222px; vertical-align: center; ">
            <p dir="ltr" id="_1242" style="margin-left: 5px; ">1 project shape 2</p>
         </td>
         <td colspan="1" id="_1416" rowspan="1" style="width: 75px; vertical-align: center; ">
            <p dir="ltr" id="_1238" style="margin-left: 5px; ">DB2 10.1</p>
         </td>
         <td colspan="1" id="_1403" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1238" style="margin-left: 5px; ">1 hour 15 minutes</p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; ">80,625 / 13 minutes</p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; ">1 minute 37 seconds</p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; "> 634,101 versions took 1 hour 7 minutes</p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; "> 9 minutes 28 sec</p>
         </td>
         <td colspan="1" id="_1243" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1244" style="margin-left: 5px; ">9.61GB / 11.95GB</p>
         </td>
         <td colspan="1" id="_1409" rowspan="1" style="width: 80px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; ">2.34GB / 24%</p>
         </td>
         <td colspan="1" id="_1407" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; ">0.369GB</p>
         </td>
         <td colspan="1" id="_1245" rowspan="1" style="width: 80px; vertical-align: center; ">
            <p dir="ltr" id="_1246" style="margin-left: 5px; ">0.2 ms</p>
         </td>
      </tr>
      <tr>
         <td colspan="1" id="_1247" rowspan="1" style="width: 222px; vertical-align: center; ">
            <p dir="ltr" id="_1248" style="margin-left: 5px; ">3 projects shape 2</p>
         </td>
         <td colspan="1" id="_1417" rowspan="1" style="width: 75px; vertical-align: center; ">
            <p dir="ltr" id="_1238" style="margin-left: 5px; ">DB2 10.1</p>
         </td>
         <td colspan="1" id="_1404" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1238" style="margin-left: 5px; ">3 hours 38 minutes</p>
         </td>
         <td colspan="1" id="_1249" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1250" style="margin-left: 5px; ">170,555 / 28 minutes</p>
         </td>
         <td colspan="1" id="_1249" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1250" style="margin-left: 5px; ">1 minute 39 sec</p>
         </td>
         <td colspan="1" id="_1249" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1250" style="margin-left: 5px; ">1,483,437 took 2 hours 38 minutes</p>
         </td>
         <td colspan="1" id="_1249" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1250" style="margin-left: 5px; ">10 minutes 39 seconds</p>
         </td>
         <td colspan="1" id="_1251" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1252" style="margin-left: 5px; ">23.19GB / 28.55GB</p>
         </td>
         <td colspan="1" id="_1410" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; ">5.36GB / 23%</p>
         </td>
         <td colspan="1" id="_1407" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; ">0.361GB</p>
         </td>
         <td colspan="1" id="_1245" rowspan="1" style="width: 80px; vertical-align: center; ">
            <p dir="ltr" id="_1246" style="margin-left: 5px; ">0.2 ms</p>
         </td>
      </tr>
      <tr>
#DB2vsOracle
         <td>
            <p colspan="11" id="_1545" rowspan="1">Comparing DB2 and Oracle</p>
         </td>
      </tr>
      <tr>
      <tr>
         <td colspan="1" id="_1253" rowspan="1" style="width: 222px; vertical-align: center; ">
            <p dir="ltr" id="_1254" style="margin-left: 5px; ">1 project shape 2</p>
         </td>
         <td colspan="1" id="_1418" rowspan="1" style="width: 75px; vertical-align: center; ">
            <p dir="ltr" id="_1238" style="margin-left: 5px; ">DB2 10.1</p>
         </td>
         <td colspan="1" id="_1405" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1238" style="margin-left: 5px; ">2 hours 6 minutes</p>
         </td>
         <td colspan="1" id="_1255" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1256" style="margin-left: 5px; ">65,555 / 13 minutes</p>
         </td>
         <td colspan="1" id="_1405" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1238" style="margin-left: 5px; ">1 minute 59 seconds</p>
         </td>
         <td colspan="1" id="_1255" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1256" style="margin-left: 5px; ">552,106 took 1 hours 45 minutes</p>
         </td>
         <td colspan="1" id="_1255" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1256" style="margin-left: 5px; ">19 minutes</p>
         </td>
         <td colspan="1" id="_1257" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1258" style="margin-left: 5px; ">8.95GB / 11.13GB</p>
         </td>
         <td colspan="1" id="_1410" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; ">2.18GB / 24%</p>
         </td>
         <td colspan="1" id="_1407" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; ">0.395GB</p>
         </td>
         <td colspan="1" id="_1245" rowspan="1" style="width: 80px; vertical-align: center; ">
            <p dir="ltr" id="_1246" style="margin-left: 5px; ">0.2 ms</p>
         </td>
      </tr>
      <tr>
         <td colspan="1" id="_1259" rowspan="1" style="width: 222px; vertical-align: center; ">
            <p dir="ltr" id="_1260" style="margin-left: 5px; ">1 project shape 2</p>
         </td>
         <td colspan="1" id="_1419" rowspan="1" style="width: 75px; vertical-align: center; ">
            <p dir="ltr" id="_1238" style="margin-left: 5px; ">Oracle 12c</p>
         </td>
         <td colspan="1" id="_1406" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1238" style="margin-left: 5px; ">1 hour 47 minutes</p>
         </td>
         <td colspan="1" id="_1255" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1256" style="margin-left: 5px; ">69,889/ 8 minutes 41 seconds</p>
         </td>
         <td colspan="1" id="_1255" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1256" style="margin-left: 5px; ">1 minute 15 seconds</p>
         </td>
         <td colspan="1" id="_1255" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1256" style="margin-left: 5px; ">704,488 took 1 hours 36 minutes</p>
         </td>
         <td colspan="1" id="_1255" rowspan="1" style="width: 130px; ve8tical-align: center; ">
            <p dir="ltr" id="_1256" style="margin-left: 5px; ">13 minutes 36 seconds</p>
         </td>
         <td colspan="1" id="_1257" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1258" style="margin-left: 5px; ">8.94GB / 10.82GB</p>
         </td>
         <td colspan="1" id="_1410" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; ">1.88GB / 21%</p>
         </td>         
         <td colspan="1" id="_1407" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; ">0.267GB</p>
         </td>
         <td colspan="1" id="_1245" rowspan="1" style="width: 80px; vertical-align: center; ">
            <p dir="ltr" id="_1246" style="margin-left: 5px; ">0.2 ms</p>
         </td>
      </tr>
#LatencyImpact
      <tr>
         <td>
            <p colspan="11" id="_1545" rowspan="1">Latency tests</p>
         </td>
      </tr>
      <tr>
         <td colspan="1" id="_1241" rowspan="1" style="width: 222px; vertical-align: center; ">
            <p dir="ltr" id="_1242" style="margin-left: 5px; ">1 project shape 2</p>
         </td>
         <td colspan="1" id="_1416" rowspan="1" style="width: 75px; vertical-align: center; ">
            <p dir="ltr" id="_1238" style="margin-left: 5px; ">DB2 10.1</p>
         </td>
         <td colspan="1" id="_1403" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1238" style="margin-left: 5px; ">1 hour 21 minutes</p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; ">80,625 / 4 minutes 45 seconds</p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; ">35 seconds</p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; "> 633,750 versions took 1 hour 15 minutes</p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; "> 11 minutes 50 seconds</p>
         </td>
         <td colspan="1" id="_1243" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1244" style="margin-left: 5px; ">10.18GB / 12.22GB</p>
         </td>
         <td colspan="1" id="_1409" rowspan="1" style="width: 80px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; ">2.04GB / 20%</p>
         </td>
         <td colspan="1" id="_1407" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; ">0.322GB</p>
         </td>
         <td colspan="1" id="_1245" rowspan="1" style="width: 80px; vertical-align: center; ">
            <p dir="ltr" id="_1246" style="margin-left: 5px; ">0.2 ms</p>
         </td>
      </tr>
      <tr>
         <td colspan="1" id="_1241" rowspan="1" style="width: 222px; vertical-align: center; ">
            <p dir="ltr" id="_1242" style="margin-left: 5px; ">1 project shape 2</p>
         </td>
         <td colspan="1" id="_1416" rowspan="1" style="width: 75px; vertical-align: center; ">
            <p dir="ltr" id="_1238" style="margin-left: 5px; ">DB2 10.1</p>
         </td>
         <td colspan="1" id="_1403" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1238" style="margin-left: 5px; ">2 hours 43 minutes</p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; ">80,625 / 9 minutes 18 seconds</p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; ">1 minute 12 seconds</p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; "> 633,750 versions took 2 hours 31 minutes</p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; "> 23 minutes 50 seconds</p>
         </td>
         <td colspan="1" id="_1243" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1244" style="margin-left: 5px; ">10.18GB / 12.22GB</p>
         </td>
         <td colspan="1" id="_1409" rowspan="1" style="width: 80px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; ">2.04GB / 20%</p>
         </td>
         <td colspan="1" id="_1407" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; ">0.322GB</p>
         </td>
         <td colspan="1" id="_1245" rowspan="1" style="width: 80px; vertical-align: center; ">
            <p dir="ltr" id="_1246" style="margin-left: 5px; ">2 ms</p>
         </td>
      </tr>
      <tr>
         <td colspan="1" id="_1241" rowspan="1" style="width: 222px; vertical-align: center; ">
            <p dir="ltr" id="_1242" style="margin-left: 5px; ">1 project shape 2</p>
         </td>
         <td colspan="1" id="_1416" rowspan="1" style="width: 75px; vertical-align: center; ">
            <p dir="ltr" id="_1238" style="margin-left: 5px; ">DB2 10.1</p>
         </td>
         <td colspan="1" id="_1403" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1238" style="margin-left: 5px; ">4 hours 8 minutes</p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; ">80,625/ 14 minutes 58 seconds</p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; ">1 minute 51 seconds</p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; "> 633,750 versions took 3 hours 51 minutes</p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; ">36 minutes 27 seconds</p>
         </td>
         <td colspan="1" id="_1243" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1244" style="margin-left: 5px; ">10.18GB / 12.22GB</p>
         </td>
         <td colspan="1" id="_1409" rowspan="1" style="width: 80px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; ">2.04GB / 20%</p>
         </td>
         <td colspan="1" id="_1407" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; ">0.322GB</p>
         </td>
         <td colspan="1" id="_1245" rowspan="1" style="width: 80px; vertical-align: center; ">
            <p dir="ltr" id="_1246" style="margin-left: 5px; ">4 ms</p>
         </td>
      </tr>
#CustomerData
      <tr>
         <td>
            <p colspan="1" id="_1545" rowspan="1">Migrations done using customer data</p>
         </td>
      </tr>
      <tr>
         <td colspan="1" id="_1229" rowspan="1" style="width: 222px; vertical-align: center; ">
            <p dir="ltr" id="_1530" style="margin-left: 5px; ">Customer A - 56 projects</p>
         </td>
         <td colspan="1" id="_1414" rowspan="1" style="width: 75px; vertical-align: center; ">
            <p dir="ltr" id="_1238" style="margin-left: 5px; ">DB2 10.1</p>
         </td>
         <td colspan="1" id="_1401" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1238" style="margin-left: 5px; ">48 minutes</p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; ">9,385 / 1 minute</p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; ">1 minute</p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; "> 100,357 versions took 44 minutes</p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; ">43 minutes 51 sec</p>
         </td>
         <td colspan="1" id="_1233" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1234" style="margin-left: 5px; ">17.6GB / 19.1GB</p>
         </td>
         <td colspan="1" id="_1407" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; ">1.5GB / 9%</p>
         </td>
         <td colspan="1" id="_1407" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; ">1.494GB</p>
         </td>
         <td colspan="1" id="_1407" rowspan="1" style="width: 80px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; ">0.22 ms</p>
      </tr>
      <tr>
         <td colspan="1" id="_1229" rowspan="1" style="width: 222px; vertical-align: center; ">
            <p dir="ltr" id="_1230" style="margin-left: 5px; ">Customer B - 9 projects</p>
         </td>
         <td colspan="1" id="_1414" rowspan="1" style="width: 75px; vertical-align: center; ">
            <p dir="ltr" id="_1238" style="margin-left: 5px; ">DB2 10.1</p>
         </td>
         <td colspan="1" id="_1401" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1238" style="margin-left: 5px; ">46 minutes</p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; ">0 comments</p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; ">Not applicable</p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; "> 513,371 versions took 42 minutes</p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; ">8 minutes 11 sec</p>
         </td>
         <td colspan="1" id="_1233" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1234" style="margin-left: 5px; ">8.6GB / 9.2GB</p>
         </td>
         <td colspan="1" id="_1407" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; ">0.6GB / 7%</p>
         </td>
         <td colspan="1" id="_1407" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; ">0.117GB</p>
         </td>
         <td colspan="1" id="_1407" rowspan="1" style="width: 80px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; ">0.22 ms</p>
      </tr>
      <tr>
         <td colspan="1" id="_1229" rowspan="1" style="width: 222px; vertical-align: center; ">
            <p dir="ltr" id="_1230" style="margin-left: 5px; ">Customer C - 119 projects</p>
         </td>
         <td colspan="1" id="_1414" rowspan="1" style="width: 75px; vertical-align: center; ">
            <p dir="ltr" id="_1238" style="margin-left: 5px; ">DB2 10.1</p>
         </td>
         <td colspan="1" id="_1401" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1238" style="margin-left: 5px; ">10 hours 18 minutes</p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; ">6394 / 2 minutes 57 seconds</p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; ">4 minutes 37 seconds</p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; "> 810,359 versions took 10 hours 7 minutes</p>
         </td>
         <td colspan="1" id="_1231" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1232" style="margin-left: 5px; ">1 hour 16 minutes</p>
         </td>
         <td colspan="1" id="_1233" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1234" style="margin-left: 5px; ">26.18GB / 29.5GB</p>
         </td>
         <td colspan="1" id="_1407" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; ">3.32GB / 7%</p>
         </td>
         <td colspan="1" id="_1407" rowspan="1" style="width: 130px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; ">0.41GB</p>
         </td>
         <td colspan="1" id="_1407" rowspan="1" style="width: 80px; vertical-align: center; ">
            <p dir="ltr" id="_1228" style="margin-left: 5px; ">0.22 ms</p>
      </tr>
   </tbody>
</table>

---+++ Data volume and shape

For our migration tests we used the following project types

<table id="_1165" style="margin-left: 5px; " cellpadding="0" cellspacing="0" border="1">
   <tbody>
      <tr>
         <td colspan="1" id="_1166" rowspan="1" style="width: 222px; vertical-align: center; ">
            <p dir="ltr" id="_1167" style="margin-left: 5px; "><b>&nbsp;Artifact type</b></p>
         </td>
         <td colspan="1" id="_1168" rowspan="1" style="width: 75px; vertical-align: center; ">
            <p dir="ltr" id="_1169" style="margin-left: 5px; "><b>&nbsp;Project shape 1</b></p>
         </td>
         <td colspan="1" id="_1168" rowspan="1" style="width: 75px; vertical-align: center; ">
            <p dir="ltr" id="_1169" style="margin-left: 5px; "><b>&nbsp;Project shape 2</b></p>
         </td>
<!--
         <td colspan="1" id="_1168" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1169" style="margin-left: 5px; "><b>&nbsp;Project shape 3</b></p>
         </td>
         <td colspan="1" id="_1168" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1169" style="margin-left: 5px; "><b>&nbsp;Project shape 4</b></p>
         </td>
-->
         <td colspan="1" id="_1168" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1169" style="margin-left: 5px; "><b>&nbsp;Customer A</b></p>
         </td>
         <td colspan="1" id="_1168" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1169" style="margin-left: 5px; "><b>&nbsp;Customer B</b></p>
         </td>
         <td colspan="1" id="_1168" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1169" style="margin-left: 5px; "><b>&nbsp;Customer C</b></p>
         </td>
      </tr>
      <tr>
         <td colspan="1" id="_1170" rowspan="1" style="width: 222px; vertical-align: center; ">
            <p dir="ltr" id="_1171" style="margin-left: 5px; ">Modules</p>
         </td>
         <td colspan="1" id="_1172" rowspan="1" style="width: 75px; vertical-align: center; ">
            <p dir="ltr" id="_1173" style="margin-left: 5px; ">52</p>
         </td>
         <td colspan="1" id="_1172" rowspan="1" style="width: 75px; vertical-align: center; ">
            <p dir="ltr" id="_1173" style="margin-left: 5px; ">52</p>
         </td>
<!--
         <td colspan="1" id="_1172" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1173" style="margin-left: 5px; ">52</p>
         </td>
         <td colspan="1" id="_1172" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1173" style="margin-left: 5px; ">52</p>
         </td>
-->
         <td colspan="1" id="_1172" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1173" style="margin-left: 5px; ">161</p>
         </td>
         <td colspan="1" id="_1172" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1173" style="margin-left: 5px; ">452</p>
         </td>
         <td colspan="1" id="_1172" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1173" style="margin-left: 5px; ">1880</p>
         </td>
      </tr>
      <tr>
         <td colspan="1" id="_1182" rowspan="1" style="width: 222px; vertical-align: center; ">
            <p dir="ltr" id="_1183" style="margin-left: 5px; ">Folders</p>
         </td>
         <td colspan="1" id="_1184" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1185" style="margin-left: 5px; ">119</p>
         </td>
         <td colspan="1" id="_1184" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1185" style="margin-left: 5px; ">119</p>
         </td>
<!--
         <td colspan="1" id="_1184" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1185" style="margin-left: 5px; ">119</p>
         </td>
         <td colspan="1" id="_1184" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1185" style="margin-left: 5px; ">119</p>
         </td>
-->
         <td colspan="1" id="_1184" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1185" style="margin-left: 5px; ">3743</p>
         </td>
         <td colspan="1" id="_1184" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1185" style="margin-left: 5px; ">774</p>
         </td>
         <td colspan="1" id="_1172" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1173" style="margin-left: 5px; ">15,612</p>
         </td>
      </tr>
      <tr>
         <td colspan="1" id="_1182" rowspan="1" style="width: 222px; vertical-align: center; ">
            <p dir="ltr" id="_1183" style="margin-left: 5px; ">Requirement artifacts</p>
         </td>
         <td colspan="1" id="_1184" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1185" style="margin-left: 5px; ">1,118</p>
         </td>
         <td colspan="1" id="_1184" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1185" style="margin-left: 5px; ">86,171</p>
         </td>
<!--
         <td colspan="1" id="_1184" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1185" style="margin-left: 5px; ">1,118</p>
         </td>
         <td colspan="1" id="_1184" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1185" style="margin-left: 5px; ">1,118</p>
         </td>
-->
         <td colspan="1" id="_1184" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1185" style="margin-left: 5px; ">19,659</p>
         </td>
         <td colspan="1" id="_1184" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1185" style="margin-left: 5px; ">40,005</p>
         </td>
         <td colspan="1" id="_1172" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1173" style="margin-left: 5px; ">122,434</p>
         </td>
      </tr>
      <tr>
         <td colspan="1" id="_1186" rowspan="1" style="width: 222px; vertical-align: center; ">
            <p dir="ltr" id="_1187" style="margin-left: 5px; ">Module artifacts</p>
         </td>
         <td colspan="1" id="_1188" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1189" style="margin-left: 5px; ">85,000</p>
         </td>
         <td colspan="1" id="_1188" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1189" style="margin-left: 5px; ">85,000</p>
         </td>
<!--
         <td colspan="1" id="_1188" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1189" style="margin-left: 5px; ">85,000</p>
         </td>
         <td colspan="1" id="_1188" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1189" style="margin-left: 5px; ">85,000</p>
         </td>
-->
         <td colspan="1" id="_1184" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1185" style="margin-left: 5px; ">5,201</p>
         </td>
         <td colspan="1" id="_1184" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1185" style="margin-left: 5px; ">123,792</p>
         </td>
         <td colspan="1" id="_1172" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1173" style="margin-left: 5px; ">37,896</p>
         </td>
      </tr>
      <tr>
         <td colspan="1" id="_1194" rowspan="1" style="width: 222px; vertical-align: center; ">
            <p dir="ltr" id="_1195" style="margin-left: 5px; ">Comments</p>
         </td>
         <td colspan="1" id="_1196" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1197" style="margin-left: 5px; ">260,582</p>
         </td>
         <td colspan="1" id="_1196" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1197" style="margin-left: 5px; ">244,132</p>
         </td>
<!--
         <td colspan="1" id="_1196" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1197" style="margin-left: 5px; ">198,868</p>
         </td>
         <td colspan="1" id="_1196" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1197" style="margin-left: 5px; ">176,338</p>
         </td>
-->
         <td colspan="1" id="_1184" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1185" style="margin-left: 5px; ">9,385</p>
         </td>
         <td colspan="1" id="_1184" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1185" style="margin-left: 5px; ">0</p>
         </td>
         <td colspan="1" id="_1172" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1173" style="margin-left: 5px; ">21,395</p>
         </td>
      </tr>
      <tr>
         <td colspan="1" id="_1198" rowspan="1" style="width: 222px; vertical-align: center; ">
            <p dir="ltr" id="_1199" style="margin-left: 5px; ">Links</p>
         </td>
         <td colspan="1" id="_1200" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1201" style="margin-left: 5px; ">304,029</p>
         </td>
         <td colspan="1" id="_1200" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1201" style="margin-left: 5px; ">151,195</p>
         </td>
<!--
         <td colspan="1" id="_1200" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1201" style="margin-left: 5px; ">124,769</p>
         </td>
         <td colspan="1" id="_1200" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1201" style="margin-left: 5px; ">111,623</p>
         </td>
-->
         <td colspan="1" id="_1184" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1185" style="margin-left: 5px; ">20,425</p>
         </td>
         <td colspan="1" id="_1184" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1185" style="margin-left: 5px; ">93,174</p>
         </td>
         <td colspan="1" id="_1172" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1173" style="margin-left: 5px; ">404,548</p>
         </td>
      </tr>
      <tr>
         <td colspan="1" id="_1202" rowspan="1" style="width: 222px; vertical-align: center; ">
            <p dir="ltr" id="_1203" style="margin-left: 5px; ">Collections</p>
         </td>
         <td colspan="1" id="_1204" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1205" style="margin-left: 5px; ">14</p>
         </td>
         <td colspan="1" id="_1204" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1205" style="margin-left: 5px; ">14</p>
         </td>
<!--
         <td colspan="1" id="_1204" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1205" style="margin-left: 5px; ">14</p>
         </td>
         <td colspan="1" id="_1204" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1205" style="margin-left: 5px; ">14</p>
         </td>
-->
         <td colspan="1" id="_1184" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1185" style="margin-left: 5px; ">285</p>
         </td>
         <td colspan="1" id="_1184" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1185" style="margin-left: 5px; ">37</p>
         </td>
         <td colspan="1" id="_1172" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1173" style="margin-left: 5px; ">1,848</p>
         </td>
      </tr>
      <tr>
         <td colspan="1" id="_1206" rowspan="1" style="width: 222px; vertical-align: center; ">
            <p dir="ltr" id="_1207" style="margin-left: 5px; ">Tags</p>
         </td>
         <td colspan="1" id="_1208" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1209" style="margin-left: 5px; ">300</p>
         </td>
         <td colspan="1" id="_1208" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1209" style="margin-left: 5px; ">350</p>
         </td>
<!--
         <td colspan="1" id="_1208" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1209" style="margin-left: 5px; ">350</p>
         </td>
         <td colspan="1" id="_1208" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1209" style="margin-left: 5px; ">350</p>
         </td>
-->
         <td colspan="1" id="_1184" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1185" style="margin-left: 5px; ">546</p>
         </td>
         <td colspan="1" id="_1184" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1185" style="margin-left: 5px; ">10</p>
         </td>
         <td colspan="1" id="_1172" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1173" style="margin-left: 5px; ">2,220</p>
         </td>
      </tr>
      <tr>
         <td colspan="1" id="_1214" rowspan="1" style="width: 222px; vertical-align: center; ">
            <p dir="ltr" id="_1215" style="margin-left: 5px; ">Views</p>
         </td>
         <td colspan="1" id="_1216" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1217" style="margin-left: 5px; ">100</p>
         </td>
         <td colspan="1" id="_1216" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1217" style="margin-left: 5px; ">200</p>
         </td>
<!--
         <td colspan="1" id="_1216" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1217" style="margin-left: 5px; ">200</p>
         </td>
         <td colspan="1" id="_1216" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1217" style="margin-left: 5px; ">200</p>
         </td>
-->
         <td colspan="1" id="_1184" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1185" style="margin-left: 5px; ">1026</p>
         </td>
         <td colspan="1" id="_1184" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1185" style="margin-left: 5px; ">23</p>
         </td>
         <td colspan="1" id="_1172" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1173" style="margin-left: 5px; ">2,676</p>
         </td>
      </tr>
      <tr>
         <td colspan="1" id="_1218" rowspan="1" style="width: 222px; vertical-align: center; ">
            <p dir="ltr" id="_1219" style="margin-left: 5px; ">Terms</p>
         </td>
         <td colspan="1" id="_1220" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1221" style="margin-left: 5px; ">238</p>
         </td>
         <td colspan="1" id="_1220" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1221" style="margin-left: 5px; ">238</p>
         </td>
<!--
         <td colspan="1" id="_1220" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1221" style="margin-left: 5px; ">238</p>
         </td>
         <td colspan="1" id="_1220" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1221" style="margin-left: 5px; ">238</p>
         </td>
-->
         <td colspan="1" id="_1184" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1185" style="margin-left: 5px; ">521</p>
         </td>
         <td colspan="1" id="_1184" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1185" style="margin-left: 5px; ">601</p>
         </td>
         <td colspan="1" id="_1172" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1173" style="margin-left: 5px; ">1,683</p>
         </td>
      </tr>
      <tr>
         <td colspan="1" id="_1218" rowspan="1" style="width: 222px; vertical-align: center; ">
            <p dir="ltr" id="_1219" style="margin-left: 5px; ">Reviews</p>
         </td>
         <td colspan="1" id="_1220" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1221" style="margin-left: 5px; ">0</p>
         </td>
         <td colspan="1" id="_1220" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1221" style="margin-left: 5px; ">0</p>
         </td>
<!--
         <td colspan="1" id="_1220" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1221" style="margin-left: 5px; ">0</p>
         </td>
         <td colspan="1" id="_1220" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1221" style="margin-left: 5px; ">0</p>
         </td>
-->
         <td colspan="1" id="_1184" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1185" style="margin-left: 5px; ">342</p>
         </td>
         <td colspan="1" id="_1184" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1185" style="margin-left: 5px; ">0</p>
         </td>
         <td colspan="1" id="_1172" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1173" style="margin-left: 5px; ">3,884</p>
         </td>
      </tr>
      <tr>
         <td colspan="1" id="_1218" rowspan="1" style="width: 222px; vertical-align: center; ">
            <p dir="ltr" id="_1219" style="margin-left: 5px; ">Baselines</p>
         </td>
         <td colspan="1" id="_1220" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1221" style="margin-left: 5px; ">0</p>
         </td>
         <td colspan="1" id="_1220" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1221" style="margin-left: 5px; ">115</p>
         </td>
<!--
         <td colspan="1" id="_1220" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1221" style="margin-left: 5px; ">109</p>
         </td>
         <td colspan="1" id="_1220" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1221" style="margin-left: 5px; ">98</p>
         </td>
-->
         <td colspan="1" id="_1184" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1185" style="margin-left: 5px; ">57</p>
         </td>
         <td colspan="1" id="_1184" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1185" style="margin-left: 5px; ">0</p>
         </td>
         <td colspan="1" id="_1172" rowspan="1" style="width: 68px; vertical-align: center; ">
            <p dir="ltr" id="_1173" style="margin-left: 5px; ">1,166</p>
         </td>
      </tr>
   </tbody>
</table>

#TestTopology
---++  Appendix C:  Topology
The topology that was used in our testing is based on the [[https://jazz.net/wiki/bin/view/Deployment/RecommendedCLMDeploymentTopologies5#CLM_E1_Enterprise_Distributed_Li][standard (E1) Enterprise - Distributed / Linux / DB2 topology]]

<img src="%ATTACHURLPATH%/Qo0qIQ3KEeSGLpAJ1dDtYQ_New.png" alt="Qo0qIQ3KEeSGLpAJ1dDtYQ_New.png" width="50%" height="50%">

Key:
   * RM Server: Rational DOORS Next Generation Server
   * JTS: Jazz™ Team Server

All server machines and test clients are located on the same subnet. The LAN has 1000 Mbps of maximum bandwidth and 0.2 ms average latency in ping.

---+++ Tested hardware and software configurations

The specifications of machines used for most of the upgrade tests are listed below:

<table class="gray-table">
	<tbody>
		<tr>
			<th valign="top">Function</th>
			<th valign="top">Machine Type</th>
			<th valign="top">CPU / Machine</th>
			<th valign="top">Total # of CPU Cores/Machine</th>
			<th valign="top">Memory/Machine</th>
			<th valign="top">Disk</th>
			<th valign="top">Disk capacity</th>
			<th valign="top">Network interface</th>
			<th valign="top">OS and Version</th>
		</tr>
		<tr>
			<td>RDNG Server</td>
			<td>IBM System x3550 M4</td>
			<td>2 x Intel Xeon E5-2640 2.5GHz (six-core)</td>
			<td>24</td>
			<td>32GB</td>
			<td>RAID 5 -- SAS Disk x 4</td>
			<td>279GB</td>
			<td>Gigabit Ethernet</td>
			<td>Red Hat Enterprise Linux Server release 6.3 (Santiago)</td>
		</tr>
		<tr>
			<td>Database Server</td>
			<td>IBM System x3650 M4</td>
			<td>2 x Intel Xeon E5-2640 2.5GHz (six-core)</td>
			<td>24</td>
			<td>64GB</td>
			<td>RAID 10 -- SAS Disk x 16</td>
			<td>279GB</td>
			<td>Gigabit Ethernet</td>
			<td>Red Hat Enterprise Linux Server release 6.3 (Santiago)</td>
		</tr>
	</tbody>
</table>

The tests comparing [[#DB2vsOracle][upgrade times between Oracle and DB2]] used virtual systems with the following characteristics:

<table class="gray-table">
	<tbody>
		<tr>
			<th valign="top">Function</th>
			<th valign="top">Machine Type</th>
			<th valign="top">CPU / Machine</th>
			<th valign="top">Total # of CPU Cores/Machine</th>
			<th valign="top">Memory/Machine</th>
			<th valign="top">Disk capacity</th>
			<th valign="top">Network interface</th>
			<th valign="top">OS and Version</th>
		</tr>
		<tr>
			<td>RDNG Server</td>
			<td>VM image</td>
			<td>8</td>
			<td>8</td>
			<td>32GB</td>
			<td>80GB</td>
			<td>Gigabit Ethernet</td>
			<td>Red Hat Enterprise Linux Server release 6.6 (Santiago)</td>
		</tr>
		<tr>
			<td>Database Server</td>
			<td>VM image</td>
			<td>8</td>
			<td>8</td>
			<td>16GB</td>
			<td>80GB</td>
			<td>Gigabit Ethernet</td>
			<td>Red Hat Enterprise Linux Server release 6.6 (Santiago)</td>
		</tr>
	</tbody>
</table>



---++++!! For more information
   * [[PerformanceDatasheetsAndSizingGuidelines][Performance Datasheets: CLM]]

---++++!! About the authors

Main.GustafSvensson

--------------------
---+++++!! Questions and comments:
   * What other performance information would you like to see here?
   * Do you have performance scenarios to share? 
   * Do you have scenarios that are not addressed in documentation?
   * Where are you having problems in performance?

%COMMENT{type="below" target="PerformanceDatasheetReaderComments" button="Submit"}%

%INCLUDE{"PerformanceDatasheetReaderComments"}%


<sticky></div></sticky>
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.