MX 2.x)

HP NonStop SQL/MX Connectivity Service Manual—524944-008

1-1

1 Overview of MXCS

HP NonStop SQL/MX Connectivity Services (MXCS) enables applications developed

for the Microsoft® Open Database Connectivity (ODBC) application programming

interface (API) and the Java Database Connectivity (JDBC) API to use SQL/MX to

access a NonStop SQL database on an HP NonStop server.

MXCS is managed by NSM/web, which is a web-based graphical user interface (GUI)

management tool for configuring and monitoring the server components and data

sources. For information about NSM/web see the SQL/MX Installation and

Management Guide and the NSM/web online help. In addition, MXCS can be managed

via the mxci command-line interface.

Architecture

Server Components

Server components are installed on NonStop systems.

•

Association server: Starts and manages the MXCS server processes (MXOCFG

and MXOSRVR processes) and associates a client application with a specific

MXCS SQL server.

•

Configuration server: Manages the MXCS configuration data.

•

MXCS SQL Server: Provides access to a NonStop SQL database.

•

NSM/web: Manages and configures MXCS service. Requires an installed web

server.

Topic Page

Architecture 1-1

Data Sources 1-2

Connections 1-3

Security 1-6

Errors, Events, and Warnings 1-8

Traces 1-8

Resource Statistics 1-8

Unsupported NonStop ODBC Server Features 1-9

Migrating From a NonStop ODBC Server

Environment

1-9