EditAttachPrintable
TWiki > Deployment Web > DeploymentInstallingUpgradingAndMigrating > RationalQualityManagerOnlineMigrationTestMatrix
Revision 3 - 2013-12-16 - 21:01:09 - Main.walkersd

Under construction Rational Quality Manager online migration test matrix

Authors: JingQian, DavidWalker
Build basis: Rational Quality Manager 4.0.6.

Page contents

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
(default setting)
Online (priority=100) / Offline / Server impact
Internal customer data                
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.
2013-11-19 11:59:51,202 Type "ManualExecutionScript (32)": 46,659 states.
2013-11-19 11:59:51,202 Type "AuditableLink (192)": 171,437 states.
6 hours 18 minutes

start: 2013-11-19 12:12:40,096
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.
2013-11-19 11:59:51,202 Type "ManualExecutionScript (32)": 46,659 states.
2013-11-19 11:59:51,202 Type "AuditableLink (192)": 171,437 states.
6 hours 25 minutes

start: 2013-11-19 00:47:59,329
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.
2013-11-19 21:49:45,283 Type "AuditableLink (165)": 991 states.
3 hours
start: 2013-11-19 21:51:07,593
finish: 2013-11-20 00:51:41,424
       

internal self hosting (jazz.net)   DB2 10GB Linux RH avg. ping time: 0.2 ms

both are torolab.ibm.com
Type "AuditableLink", 0 of 12,497 states
Type "ManualExecutionScript", 0 of 9,951 states
      54+6 = 1 hour

online: 54 minutes
start: 2013-11-25 17:31:17
finish: 2013-11-25 18:25:32

offline: 6 minutes

start: 2013-11-25 20:51:56
finish: 2013-11-25 20:57:43
 

rqmx64d Jazz Foundation - Core Libraries, Version 4.0.6 M1 (RJF-I20131114-1931)
Quality Management - Core Libraries, Version 4.0.6 M1 (N20131114_2354)
DB2 42GB Windows 2008R2 VM No latency

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.
2013-11-15 12:19:00,729 Type "ManualExecutionScript (21)": 7,398 states.
2013-11-15 12:19:00,729 Type "AuditableLink (177)": 10,242 states.
35 minutes
start: 2013-11-15 12:21:23,494
finish: 2013-11-15 12:56:21,838
       

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

Related topics: Deployment web home

External links:

Additional contributors: JingQian

Edit | Attach | Printable | Raw View | Backlinks: Web, All Webs | History: r20 | r5 < r4 < r3 < r2 | More topic actions...
This site is powered by the TWiki collaboration platformCopyright © 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.