SQL/MX Connectivity Service Manual for SQL/MX Release 3.1 (H06.23+, J06.12+)

Contents
HP NonStop SQL/MX Connectivity Service Manual for SQL/MX Release 3.1—663856-001
ii
3. Starting, Configuring, and Managing MXCS
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
Param Caching
3-17
Collecting Server Statistics 3-20
Tracing Server Activity
3-27
Module File Caching (MFC)
3-32
Design of MFC
3-32
Configuring MFC
3-32
Managing MFC 3-34
Benefits of MFC
3-35