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
Where InstalledDescriptionFile Name
$SYSTEM.SYSTEMAn OSS command-line utility, which is a licensed Guardian
code 800 file, replicates the DDL definition and statistics
of SQL/MX objects.
MXIMPDDL
$SYSTEM.ZMXTOOLSThe Guardian code 800 file for the MXGNAMES utility.MXGNAMES
/usr/tandem/sqlmx/binThe symbolic OSS link to the IMPORT utility that resides
in Guardian file space.
import
/usr/tandem/sqlmx/binThe OSS file for the SQL/MX conversational interface
(MXCI). To run mxci, you must be in the OSS environment.
mxci
/usr/tandem/sqlmx/binThe command-line tool used to produce compiled module
definitions for embedded applications. For more
mxCompile
nl
UserModule
information, see the SQL/MX Programming Manual for
C and COBOL.
/usr/tandem/sqlmx/binThe OSS file for the mxexportDDL utility. See SQL/MX
Management Manual.
mxexportddl
/usr/tandem/sqlmx/binThe OSS-based C preprocessor to preprocess embedded
SQL statements in C/C++ programs. The preprocessor
mxsqlc
replaces SQL statements in C/C++ programs with C
function calls to the call-level interface (CLI). For details on
mxsqlc, see the SQL/MX Programming Manual for C
and COBOL.
/usr/tandem/sqlmx/binThe OSS-based COBOL preprocessor to preprocess
embedded SQL statements in COBOL programs. For
mxsqlco
details on mxsqlco, see the SQL/MX Programming
Manual for C and COBOL.
/usr/tandem/sqlmx/binA link to $system.system.mxtool utility.mxtool
SPJ product files
These product files are necessary for developing and executing stored procedures in Java (SPJs)
in SQL/MX:
Where InstalledDescriptionFile Name
/usr/tandem/sqlmx/udrA JAR file that contains Java bytecode that
implements part of the SQL/MX language
mxlangman.jar
manager, an application program interface
(API) that the SQL/MX UDR server calls to
load, invoke, and unload SPJs.
For more information on SPJs, see the SQL/MX
Guide to Stored Procedures in Java.
/usr/tandem/sqlmx/udrA policy file that ensures the security and
proper operation of SPJs in SQL/MX.
mxlangman.policy
For more information on the policy file, see
the SQL/MX Guide to Stored Procedures in
Java.
Verifying the SQL/MX installation 23