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

Contents

HP NonStop SQL/MX Database and Application Migration Guide—540435-005

1. Overview of SQL/MX Migration (continued)

NonStop Solutions Development and Implementation 1-20

Part I. Upgrading and Maintaining Different

Versions of NonStop SQL/MX

2. Version Management and Interoperability

Purpose of Versioning 2-1

NonStop SQL/MX Releases 2-2

SQL/MX Releases on Systems Running G-Series RVUs and H-Series RVUs 2-2

Naming Scheme for SQL/MX Releases 2-4

Product Version and SPR Identifiers 2-6

Availability of SQL/MX Releases 2-6

Delivery of SQL/MX Releases 2-7

RVUs and Supported SQL/MX Releases 2-7

Interoperability of NonStop SQL/MX Releases 2-8

Versions of SQL/MX Software Components 2-9

Version Identification of SQL/MX Software Components 2-9

SQL/MX System Software Version (MXV) 2-10

SQL/MX Database Object Versions 2-11

SQL/MX Query Plan and Module Versions 2-12

Managing SQL/MX Database Object Versions 2-13

Managing SQL/MX Query Plan Versions 2-14

Query Plan Versioning in SQL/MX Releases 2.x 2-14

Compiling Mixed-Version Queries 2-15

Managing a Mixed-Version Network 2-15

Reasons for Upgrading All Nodes to the Same Version of SQL/MX Release

2.x 2-16

Falling Back a Local SQL/MX Node 2-16

Falling Back a Remote SQL/MX Node Referenced by an Application on an

SQL/MX Release 2.0, 2.1, or 2.2 Node 2-16

3. Upgrading to a Newer Version of SQL/MX Release 2.x

Planning for Fallback 3-1

Steps for Upgrading SQL/MX Release 2.x 3-1

Implementing New Functionality 3-2