(r2) RationalQualityManagerOnlineMigrationTestMatrix < Deployment

Engineering Lifecycle Management Wiki - Deployment

Community information and contribution guidelines

~~EditAttach~~Printable

TWiki > Deployment Web > DeploymentInstallingUpgradingAndMigrating > RationalQualityManagerOnlineMigrationTestMatrix

Revision 2 - 2013-12-12 - 21:34:18 - Main.walkersd

<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

| *Database* | <b>CLM 406 Build Used</b> | *DB <br />Vendor* | *DB <br />Size* | *DB OS* | <b>DB and CLM 406 ping latency</b> | *onlineMigrateEstimate <br />Artifact Count* | *Full Offline* | *Online <br />priority = 10<br />+<br />Offline* | *Online<br />priority = 100<br />+<br />Offline* | *Online<br />priority = 50<br />+<br />Offline* | Issues tracking |
| IGA (4.0.2) | N20131118_2357  | DB2 | 380GB  | AIX  | &lt;1 ms <br><em>Note:</em> DB was taken "as is" from IGA - no indicies / statistics updates  | Type "ManualExecutionScript (32)": 963,668 states.  <br />Type "AuditableLink (192)": 266,871 states. |   | Let priority=10 run from 5:30PM on Nov 19th to 9AM Nov 20th for the estimate to "normalize". <br />Ended up with: Estimated completion time: 12/28/13 12:39 PM.<br />Nets out to 39 days, but estimate was still falling. | onlineMigration: 3.83 days <br> addTables: 16hrs  |   |   |
| 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>

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.