SQL/MX Connectivity Service Manual (SQL/MX 3.x)

Contents
HP NonStop SQL/MX Connectivity Service Manual—640327-001
ii
2. Installing, Starting, and Uninstalling MXCS
2. Installing, Starting, and Uninstalling MXCS
Components of the MX connectivity service 2-1
Installation Requirements 2-2
Step 1: Install the MXCS Server Components 2-3
Step 2: Add Logical Table Names to SQL/MX 2-3
Step 3: Configure for Statistics Collection and Server Trace (optional) 2-3
Step 4: Start the MXCS Service 2-3
Configuring MXCS as a Persistent Process 2-3
Starting the MXCS Service 2-4
List of Installed Files 2-7
Server Files 2-7
Uninstalling MXCS from the Server 2-7
3. Starting, Configuring, and Managing MXCS
Managing the MXCS Service 3-2
Logging on 3-2
Displaying the MXCS Service Status 3-2
Enabling the MXCS Service 3-2
Disabling the MXCS Service 3-2
Displaying Server Status 3-3
Stopping Servers 3-3
Managing Multiple MXCS Services 3-3
Managing MXCS Server Data Sources 3-3
Displaying Data Source Status 3-4
Creating and Configuring Server Data Sources 3-4
Configuring MXCS XA Data Source 3-4
Reconfiguring Server Data Sources 3-6
Starting MXCS Data Sources 3-7
Stopping MXCS Data Sources 3-7
Deleting MXCS Data Sources 3-8
Resource Management 3-8
Adding or Removing a Resource Management Policy 3-8
Resource Statistics 3-9
Collecting Server Statistics 3-17
Tracing Server Activity 3-24
Module File Caching (MFC) 3-29
Design of MFC 3-29
Configuring MFC 3-29
Managing MFC 3-31