SQL/MX Connectivity Service Manual for SQL/MX Release 3.2 (H06.25+, J06.14+)
2 Installing, Starting, and Uninstalling MXCS
The chapter discusses the following topics:
“Components of the MX connectivity service” (page 19)
“Starting an MXCS Service manually” (page 21)
“List of Installed Files” (page 23)
“Migrating from SQL/MX Release 2.3.4 to SQL/MX Release 3.2” (page 23)
“Creating the default catalog and schema for MXCS” (page 25)
“Uninstalling MXCS from the Server” (page 25)
Components of the MX connectivity service
To fully install all components of connectivity service, you must install the following:
• MXCS server components on a NonStop system
NOTE: For systems running on J06.05 and later J-series RVUs or H06.16 and later Hseries
RVUs, the MXCS server minor version is 3.0 and the MXCS server major version is 3. MXCS
will support older versions of connectivity clients.
• To run NSM/web:
A workstation with Internet Explorer 6.0 or later and Java Runtime Environment 1.5 or
later.
◦
◦ NSM/web server components and an installed web server on the NonStop system.
• ODBC/MX client interface or other connectivity API, such as JDBC, on any Windows machine.
• MXCS Configuration and Metadata Tables
The InstallSqlmx script creates the following MXCS configuration tables in the system catalog
under MXCS_SCHEMA:
DATASOURCESNAME2ID
RESOURCEPOLICIESASSOC2DS
ENVIRONMENTVALUES
For more information about these tables, see theHP NonStop SQL/MX Release 3.2 Reference
Manual.
Installation Requirements
Before MXCS is installed and configured, you must verify that the following are valid and present
in your environment, in addition to the installation requirements specified for SQL/MX:
DescriptionRequirement
The server components must be installed on a NonStop
system running using an operating system version J06.14
Operating system
and subsequent J-series RVUs or H06.25 or subsequent
H-series RVUs.
Open System Services (OSS) must be installed and
configured. This is necessary because the MXCS SQL
OSS
servers and the SQL/MX compiler and executors run in an
OSS environment.
Components of the MX connectivity service 19










