SQL/MX Connectivity Service Manual for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

Contents
About this document......................................................................................6
Supported Release Version Updates (RVUs)..................................................................................6
Audience.................................................................................................................................6
New and Changed Information in This Edition..............................................................................6
Notation Conventions................................................................................................................6
Related Documentation..............................................................................................................8
NonStop SQL/MX customer library........................................................................................8
Publishing History...................................................................................................................10
HP encourages your comments.................................................................................................10
1 Overview of MXCS...................................................................................11
Architecture...........................................................................................................................11
Components......................................................................................................................11
Data Sources.........................................................................................................................12
Server Data Sources...........................................................................................................12
Client Data Sources............................................................................................................13
Connections...........................................................................................................................13
Connecting a Client to a Data Source...................................................................................13
Connection Mapping.........................................................................................................14
Security.................................................................................................................................14
Access authorization..........................................................................................................14
User Authentication............................................................................................................15
Passwords.........................................................................................................................15
Operation Access Controls..................................................................................................15
Errors, Events, and Warnings...................................................................................................16
Traces...................................................................................................................................16
Resource Statistics...................................................................................................................16
MXCS Features.......................................................................................................................17
Limitation of MXCS.................................................................................................................17
Unsupported NonStop ODBC Server Features............................................................................17
Migrating From a NonStop ODBC Server Environment................................................................17
2 Installing, Starting, and Uninstalling MXCS..................................................18
Components of the MX connectivity service................................................................................18
Installation Requirements.....................................................................................................18
Step 1: Install the MXCS Server Components..........................................................................19
Step 2: Configure for Statistics Collection and Server Trace (optional).......................................19
Step 3: Start the MXCS Service............................................................................................19
Configuring MXCS as a Persistent Process.............................................................................19
Starting an MXCS Service manually..........................................................................................20
List of Installed Files.................................................................................................................23
Server Files.......................................................................................................................23
Migrating from SQL/MX Release 2.3.4 to SQL/MX Release 3.2...................................................24
Creating the default catalog and schema for MXCS....................................................................25
Uninstalling MXCS from the Server............................................................................................25
3 Starting, Configuring, and Managing MXCS................................................26
Managing MXCS Services.......................................................................................................26
Logging on.......................................................................................................................26
Displaying the MXCS Service Status.....................................................................................26
Enabling the MXCS Service.................................................................................................27
Disabling the MXCS Service................................................................................................27
Displaying Server Status.....................................................................................................27
Contents 3