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

Contents
About this manual.........................................................................................6
Supported release version updates (RVUs)....................................................................................6
Audience.................................................................................................................................6
Related documentation..............................................................................................................6
New and changed information...................................................................................................8
What this manual does not cover................................................................................................8
Document organization.............................................................................................................9
Notation conventions................................................................................................................9
General syntax notation.............................................................................................................9
Publishing history....................................................................................................................11
HP encourages your comments.................................................................................................11
1 Preparing to install SQL/MX......................................................................12
Hardware requirements...........................................................................................................12
Software requirements.............................................................................................................12
Verifying correct versions of independent software products..........................................................13
Starting TMF..........................................................................................................................13
2 Installing SQL/MX....................................................................................14
Summary of installation tasks...................................................................................................14
Preinstallation tasks.................................................................................................................14
Using the InstallSqlmx script.....................................................................................................14
Phases of InstallSqlmx.........................................................................................................15
InstallSqlmx syntax.............................................................................................................16
InstallSqlmx command options.............................................................................................16
InstallSqlmx error messages.................................................................................................16
Installing SQL/MX..................................................................................................................17
Verifying the SQL/MX installation.............................................................................................18
Overview of automatic file installations.................................................................................18
Verify that files are licensed.................................................................................................21
Starting MXCI....................................................................................................................21
Summary of installed SQL/MX files......................................................................................22
Verifying executable file versions..........................................................................................25
Post-Installation tasks...............................................................................................................26
Reviewing and setting system defaults...................................................................................26
Installing visual query planner.............................................................................................26
Installing the SQL/MX online help........................................................................................27
Installing the Windows-hosted SQL/MX C and C++ preprocessor............................................27
Installing the Windows-hosted SQL/MX COBOL preprocessor.................................................27
3 Installing a sample database.....................................................................28
4 Overview of SQL/MX system upgrade.........................................................30
Terminology...........................................................................................................................30
Upgrading SQL/MX system.....................................................................................................30
Guidelines for conducting the system upgrade............................................................................31
Conducting the initial upgrade in a test environment...............................................................31
Running baseline tests and gathering data at each upgrade phase...........................................31
Assessing the success of the upgrade...................................................................................31
Assistance with upgrade..........................................................................................................31
Product support for NonStop servers.....................................................................................31
NonStop solutions development and implementation..............................................................31
Contents 3










