Rational Quality Manager online migration test matrix

Disclaimer

The information in this testing matrix table is distributed AS IS. The use of this information is a customer responsibility and depends on the customer’s ability to evaluate into their 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. 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 drastically. Users of this document should verify the applicable data for their specific environment.

The actual throughput or performance that any user will experience will vary depending upon many factors, including considerations such as the network latency between servers, the I/O configuration, the storage configuration, the workload processed, the DB server tuning and the specific data shape. Therefore, no assurance can be given that an individual user will achieve results similar to those stated here.

Summary

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 whether 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 your database contains a large amount of data, online migration reduces server downtime by running a few of the database migration tasks while the old server remains active. Which would otherwise exceed the acceptable downtime window using the traditional offline migration.

If online migration is recommended for your repository, follow the detailed instructions in the Online migration for Rational Quality Manager data

Understanding Performance Measure and Online Migration

Besides the ones mentioned above, the following factors also have significant impact on your migration performance results.

• The network latency from the server running migration to the database where your repository resides
• If your database table index is up to date
• The shape of your RQM data, specifically
  • The number of manual execution script state (you can get the count from the onlineEstimate command)
  • The number of script steps in each of the script state
  • The content size of each script step, does it contain large amount of rich text, images.

The purpose of this testing matrix is to help customers extrapolate in terms of rough scale on what the migration performance might be. So customer could make a decision on migration using online vs. offline mode. We strongly recommend customers whose repository exceeds 100GB and has 1,000,000 or more script states should perform an online migration to minimize production downtime. If you are unsure of whether or not online migration is correct for your deployment we suggest you reach out to your support representative and the team will guide you to make the best decision for your organization.

During online migration, online migration process is running as a separate JVM against your live DB server. The data is migrated in such a way as to not affect users on the existing server. RQM online migration process does not make modifications to your existing data. It only migrates data into new tables in the database. Online migration is designed can be stopped and resumed at any given time. If there are failure during online migration, once the underline issues are fixed, online migration can resume from where it was left off.

As a best practice, customer should have a sandbox environment that replicates production data in order to do a dry run of migration to get a more accurate estimate time.

Testing matrix

Related topics: Deployment web home

External links:

• Online migration for Rational Quality Manager data
• IBM

Additional contributors: JingQian, JohnNason, RosaNaranjo