MX Database and Application Migration Guide

Version Management and Interoperability

HP NonStop SQL/MP to NonStop SQL/MX Database and Application Migration Guide—666211-001

2-7

Interoperability of NonStop SQL/MX Releases

SQL/MX 3.0 does not interoperate with other versions of SQL/MX in an EXPAND

network.

Versions of SQL/MX Software Components

Each SQL/MX software component and persistent entity has a version identifier that

identifies its software release and that can be understood by other SQL/MX releases.

Versioned software components include the SQL/MX system software version (MXV).

Versioned persistent entities, which persist over time and across releases, include:



Schemas that contain SQL/MX database objects



SQL/MX database objects, such as tables, views, and indexes



Compiled modules

NonStop SQL/MX uses version identifiers to determine if a software component or

persistent entity is compatible with the SQL/MX release. Before using a software

component or operating on a persistent entity, NonStop SQL/MX checks the version

identifier of the software component or persistent entity. If the version identifier is

compatible with the SQL/MX release, NonStop SQL/MX successfully proceeds with the

operation. If the version identifier is incompatible with the SQL/MX release, NonStop

SQL/MX fails the operation and returns a versioning error indicating an incompatibility.

The use of version identifiers enables interoperability between compatible versions and

prevents interoperability between incompatible versions. For more information, see:



Version Identification of SQL/MX Software Components on page 2-7



SQL/MX System Software Version (MXV) on page 2-8



SQL/MX Database Object Versions on page 2-8



SQL/MX Query Plan and Module Versions on page 2-10

Version Identification of SQL/MX Software Components

All version identification in SQL/MX is numeric. General Availability (GA) and

Controlled Availability (CA) software releases are assigned version numbers that are

multiples of 20. General and controlled availability releases do not interoperate with

Early Adopter Program (EAP) releases or other releases whose version numbers are

not multiples of 20. Table 2-3

lists the software version identifiers for SQL/MX Release

3.0.