SQL/MX 2.x Database and Application Migration Guide (G06.23+, H06.04+, J06.03+)

HP NonStop SQL/MX Database and Application Migration Guide—540435-005
5-1
5
Preparing to Migrate From SQL/MX
Release 1.8 to SQL/MX Release 2.x
Before migrating from SQL/MX Release 1.8 to SQL/MX Release 2.x, follow these
planning guidelines:
•
Meeting System Hardware Requirements on page 5-1
•
Meeting Operating System Requirements on page 5-1
•
Planning for Performance and Capacity on page 5-2
•
Planning for Fallback on page 5-2
•
Ordering the Latest Supported Version of SQL/MX Release 2.x on page 5-4
•
Ordering Corequisite Independent Products on page 5-4
•
Preparing for Metadata Migration on page 5-4
•
Preparing to Migrate Applications on page 5-5
•
Planning to Migrate Other Nodes in the Network on page 5-5
•
Steps for Migrating From SQL/MX Release 1.8 to SQL/MX Release 2.x on
page 5-5
Meeting System Hardware Requirements
SQL/MX Release 2.x requires processors that support IEEE floating-point functions. All
processors in a node on which SQL/MX Release 2.x is installed must be Model 1954
(S72000) or later. Otherwise, the
InstallSqlmx script does not install SQL/MX
Release 2.x. For more information about installing NonStop SQL/MX, see the
SQL/MX
Installation and Management Guide.
SQL/MX Release 1.8 is not supported on systems running H-series RVUs. Before
migrating from a NonStop S-series system to an Integrity NonStop NS-series system,
first migrate from SQL/MX Release 1.8 to SQL/MX Release 2.x on the S-series
system. Then migrate the SQL/MX Release 2.x database to the NS-series system. For
more information, see the
NonStop NS-Series Database Migration Guide.
Meeting Operating System Requirements
SQL/MX Release 2.x requires G06.23 or a later RVU and is not supported on
pre-G06.23 RVUs.
Fallback to SQL/MX releases earlier than SQL/MX Release 1.8 is not supported. If you
are using an SQL/MX release earlier than SQL/MX Release 1.8, you must migrate to