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
• NONSTOP_SQLMX_NSK.SYSTEM_SCHEMA.SQLJ
• NONSTOP_SQLMX_NSK.SYSTEM_SCHEMA.ANSINAMES
These user module files are installed in the directory /usr/tandem/sqlmx/USERMODULES:
The user module file that SQL/MX uses to read metadata
information for MXGNAMES.
NONSTOP_SQLMX_NSK.SCH. MXGNAMES
CAUTION: SQL/MX uses these files to read information from and perform updates to its internal
tables. Before you delete or move these user module files to another OSS directory, see SQL/MX
Management Manual and the SQL/MX Programming Manual for C and COBOL.
Messages files
Where InstalledDescriptionFile Name
/usr/tandem/sqlmx/binAn OSS file that contains the error message
text for all SQL errors. It is implicitly used by
mxcierrors.cat
all components that are capable of displaying
error text (for example, the Windows-hosted
preprocessors, MXCI, and MXCMP).
$SYSTEM.SYSTEMThe message file for MXCS.MXOMSG
$SYSTEM.ZTEMPLContains the compiled event messages for
SQL/MX.
ZMXSTMPL
Header files
These SQL/MX header files are exported for use by embedded SQL/MX applications:
Where InstalledDescriptionFile Name
/usr/tandem/sqlmx/includeContains platform specific defines used by
SQL/MX preprocessor (mxsqlc or
mxsqlco) generated code.
Platform.h
/usr/tandem/sqlmx/includeContains all exported CLI function
declarations.
sqlcli.h
/usr/tandem/sqlmx/includeSQL/MX Agent library used by Backup and
Restore2.
tdm.br.tlo
Interface description files
Where InstalledDescriptionFile Name
/usr/tandem/sqlmx/libInterface description file used by the SQL/MX
preprocessor (mxsqlco) for NMCOBOL.
sqlcli.o
/usr/tandem/sqlmx/libInterface description file used by the SQL/MX
preprocessor (mxsqlco) for ECOBOL.
esqlcli.o
Verifying executable file versions
1. Use the VPROC command to display the version of specified executables installed on your
system.
2. Verify that the displayed version information is correct for the specified executable.
To display the version information about executable files in the OSS environment, enter:
vproc executable-file-name
To display version information about executable files in the Guardian environment, enter:
vproc executable-file-name
Verifying the SQL/MX installation 25