G06.27 Software Installation and Upgrade Guide

Overview of Installing G06.27
G06.27 Software Installation and Upgrade Guide—540067-001
1-34
NonStop SQL/MX Release 2.1.1 (G06.27)
Migration Considerations for SQL/MX Release 2.1.1
Installation of SQL/MX Release 2.1.1 consists of applying the ABX SPRs or installing
an RVU, such as G06.27, that contains the SPRs. Installation considerations are
generally the same as those documented for Releases 2.0 and 2.1. See the G06.23
installation considerations in the Interactive Upgrade Guide 2 and the G06.23 Software
Installation and Upgrade Guide.
For installation information, see the SQL/MX Installation and Management Guide. For
a summary of new features and characteristics, see the Release 2.1.0 highlights in the
Interactive Upgrade Guide 2 and the G06.27 Release Version Update Compendium.
More information about application and user module fallback can be found in the
SQL/MX Installation and Management Guide.
Migration Notes for SQL/MX Release 2.1.1
Metadata tables created and used by SQL/MX Release 2.0 and later releases are
different from those metadata tables used on prior SQL/MX releases, and the tables
are very different from those used by SQL/MP. You must be on at least Release 1.8 to
migrate to SQL/MX Release 2.1.1. Releases 2.1, 2.0, and 1.8 are the only releases of
SQL/MX that you can fall back to from Release 2.1.1.
If you are on SQL/MX Release 1.8, see also TMF (G06.23, G06.24, G06.25, and
G06.26) on page 1-43 and DP2 (G06.16, G06.23, G06.24, G06.27) on page 1-28. In
multinode installations, where queries must access data on other nodes, all nodes
must migrate to SQL/MX Release 2.0 or later at the same time. A mixture of nodes
running SQL/MX Release 1.8 and SQL/MX Release 2.0 or later is not supported.
Similar to other SQL/MX releases, because SQL/MX Release 2.1.1 is an optional
product, it can be un-installed after it has been installed on an NonStop S-series
system. You must perform a system load, but you do not need to change your current
RVU unless you want to use a previous release of SQL/MX.
•
To fall back to an SQL/MP database environment, you do not have to reinstall your
previous RVU. Before migrating to SQL/MX Release 2.1.1 from Release 1.8, HP
recommends that you install one of these DP2 fallback SPRs or a superseding
SPR on the Release 1.8 system and test it sufficiently for production use:
°
T9053APO, if the system uses the online disk remirror feature
°
T9053APG, if the node does not use the online disk remirror feature
Then you can migrate to G06.27. If a fallback becomes necessary at a later time,
you can fall back to the tested environment. For the steps to fall back from
SQL/MX Release 2.1.1, see the SQL/MX Installation and Management Guide.
•
After falling back, if you have to remove any residual SQL/MX objects:
Note. Note that a system load is required to install the DP2 fallback SPR. You must
perform the system load on your current RVU if you are migrating from Release 1.8. The
DP2 fallback SPR is already installed if you are on Release 2.0.