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

6 Upgrading the system to SQL/MX Release 3.2
This section addresses the following topics:
• “Planning for release downgrade” (page 37)
• “Upgrading the system from SQL/MX Release 2.3.x to SQL/MX Release 3.2” (page 37)
• “Upgrading the system from SQL/MX Release 3.0 or Release 3.1 to SQL/MX Release 3.2”
(page 41)
• “Upgrading the metadata and using new features on existing and new databases” (page 44)
Planning for release downgrade
Before you install SQL/MX Release 3.2, plan for a release downgrade to an earlier version. To
fall back to versions earlier than SQL/MX Release 2.3.4, you must first fall back to SQL/MX Release
2.3.4 and then to the required SQL/MX Release 2.x version.
To fall back to a previous version of SQL/MX, see “Falling back from SQL/MX Release 3.2”
(page 46).
NOTE: If you face any problem when using a new feature, discontinue the use of the feature
instead of falling back to a previous version.
Upgrading the system from SQL/MX Release 2.3.x to SQL/MX Release
3.2
This section describes the sequence and the procedures to upgrade the system from SQL/MX
Release 2.3.x to SQL/MX Release 3.2.
• “System upgrade sequence” (page 37)
• “Preinstallation” (page 38)
• “Installing SQL/MX Release 3.2” (page 39)
• “Accessing the database” (page 39)
• “Upgrading the metadata after system upgrade” (page 40)
• “Migrating applications after system upgrade” (page 40)
System upgrade sequence
To upgrade from SQL/MX Release 2.3.x to SQL/MX Release 3.2, you must follow the sequence
shown in Figure 4 (page 38).
Planning for release downgrade 37










