H06.06 Software Installation and Upgrade Guide

Overview of Installing the H06.06 RVU
H06.06 Software Installation and Upgrade Guide—542652-002
1-25
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
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
NonStop SQL/MX Release 2.2 is 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, H06.05, and H06.06. For more information
about the interoperability of NonStop SQL/MX releases, see the SQL/MX Database
and Application Migration Guide.
NonStop SQL/MX Release 2.2 is delivered with the H06.06 RVU SUT. If you have the
H06.06 RVU on your system, you can install SQL/MX Release 2.2. 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 instructions for preinstalling and
installing NonStop SQL/MX provided in the SQL/MX Installation and Management
Guide.
OSS
See the Open System Services Management and Operations Guide and the Open
System Services Installation Guide for information about updating and maintaining
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.