SQL/MX system software version (MXV)

The MXV provides a primary version identifier for the 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.

SQL/MX uses the earliest supported MXV to determine if a remote node is running a compatible earlier release.

SQL/MX uses the earliest supported plan version to determine if a query execution plan or module from an earlier release is compatible with the current version. For more information, see SQL/MX query plan and module versions.

SQL/MX can also obtain the Object Schema Versions (OSVs) of database objects on which the system software operates. SQL/MX uses the OSVs to perform version checking. For example, when an object is opened, the 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.