SQL/MX 3.2.1 Installation and Upgrade Guide (H06.26+, J06.15+)

Guidelines for conducting the system upgrade
To ensure a successful system upgrade, use the following guidelines:
• “Conducting the initial upgrade in a test environment” (page 31)
• “Running baseline tests and gathering data at each upgrade phase” (page 31)
• “Assessing the success of the upgrade” (page 31)
Conducting the initial upgrade in a test environment
To avoid disrupting the production database and daily business operations, isolate the key
applications and database objects to upgrade and conduct the initial migration in a test environment.
The test environment must simulate the production environment as much as possible.
Running baseline tests and gathering data at each upgrade phase
Before you upgrade, use Measure to obtain initial baseline data, such as average query run time,
CPU time, and process time. At each upgrade phase, gather the same type of data and analyze
it. For more information about Measure, see the Measure User’s Guide.
Assessing the success of the upgrade
The data that you gather during each upgrade phase will help you to determine the success of
upgrade. Prepare to answer the following questions:
• What did functional, performance, and scalability testing reveal during upgrade?
• How can you use these results to improve and fine tune the upgrade process before migrating
applications and database objects in the production environment?
Assistance with upgrade
Specific strategies for upgrading to SQL/MX Release 3.2.x depend on your specific database
environment and business needs. The following HP services can help you determine and implement
the best upgrade strategy for your business:
• “Product support for NonStop servers” (page 31)
• “NonStop solutions development and implementation” (page 31)
Product support for NonStop servers
The Global NonStop Solution Center (GNSC) is staffed by highly trained analysts who support
NonStop systems. These analysts can help you migrate your systems. For more information, see
the web site
http://www8.hp.com/us/en/services/services-detail.html?compURI=tcm:245- 808927&
pageTitle=Product-Support-for-NonStop-Servers
NonStop solutions development and implementation
NonStop Solutions Development and Implementation (SDI) provides a porting and migration service
to help you plan and implement application migration and database upgrade on your NonStop
system. SDI works with you to develop a comprehensive plan for successfully migrating your
applications and database while achieving high levels of availability and performance with minimal
risk to business continuity.
The service plan identifies the changes required for system software, application and utility programs,
development and test environments, database configuration, and database loading. The service
plan includes a comprehensive report that describes the scope and strategy for migrating your
applications and database, a detailed project plan, and a statement of work for services to help
Guidelines for conducting the system upgrade 31