H06.05 Software Installation and Upgrade Guide

Overview of Installing the H06.05 RVU
H06.05 Software Installation and Upgrade Guide—541762-003
1-23
NonStop SQL/MX
The FCHECK utility (introduced in G06.24) includes a migration option that reports the
files that cannot be migrated to ESS because of this format limitation, in addition to
reporting the amount of disk space required for check block protection.
NonStop SQL/MX
NonStop SQL/MX Release 2.2, which has no G-series equivalent, introduces this new
functionality:
•
ANSI Names support in FUP for INFO, RELOAD, LISTLOCKS, and LISTOPENS
commands
•
ANSI Names support in DP2 EMS messages
•
FCHECK support for ANSI Names
•
FCHECK support for verifying the integrity of individual SQL/MX data rows
•
UPDATE STATISTICS - partitioned sample table for improved performance
•
SQL/MX plan size reduction in unique queries for SQLMXBUFFER
•
Dynamic SQL performance enhancement in JDBC/MX type 2 driver
Although NonStop SQL/MX Release 2.2 introduces new functionality, it is still
interoperable with compatible releases of NonStop SQL/MX. Interoperability between
G-series and H-series RVUs is supported by NonStop SQL/MX on H06.03, H06.04,
and H06.05. For more information, see the SQL/MX Database and Application
Migration Guide.
NonStop SQL/MX Release 2.2 is delivered with the H06.05 RVU SUT. If you have the
H06.05 RVU on your system, you can install SQL/MX Release 2.2. However, if you
have the H06.04 RVU on your system and you want NonStop SQL/MX Release 2.2
functionality, you must order and install the H22^ACF SPRs from Scout for NonStop
Servers. For installation information, see the SQL/MX Installation and Management
Guide.
Installing NonStop SQL/MX Release 2.2
Check that the HP NonStop Transaction Management Facility (TMF) is configured and
running on the system node where you will install NonStop SQL/MX. See the TMF
Planning and Configuration Guide for TMF installation guidelines.
Before installing NonStop SQL/MX, review the SQL/MX Installation and Management
Guide and perform all preinstallation instructions outlined in Sections 1 and 2. Section
3 describes in detail how to install NonStop SQL/MX.
You install NonStop SQL/MX after performing a system load and performing other pre-
installation steps.
Note. All NonStop SQL/MX objects must reside on volumes audited by TMF. NonStop
SQL/MX program files do not need to reside on audited volumes.