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

Figure 2 Compatibility of SQL/MX releases in a network
R2.3.x
OR
R3.0
OR
R3.1
R3.2
R3.2 R3.2
If your network includes multiple versions of SQL/MX, such as SQL/MX Release 2.3.3 and SQL/MX
Release 2.3.4, you must upgrade all of them to SQL/MX Release 3.2 to ensure compatibility, as
shown in Figure 3 (page 34).
Figure 3 Compatibility of SQL/MX releases in a network after upgrade
R2.3.x R2.3.y
R3.2 R3.2
Before
migration
After
migration
Considerations for mixed-node network
Consider the following before you attempt a release upgrade if one or more systems in your network
need to remain at a lower version of SQL/MX and cannot be immediately upgraded to SQL/MX
Release 3.2.x:
• Local catalog registrations — Check if the catalogs on the systems that must be upgraded are
registered on the systems that must remain at lower release. Execute the following query on
the system that must be upgraded to obtain the list of registered catalogs and the systems
where they are registered:
select cs.cat_name, cr.node_name
from nonstop_sqlmx_<system>.system_schema.catsys cs,
34 Considerations for upgrading the system to SQL/MX Release 3.2