MX Release 3.2.1 (H06.26+, J06.15+)

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 a 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 on

NSM/web, see the HP NonStop SQL/MX Release 3.2.1 Installation and Upgrade Guide and the

NSM/web online help.

Topic

“Architecture” (page 11)

“Data Sources” (page 12)

“Connections” (page 13)

“Security” (page 14)

“Errors, Events, and Warnings” (page 16)

“Traces” (page 16)

“Resource Statistics” (page 16)

“MXCS Features” (page 17)

“Limitation of MXCS” (page 17)

“Unsupported NonStop ODBC Server Features” (page 17)

“Migrating From a NonStop ODBC Server Environment” (page 17)

Architecture

Components

Server components are installed on NonStop systems. The following are the server and client

components:

• 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. It is a MXOSRVR process.

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

NSM/web is not a server component because it does not run in the host. It is a client

component.

Starting with SQL/MX Release 3.2, a new tool, called NonStop SQL/MX Database Manager

(MXDM), is available. The new tool enables you to view and manage MXCS objects. For

information on viewing and managing the MXCS objects, such as MXCS Services, data

sources, and MXCS user permissions, see the HP NonStop MXDM User Guide for SQL/MX

Release 3.2.1.

Architecture 11