MX Release 3.2 (H06.25+, J06.14+)

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 Installation and Management Guide and

the NSM/web online help. In addition, you can manage MXCS using the HP NonStop Remote

SQL/MX Conversational Interface (RMXCI). For more information on RMXCI, see HP NonStop

SQL/MX Remote Conversational Interface Guide.

Topic

“Architecture” (page 12)

“Data Sources” (page 13)

“Connections” (page 14)

“Security” (page 15)

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

“Traces” (page 17)

“Resource Statistics” (page 17)

“MXCS Features” (page 18)

“Limitation of MXCS” (page 18)

“Unsupported NonStop ODBC Server Features” (page 18)

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

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.

12 Overview of MXCS