SQL/MX 3.2 Installation and Upgrade Guide (H06.25+, J06.14+)

Table 6 Software version identifiers for SQL/MX Release 3.2
For more information, see...SQL/MX release version identifier 3.2Version Item
“SQL/MX system software version
(MXV)” (page 64)
3200
3200
Current MXV
Earliest supported MXV
3200Current schema version and OSV
1200Earliest supported schema version
“SQL/MX query plan and module
versions” (page 65)
3200
3200
Current plan version
Earliest supported plan version
3200
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.
SQL/MX uses the earliest supported MXV to determine if a remote node is running a compatible
earlier release of SQL/MX.
SQL/MX uses the earliest supported plan version to determine if a SQL/MX query execution plan
or module from an earlier release of SQL/MX is compatible with the current version of SQL/MX.
For more information, see “SQL/MX query plan and module versions” (page 65).
SQL/MX can also obtain the Object Schema Versions (OSVs) of SQL/MX 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 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.
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).
Schema version and object schema version
A schema version is assigned to each user schema at creation time and is based on the version
of the SQL/MX software that creates the schema. The Object Schema Version (OSV) of a SQL/MX
database object is inherited from the schema where the object resides and determines if the object
can be accessed by a particular version of SQL/MX.
SQL/MX uses the earliest supported schema version of the node to determine if it can access a
SQL/MX database object in a schema that has a lower version. If the object’s OSV is higher than
or equal to the earliest supported schema version and lower than or equal to the MXV (which is
often the same as the current schema version) of the node, SQL/MX accesses the object. Otherwise,
SQL/MX returns a versioning error.
NOTE: The UPGRADE and DOWNGRADE commands change the schema version of the existing
schemas.
The following table lists SQL/MX Release version and the corresponding current schema version.
Schema versionSQL/MX Release version
3200SQL/MX Release 3.2
3100SQL/MX Release 3.1
64 Version management and interoperability