SQL/MX 3.2 Installation and Upgrade Guide (H06.25+, J06.14+)
Table Of Contents
- HP NonStop SQL/MX Release 3.2 Installation and Upgrade Guide
- Contents
- About this manual
- 1 Preparing to install SQL/MX
- 2 Installing SQL/MX
- Summary of installation tasks
- Preinstallation tasks
- Using the InstallSqlmx script
- Installing SQL/MX
- Verifying the SQL/MX installation
- Post-Installation tasks
- 3 Installing a sample database
- 4 Overview of SQL/MX system upgrade
- 5 Considerations for upgrading the system to SQL/MX Release 3.2
- 6 Upgrading the system to SQL/MX Release 3.2
- 7 Falling back from SQL/MX Release 3.2
- A Removing security administrator grants
- B Identifying tables that contain an IDENTITY Column
- C Identifying tables where the ownership has changed
- D Version management and interoperability
- SQL/MX releases
- Interoperability of SQL/MX releases
- Versions of SQL/MX software components
- E Conversions
- Index

5 Considerations for upgrading the system to SQL/MX
Release 3.2
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, and addresses the following topics:
• “System upgrade path” (page 33)
• “Compatibility of SQL/MX Release 3.2 systems” (page 33)
• “Considerations for mixed-node network” (page 34)
• “Working with v3200, v3100, v3000, and v1200 objects in SQL/MX Release 3.2” (page 35)
• “Conversions from numeric to char or varchar” (page 67)
• “New features in SQL/MX Release 3.2” (page 35)
• “Implementing the new functionality” (page 36)
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, 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
SQL/MX
R2.3.x
OR
R3.0
OR
R3.1
SQL/MX
R3.2
Compatibility of SQL/MX Release 3.2 systems
SQL/MX Release 3.2 can interoperate only with other instances of SQL/MX Release 3.2 in a
network, as shown in Figure 2 (page 34).
System upgrade path 33










