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
4. The SUT installation automatically installs the EMS events file, ZMXSTMPL, to
$SYSTEM.ZTEMPL.
5. In addition, DSM/SCM automatically uses the COPYOSS macro to install these OSS files to
these OSS directories:
a. COPYOSS installs these files in the OSS directory /usr/tandem/sqlmx/bin:
• InstallSqlmx
• mxci
• mxcierrors.cat
• mxCompileUserModule
• mxexportddl
• mxsqlc
• mxsqlco
• setmxdb
• ansp.exe
• mxrpm
b. COPYOSS installs these system module files in the OSS directory,
/usr/tandem/sqlmx/SYSTEMMODULES:
• NONSTOP_SQLMX_NSK.SYSTEM_SCHEMA.CMNAMEMAPSQLM
• NONSTOP_SQLMX_NSK.SYSTEM_SCHEMA.CMSMDIOREADM
• NONSTOP_SQLMX_NSK.SYSTEM_SCHEMA.CMSMDIOWRITEM
• NONSTOP_SQLMX_NSK.MXCS_SCHEMA.CATANSIMX
• NONSTOP_SQLMX_NSK.MXCS_SCHEMA.CATANSIMXGTI
• NONSTOP_SQLMX_NSK.MXCS_SCHEMA.CATANSIMXJAVA
• NONSTOP_SQLMX_NSK.SYSTEM_SCHEMA.READDEF
• NONSTOP_SQLMX_NSK.SYSTEM_SCHEMA.RFORK
• NONSTOP_SQLMX_NSK.SYSTEM_SCHEMA.SQLHIST
• NONSTOP_SQLMX_NSK.SYSTEM_SCHEMA.SQLUTILS
• NONSTOP_SQLMX_NSK.SYSTEM_SCHEMA.SQLJ
• NONSTOP_SQLMX_NSK.SYSTEM_SCHEMA.ANSINAMES
c. COPYOSS installs these user module files in the OSS directory,
/usr/tandem/sqlmx/USERMODULES:
• NONSTOP_SQLMX_NSK.SCH.MXGNAMES
d. COPYOSS installs these files in the OSS directory /usr/tandem/sqlmx/include:
• Platform.h
• sqlcli.h
• tdm_br.tlo
e. COPYOSS installs these files in the OSS directory, /usr/tandem/sqlmx/lib:
• sqlcli.o
• esqlcli.o
f. COPYOSS installs these SPJ product files in the /usr/tandem/sqlmx/udr directory:
• mxlangman.jar
20 Installing SQL/MX