SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Introduction to SQL/MX Database Management
HP NonStop SQL/MX Installation and Management Guide—523723-004
1-16
OSS Environment
SQL/MP tables. MXCI commands are SQL/MX extensions that typically affect the
attributes of an MXCI session. MXCI runs as an OSS process and must be started
within the OSS environment.
For information about MXCI commands, see the SQL/MX Reference Manual.
OSS Environment
Several SQL/MX processes and utilities run in the OSS environment. Consequently,
OSS must be installed and running on your system to run NonStop SQL/MX. For
information, see the SQL/MX Reference Manual.
OSS is an open computing interface to the HP NonStop system. The OSS environment
coexists with the Guardian environment and provides a fully independent alternative to
it. OSS interoperates with the NonStop operating system and makes use of many of its
unique features, such as fault tolerance and parallel processing. However, OSS is not
an operating system, and it does not replace portions of the operating system.
The OSS environment is case-sensitive. All commands issued in the OSS environment
must be typed in the proper case, as specified in the examples provided in this and
other SQL/MX manuals. For more information about OSS and how it interprets certain
special characters, see the Open System Services Shell and Utilities Reference
Manual.
Privileges Required to Execute SQL/MX Utilities
To perform a specific SQL/MX utility and SQL/MX operation, you must have the user
privileges that are required for that utility or operation. For example, a super ID is
required to execute certain utilities. For these utilities, the super ID can use a user
alias.
For more information about these privileges, see the SQL/MX Reference Manual.
MXCS
MXCS comprises all server components that support the HP NonStop ODBC/MX
driver, the JDBC/MX driver, DataDirect’s SequeLink product, and the SQL/MX API for
the NonStop environment. MXCS consists of the MXCS Association Server, the MXCS
Configuration Server, and the MXCS SQL Server.
For more information about MXCS, see the SQL/MX Connectivity Service Manual and
the SQL/MX Connectivity Service Administrative Command Reference.
NonStop Server for Java
To develop and execute Java programs that perform SQL operations and SPJs, you
must install the HP NonStop Server for Java, based on the Java 2 platform, Standard
Edition, SDK 1.4.1, on your NonStop system. This product is also known as the
NonStop Server for Java 4, which is the earliest supported product version for Release
2.1 and Release 2.0.