RationalQualityManagerOnlineMigrationTestMatrix < Deployment

<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/uc.png" alt="Under construction" width="50" height="50" align="right"> Rational Quality Manager online migration test matrix
%DKGRAY% Authors: Main.JingQian, Main.DavidWalker <br>
Build basis: Rational Quality Manager 4.0.6.
%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 Rational Quality Manager V4.0.6, you can choose to migrate data from an older version of the product to the latest product version while the production server is still online. This migration method is called pre-upgrade online migration. Before implementing an online migration, determine if offline or online migration is warranted for your repository by running the migration estimation command and then checking the following test results matrix for guidance on the results. 

If online migration is warranted for your repository, follow the detailed instructions in the Collaborative Lifecycle Management V4.0.6 Information Center, Interactive upgrade guide.

---++ Testing matrix

| *Customer data* | *Database* | *Repository size* | *Artifact counts* | *Data migration completed* | *Fully offline migration* | *Online migration recommended?* | *Online (priority=50) / Offline / Server impact <br /> (default setting)* | *Online (priority=100) / Offline / Server impact* |
| <b>Internal customer data</b>  |   |   |   |   |   |   |   |   |
| IGA (4.0.2) | DB2  | 380GB| 1 Million test script states | Yes | In Process. Estimated at 5 days | Yes | In Process. Estimated at 20 days | 4 days / 16 hours / xx% |
| IGA (3.0.1) | DB2  | 35GB| 46,000 test script states | Yes | 6 hours | No | NA | NA |
| Jazz.net (CLM selfhost test teams) | DB2  | 10GB| 1,000 test script states | Yes | One hour | No | 54 minutes / 6 minutes / xx% | NA |
| RESRQM01 | DB2  | 150GB| 120,000 test script states | Yes | In Process. Estimated at thirteen hours  | Borderline | In Process | 12 hours / 38 minutes / xx% |
|   |   |   |   |   |   |   |   |   |

| Old IGA (3.0.1) |   | DB2 |  35GB |   |  Ran full DB statistics on all tables |  2013-11-19 11:59:46,835 CRJAZ2686I Finding number of item states in database that need processing.<br />2013-11-19 11:59:51,202 Type "ManualExecutionScript (32)":  46,659 states.<br />2013-11-19 11:59:51,202 Type "AuditableLink (192)":  171,437 states. | 6 hours 18 minutes<br /><br />start: 2013-11-19 12:12:40,096<br />finish: 2013-11-19 18:30:32,486 |   |   |   |   |

| Old IGA (3.0.1) |   | DB2 | 35 GB | Windows 2008R2 VM | No DB2 statistics | 2013-11-19 11:59:46,835 CRJAZ2686I Finding number of item states in database that need processing.<br />2013-11-19 11:59:51,202 Type "ManualExecutionScript (32)":  46,659 states.<br />2013-11-19 11:59:51,202 Type "AuditableLink (192)":  171,437 states. | 6 hours 25 minutes<br /><br />start: 2013-11-19 00:47:59,329<br />finish: 2013-11-19 07:12:22,266 |   |   |   |   |

| healthcare sandbox |   | Oracle | 2GB | Linux RH |  both are rtp.raleigh.ibm.com |  2013-11-19 21:49:45,283 Type "ManualExecutionScript (21)":  197,650 states.<br />2013-11-19 21:49:45,283 Type "AuditableLink (165)":  991 states. | 3 hours<br />start: 2013-11-19 21:51:07,593 <br />finish: 2013-11-20 00:51:41,424 |   |   |   |   |

| internal self hosting (jazz.net) |   |  DB2 | 10GB |  Linux RH | avg. ping time: 0.2 ms<br /><br /> both are torolab.ibm.com | Type "AuditableLink", 0 of 12,497 states<br />Type "ManualExecutionScript", 0 of 9,951 states |   |   |   | 54+6 = 1 hour<br /><br />online: 54 minutes <br />start: 2013-11-25 17:31:17<br />finish: 2013-11-25 18:25:32<br /><br />offline: 6 minutes<br /><br />start: 2013-11-25 20:51:56 <br />finish: 2013-11-25 20:57:43 |   |

| rqmx64d |  Jazz Foundation - Core Libraries, Version 4.0.6 M1 (RJF-I20131114-1931)<br /> Quality Management - Core Libraries, Version 4.0.6 M1 (N20131114_2354) |  DB2 |  42GB |  Windows 2008R2 VM | No latency<br /><br />DB and CLM 406 are on the same machine |  2013-11-15 12:18:55,479 CRJAZ2686I Finding number of item states in database that need processing.<br />2013-11-15 12:19:00,729 Type "ManualExecutionScript (21)":  7,398 states.<br />2013-11-15 12:19:00,729 Type "AuditableLink (177)":  10,242 states. | 35 minutes<br />start: 2013-11-15 12:21:23,494 <br />finish: 2013-11-15 12:56:21,838 |   |   |   |   |

| resrqm01  |   | DB2  | 150GB  |   |   | Type "ManualExecutionScript (32)":  119,925 states. <br> Type "AuditableLink (192)":  294,913 states.  |   |   | online: 12 hrs <br> addTables: 39 minutes  |   |   |
|   |   |   |   |   |   |   |   |   |



---+++++!! Related topics: [[DeploymentWebHome][Deployment web home]]

---+++++!! External links:          

   * [[https://www.ibm.com][IBM]]

---+++++!! Additional contributors: Main.JingQian

<sticky></div></sticky>

This topic: Deployment > WebHome > DeploymentInstallingUpgradingAndMigrating > RationalQualityManagerOnlineMigrationTestMatrix

History: r3 - 2013-12-16 - 21:01:09 - Main.walkersd

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.