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
These manuals are part of the SQL/MP library of manuals and are essential references for
information about SQL/MP Data Definition Language (DDL) and SQL/MP installation and
management:
Related SQL/MP Manuals
Describes the SQL/MP language elements,
expressions, predicates, functions, and statements.
SQL/MP Reference Manual
Describes how to plan, install, create, and
manage an SQL/MP database. Describes
SQL/MP Installation and Management Guide
installation and management commands and
SQL/MP catalogs and files.
New and changed information
This manual (691118–003) includes the following changes:
• Added a note in “Migrating applications after system upgrade” (page 42).
• Added a new section, “Considerations for mixed-node network” (page 34).
The new manual (691118–001) includes the following changes:
The HP NonStop SQL/MX Release 3.1 Installation and Management Guide is consolidated with
HP NonStop SQL/MX Release 3.1 Migration Manual and is split into two manuals:
• HP NonStop SQL/MX Release 3.2 Installation and Upgrade Guide—Starting with SQL/MX
Release 3.2, information related installation and upgrade of SQL/MX is available in this single
manual.
• HP NonStop SQL/MX Release 3.2 Management Manual—The contents related to management
of an installed SQL/MX database is included in this manual.
• Added information for mxrpm tool.
• Added “Converting the CPU list format from SQL/MX Release 2.3.x to SQL/MX Release 3.2”
(page 39)
• Added “Converting the CPU list format from SQL/MX Release 3.2 to SQL/MX Release 2.3.x”
(page 53).
• Included new definitions in “Terminology” (page 30).
• Updated vproc information in “Verifying executable file versions” (page 25).
• Updated the illustrations to reflect the version changes.
What this manual does not cover
• Migration from SQL/MP to SQL/MX. For more information, see the SQL/MP to SQL/MX
Database and Application Migration Guide.
• Migration from other database vendors to SQL/MX. For assistance, contact your service
provider. For more information, see “Assistance with upgrade” (page 31).
• Migration of SQL/MX, SQL/MP, and Enscribe databases and applications from an HP NonStop
S-series system to an HP Integrity NonStop NS-series system. For more information, see the
NonStop NS-Series Database Migration Guide.
• Migration from Enscribe databases and applications to SQL/MX. An automated tool to convert
Enscribe databases and applications to SQL/MX does not exist. The Escort SQL product
converts Enscribe databases and applications to NonStop SQL/MP. For more information,
see the ESCORT SQL™ User’s Guide, which you can obtain from Carr Scott Software Inc. at
http://www.carrscott.com/evaluation_prog.shtml. If there is sufficient market demand, Carr
Scott Software Inc. might consider modifying Escort SQL to support direct Enscribe-to-SQL/MX
8