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-8

SQL/MX System Software Version (MXV)

The MXV provides a primary version identifier for the SQL/MX software installed on a

node and provides a lower boundary, the earliest supported MXV, for all other versions

that can be accepted by the node. All version numbers that are equal to or higher than

the earliest supported MXV are compatible. All version numbers lower than the earliest

supported MXV are incompatible.

The SQL/MX system software obtains all the earliest supported versions that

correspond to the MXV. NonStop SQL/MX uses the earliest supported MXV to

determine if a remote node is running a compatible earlier release of NonStop

SQL/MX.

NonStop SQL/MX uses the earliest supported plan version to determine if a SQL/MX

query execution plan or user module from an earlier release of NonStop SQL/MX is

compatible with the current version of NonStop SQL/MX. For more information, see

SQL/MX Query Plan and Module Versions

on page 2-10.

NonStop SQL/MX can also obtain the object schema versions (OSVs) of SQL/MX

database objects on which the system software operates. NonStop SQL/MX uses the

OSVs to perform version checking. For example, when an object is opened, the

SQL/MX executor compares the OSV for that object with the earliest supported

schema version. If the object’s OSV is earlier than the earliest supported schema

version, a versioning error is generated. For more information, see SQL/MX Database

Object Versions on page 2-8.

SQL/MX Database Object Versions

Database object versioning is a set of mechanisms that allow SQL/MX software to

determine if the version of a SQL/MX database object is compatible with the MXV.

Database object versions include the schema version, Object Schema Version (OSV),

and object feature version (OFV).

Table 2-3. Software Version Identifiers for SQL/MX Release 3.0

Version Item

SQL/MX

Release Version

Identifier 3.0 For more Information, see...

Current MXV 3000 SQL/MX System Software

Version (MXV) on page 2-8

Earliest supported MXV 3000

Current schema version and OSV 3000 SQL/MX Database Object

Versions on page 2-8

Earliest supported schema

version

1200

Default compiler version 3000 SQL/MX Query Plan and

Module Versions on page 2-10

Current plan version 3000

Earliest supported plan version 3000