Plan versions

The query execution plan of a SQL statement is assigned a plan version depending on the SQL/MX release that is installed on the node where the plan is compiled.

SQL/MX successfully compiles and executes a query execution plan if the plan version is higher than or equal to the earliest supported plan version and lower than or equal to the MXV of the node where the plan is being executed. Otherwise, it returns a versioning error.