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

Figure 13 New database objects are created on SQL/MX Release 3.2.x
Start
Stop Applications
Stop TMF, Start, Stop TMF
Install desired fallback release,
including required fallback SPRs if any
Run mxtool fixrcb
Recompile Applications
Install 2.X, if required
Run downgrade command
Starting Version
v3200
cat1
Sch1
App1
Resulting Version
v3100
OR
v3000
OR
v1200
cat1
Sch1
App1
Final Version
v1200
cat1
Sch1
App1
Fallback considerations
You must consider the following points before falling back:
• Applications that are compiled using the SQL/MX Release 3.2.x compiler must be
preprocessed, recompiled, and then linked with an earlier release of the SQL/MX compiler
after the fallback. You must recompile the query plans.
NOTE: Recompiling programs might result in different execution plans, causing a change
in performance.
• Run the mxtool fixrcb command only when falling back from SQL/MX Release 3.2.1 to
2.3.4.
50 Falling back from SQL/MX Release 3.2.x