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
Run-Time libraries
Where InstalledDescriptionFile Name
$SYSTEM.ZDLLnnnPrivileged layer of the CLI and the SQL/MX file
system code is a licensed Guardian code 800 file.
ZCLIPDLL
$SYSTEM.ZDLLnnnA library containing CLI calls is a Guardian code
800 file. CLI is an interface between a host
ZCLIDLL
language and an SQL implementation that allows
host language programs to execute SQL statements
and to perform related operations, such as the
retrieval of diagnostics information.
$SYSTEM.YDLLnnn64–bit version of ZCLIDLL, which is a Guardian
code 800 file, must be used for 64–bit embedded
programs.
YCLIDLL
In the preceding table, nnn represents three digits assigned during node generation (SYSGEN
operation).
InstallSqlmx script file
Where InstalledDescriptionFile Name
/usr/tandem/sqlmx/binThe OSS script file that initializes SQL/MX.InstallSqlmx
Anchor file
Where InstalledDescriptionFile Name
$SYSTEM.ZSQLMXThe anchor file created by the
InstallSqlmx script that specifies the
location of the system metadata tables.
MXANCHOR
System module files
These internal module files are installed in the directory
/usr/tandem/sqlmx/SYSTEMMODULES:
CAUTION: Do not delete these module files or move them to a different location. SQL/MX uses
these files to read information from and perform updates to its internal tables.
The user module file that contains the queries that support
ODBC catalog APIs.
NONSTOP_SQLMX_NSK.MXCS_SCHEMA.CATANSIMX
The user module file that contains the queries that support
the type information for both ODBC and JDBC.
NONSTOP_SQLMX_NSK.MXCS_SCHEMA.CATANSIMXGTI
The user module file that contains the queries that support
JDBC catalog APIs.
NONSTOP_SQLMX_NSK.MXCS_SCHEMA.CATANSIMXJAVA
The following system module files are used by the SQL/MX software for metadata access:
• NONSTOP_SQLMX_NSK.SYSTEM_SCHEMA.CMNAMEMAPSQLM
• NONSTOP_SQLMX_NSK.SYSTEM_SCHEMA.CMSMDIOREADM
• NONSTOP_SQLMX_NSK.SYSTEM_SCHEMA.CMSMDIOWRITEM
• NONSTOP_SQLMX_NSK.SYSTEM_SCHEMA.READDEF
• NONSTOP_SQLMX_NSK.SYSTEM_SCHEMA.RFORK
• NONSTOP_SQLMX_NSK.SYSTEM_SCHEMA.SQLHIST
• NONSTOP_SQLMX_NSK.SYSTEM_SCHEMA.SQLUTILS
24 Installing SQL/MX