SQL/MX Connectivity Service Manual for SQL/MX Release 3.2 (H06.25+, J06.14+)

Contents
About this document......................................................................................7
Supported Release Version Updates (RVUs)..................................................................................7
Audience.................................................................................................................................7
New and Changed Information in This Edition..............................................................................7
Notation Conventions................................................................................................................7
Related documentation..............................................................................................................9
NonStop SQL/MX customer library........................................................................................9
Publishing History...................................................................................................................11
HP encourages your comments.................................................................................................11
1 Overview of MXCS...................................................................................12
Architecture...........................................................................................................................12
Components......................................................................................................................12
Data Sources.........................................................................................................................13
Server Data Sources...........................................................................................................13
Default Data Source......................................................................................................13
Client Data Sources............................................................................................................13
Connections...........................................................................................................................14
Connecting a Client to a Data Source...................................................................................14
Connection Mapping.........................................................................................................15
Security.................................................................................................................................15
Access authorization..........................................................................................................15
User Authentication............................................................................................................15
Passwords.........................................................................................................................16
Password Expiration.......................................................................................................16
Operation Access Controls..................................................................................................16
Controlling who can manage the MXCS service................................................................16
Errors, Events, and Warnings...................................................................................................17
Traces...................................................................................................................................17
Resource Statistics...................................................................................................................17
MXCS Features.......................................................................................................................18
Limitation of MXCS.................................................................................................................18
Unsupported NonStop ODBC Server Features............................................................................18
Migrating From a NonStop ODBC Server Environment................................................................18
2 Installing, Starting, and Uninstalling MXCS..................................................19
Components of the MX connectivity service................................................................................19
Installation Requirements.....................................................................................................19
Step 1: Install the MXCS Server Components..........................................................................20
Step 2: Configure for Statistics Collection and Server Trace (optional).......................................20
Step 3: Start the MXCS Service............................................................................................20
Configuring MXCS as a Persistent Process.............................................................................20
Starting an MXCS Service manually..........................................................................................21
List of Installed Files.................................................................................................................23
Server Files.......................................................................................................................23
Migrating from SQL/MX Release 2.3.4 to SQL/MX Release 3.2...................................................23
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
Contents 3