SQL/MX 3.2.1 Installation and Upgrade Guide (H06.26+, J06.15+)

5 Considerations for upgrading the system to SQL/MX

Release 3.2.x

If you are currently using SQL/MX, to obtain new functionalities, performance enhancements, and

bug fixes, you might want to upgrade to a newer version.

This section discusses the factors that you must consider before upgrading to SQL/MX Release

3.2.x, and includes the following topics:

• “System upgrade path” (page 33)

• “Compatibility of SQL/MX Release 3.2.x systems” (page 33)

• “Considerations for mixed-node network” (page 35)

• “Working with v3200, v3100, v3000, and v1200 objects in SQL/MX Release 3.2.x”

(page 35)

• “Conversions from numeric to char or varchar” (page 67)

• “New features in SQL/MX Release 3.2” (page 36)

• “Implementing the new functionality” (page 36)

NOTE: Although the diagrams in this manual refer to SQL/MX Release 3.2, they are applicable

for SQL/MX Release 3.2.1 as well.

System upgrade path

You can upgrade the system from SQL/MX Release 2.3.x or SQL/MX Release 3.0 or SQL/MX

Release 3.1 to SQL/MX Release 3.2.x, as shown in Figure 1 (page 33).

Figure 1 Upgrade path from SQL/MX Release 2.3.x or SQL/MX Release 3.0 or SQL/MX Release

3.1 to SQL/MX Release 3.2.x

SQL/MX

R2.3.x

R3.0

R3.1

SQL/MX

R3.2

Compatibility of SQL/MX Release 3.2.x systems

SQL/MX Release 3.2 can interoperate with other instances of SQL/MX Release 3.2.x in a network,

as shown in Figure 2 (page 34).

System upgrade path 33