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

HP NonStop SQL/MX Database and Application Migration Guide—540435-005
2-1
2
Version Management and
Interoperability
This section covers these topics:
•
Purpose of Versioning on page 2-1
•
NonStop SQL/MX Releases on page 2-2
•
Interoperability of NonStop SQL/MX Releases on page 2-8
•
Versions of SQL/MX Software Components on page 2-9
•
Managing SQL/MX Database Object Versions on page 2-13
•
Managing SQL/MX Query Plan Versions on page 2-14
•
Managing a Mixed-Version Network on page 2-15
Purpose of Versioning
Software versioning is a set of mechanisms in NonStop SQL/MX that enable SQL/MX
software to interoperate between different releases. It allows nodes in an Expand
network to run different releases of the SQL/MX software. It ensures that nodes with
compatible software versions can interoperate and that nodes with incompatible
software versions do not interoperate and fail predictably. Software versioning provides
a range within which you can migrate from earlier to later software releases and even
to fall back from later to earlier releases.
Each node supports only one SQL/MX software version at a time. However, different
software versions can occur across time and space. Over time, you might upgrade the
software release on a given node. Different software releases might exist on separate
nodes in the same Expand network. Versioning makes it possible for different but
compatible releases to successfully interoperate. Different software versions can
access compatible database objects and execute compatible plans and modules.
Finally, versioning protects against the consequences of attempted operations between
incompatible versions. If different versions are incompatible, they cannot interoperate.
For more information, see Versions of SQL/MX Software Components
on page 2-9.