Query Processor Server Administration   

Table of Contents

Configuring Query Processor Server Resources
Preparing a Database to Be a Resource
Controlling the Query Processor Server
Starting and Stopping the Query Processor Server
Obtaining Help Information
Automating Query Processor Server Initialization
Initiating the TCP/IP Configuration
Obtaining Query Processor Server Status
Viewing Server Log Information in the MCP Environment
Identifying the Server Log
Understanding Server Log Contents
Viewing Trace Information on the Server
Diagnostic Trace
Identifying the Trace File
Enabling the Trace Facility
Closing Trace Files Automatically
Retrieving Dump Files
Identifying the Dump File
Displaying the Dump File
Obtaining Log and Trace Information using MCPSQL Diagnostic Software
Modifying the MCPSQL/CONFIG File
Creating an Initialization File
Obtaining SQL Statements Querying the MCPSQL Database

The Query Processor server provides a socket-based API to enable non-MCP based applications to access the Query Processor CLI. The Query Processor server uses the NA command protocol supported by Distributed System Services (DSS).

This section discusses the following Query Processor server administration topics:

  • Configuring Query Processor server resources

  • Preparing a database to be a resource

  • Controlling the Query Processor server

  • Automating Query Processor server initialization

  • Obtaining Query Processor server status

  • Viewing log information on the server

  • Viewing trace information on the server

  • Retrieving dump files

Prev     Next
Enabling Trace  Home  Configuring Query Processor Server Resources