SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

What’s New in This Manual
HP NonStop SQL/MX Installation and Management Guide—523723-004
xx
Changes in the June 2005 Revision of the Manual
Section 11, Managing
Database Applications
Added information for SQL/MX Release 2.1 in Migrating
Applications to Release 2.x on page 11-1. Also added
Migrating SQL/MX Applications From Release 2.0 to
Release 2.1 on page 11-3.
Added Versioning Issues for a Distributed Database
Environment on page 11-8.
Added Migrating SQL/MX Nodes to Obtain Improved
Query Plan Performance on page 11-15.
Added information for SQL/MX Release 2.1 in
Managing Module Files and Their Applications During
Fallback From Release 2.1 or Release 2.0 on
page 11-25.
Section 12, Performing
Recovery Operations
Added the requirement that SQL/MX objects be
recovered to a backup system with the same disk
volume name, node name, and node number as the
primary system in Recovering Database Objects on
page 12-7.
Section 13, Managing an
SQL/MX Distributed
Database
Added new versioning information for SQL/MX Release
2.1 and SQL/MX Release 1.8 in Managing Mixed
Releases of NonStop SQL/MX on page 13-25.
Section 14, Migrating an
SQL/MP Database to
NonStop SQL/MX
Release 2.1 or Release
2.0
Clarified the need to use the migrate utility
immediately after you have installed SQL/MX Release
2.1 or SQL/MX Release 2.0 and to create the user
catalogs and schemas in the SQL/MX database
required when you migrate SPJs and SQL/MP aliases
in Using the migrate Utility to Migrate SQL/MP Metadata
From Release 1.8 on page 14-5.
Added new requirements in System Requirements for
Migrating SQL/MP Metadata on page 14-6.
Added new steps in Before Migrating SQL/MP Metadata
on page 14-6.
Clarified when to use the migrate utility and the need
to create user catalogs and schemas for SQL/MP
aliases in Steps for Migrating MPALIAS Metadata From
Release 1.8 to Release 2.1 or Release 2.0 on
page 14-8.
Clarified when to use the migrate utility and the need
to create user catalogs and schemas for SPJs in Steps
for Migrating SPJs From Release 1.8 to Release 2.1 or
Release 2.0 on page 14-14.