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

Table Of Contents

modules and query plans from SQL/MX Release 2.3.x or earlier versions. You must recompile all

the existing embedded modules so they are compatible with the enhanced SQL/MX Release 3.2

executor.

NOTE: Recompiling programs might result in different execution plans, causing a change in

performance.

Upgrading the system from SQL/MX Release 3.0 or Release 3.1 to

SQL/MX Release 3.2

This section describes the sequence and the procedures to upgrade the system from SQL/MX

Release 3.0 or Release 3.1 to SQL/MX Release 3.2.

• “System upgrade sequence” (page 41)

• “Preinstallation” (page 42)

• “Installing SQL/MX Release 3.2” (page 42)

• “Accessing the database” (page 42)

• “Upgrading the metadata after system upgrade” (page 42)

• “Migrating applications after system upgrade” (page 42)

System upgrade sequence

To upgrade from SQL/MX Release 3.0 or 3.1 to SQL/MX Release 3.2, you must follow the sequence

shown in Figure 5 (page 41).

NOTE: The steps to upgrade from SQL/MX Release 3.0 or 3.1 to SQL/MX Release 3.2 are

simpler than the corresponding steps to upgrade the system from SQL/MX Release 2.3.x.

Figure 5 Sequence to upgrade from SQL/MX Release 3.0 or SQL/MX Release 3.1 to SQL/MX

Release 3.2

Start

Stop Applications

Stop TMF

Install R3.2 and cold load

Start TMF

Starting Version

v3100

v3000

v1200

cat1

Sch1

App1