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

Version Management and Interoperability
HP NonStop SQL/MX Database and Application Migration Guide—540435-005
2-10
SQL/MX System Software Version (MXV)
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 an 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-12.
Table 2-5. Software Version Identifiers for SQL/MX Release 2.x
Version
Item SQL/MX Release Version Identifier
For more
Information,
see...
2.3.4 2.3.3 2.3.2 2.3.1 2.3 2.2 2.1 2.0
Current
MXV
2400 2200 2000 1800 1600 1600 1400 1200 SQL/MX
System
Software
Version
(MXV) on
page 2-10
Earliest
supported
MXV
1200 1200 1200 1200 1200 1200 1200 1200
Current
schema
version and
OSV
1200 1200 1200 1200 1200 1200 1200 1200 SQL/MX
Database
Object
Versions on
page 2-11
Earliest
supported
schema
version
1200 1200 1200 1200 1200 1200 1200 1200
Default
compiler
version
2400 2200 2000 1800 1600 1600 1400 1200 SQL/MX
Query Plan
and Module
Versions on
page 2-12
Current plan
version
2400 2200 2000 1800 1600 1600 1400 1200
Earliest
supported
plan version
1200 1200 1200 1200 1200 1200 1200 1200