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

Versions of SQL/MX Software Components

Each SQL/MX software component and persistent entity has a version identifier that

identifies its software release and that can be understood by other SQL/MX releases.

Versioned software components include:

•

SQL/MX system software version (MXV)

•

SQL/MX compiler version

Versioned persistent entities, which persist over time and across releases, include:

•

Schemas that contain SQL/MX database objects

•

SQL/MX database objects, such as tables, views, and indexes

•

Compiled modules

NonStop SQL/MX uses version identifiers to determine if a software component or

persistent entity is compatible with the SQL/MX release. Before using a software

component or operating on a persistent entity, NonStop SQL/MX checks the version

identifier of the software component or persistent entity. If the version identifier is

compatible with the SQL/MX release, NonStop SQL/MX successfully proceeds with the

operation. If the version identifier is incompatible with the SQL/MX release, NonStop

SQL/MX fails the operation and returns a versioning error indicating an incompatibility.

The use of version identifiers enables interoperability between compatible versions and

prevents interoperability between incompatible versions. For more information, see:

•

Version Identification of SQL/MX Software Components on page 2-9

•

SQL/MX System Software Version (MXV) on page 2-10

•

SQL/MX Database Object Versions on page 2-11

•

SQL/MX Query Plan and Module Versions on page 2-12

Version Identification of SQL/MX Software Components

All version identification in SQL/MX is numeric. General availability (GA) and controlled

availability (CA) software releases are assigned version numbers that are multiples of

20. General and controlled availability releases do not interoperate with Early Adopter

Program (EAP) releases or other releases whose version numbers are not multiples of

20. Table 2-5

lists the software version identifiers for SQL/MX Release 2.x.