SQL/MX 3.2.1 Management Manual (H06.26+, J06.15+)

The SQL/MX Environment
The SQL/MX query compiler and executor operate on SQL/MX database objects and SQL/MP
database objects. From the SQL/MX conversational interface, MXCI, you can perform DDL and
DML operations and most SQL/MX commands on SQL/MX objects. From MXCI, you can also
perform DML operations—but not DDL operations—on 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 more information, 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 more 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 HP 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, see the OSS 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, 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, see SQL/MX Connectivity Service Manual and the SQL/MX Connectivity
Service Administrative Command Reference.
NonStop Server for Java
To create and execute SPJs in NonStop SQL/MX, you must install the HP NonStop Server for Java
on a NonStop system. Use the NonStop Server for Java to compile and execute Java applications.
For details about this product, see the NonStop Server for Java Programmer’s Reference. For
installation instructions, see the README file on the product CD. For version requirements, see the
SQL/MX Installation and Upgrade Guide.
JDBC/MX Driver
To create and execute SPJs in NonStop SQL/MX, you must install the JDBC/MX driver on a NonStop
system. The JDBC/MX driver enables a Java application to use NonStop SQL/MX to access an
SQL/MX or SQL/MP database. For details about this product, see the JDBC Driver for SQL/MX
Programmer’s Reference. For installation instructions, see the README file on the product CD. For
version requirements, see SQL/MX Installation and Upgrade Guide.
26 Introduction to SQL/MX Database Management