Creating the Server Configuration File (MCPSQL/SERVER/CONFIG)

During installation of the Query Processor server on the ClearPath MCP host, you use CANDE to create the Query Processor server configuration file called MCPSQL/SERVER/CONFIG under the same usercode and on the same pack as the *SYSTEM/MCPSQL/SERVER code file.

The server configuration file specifies TCP/IP attributes, SSL/TLS attributes, the key container file name, and the distributed systems services (DSS) provider name. The file is optional, and if it is not installed or is not found, all attributes take on their default values as defined in the following text.

The syntax for defining these attributes and the Query Processor name follows:  

── TCPIP ─┬───────────────┬─┬─────────────────────────────┬─┬──────────────────────────────┬─►
          └─<port number>─┘ └─ : ─<timeout specification>─┘ └─ + ─<additional idle worker>─┘
►─┬──────────────────────────────────────────────────────────────────┬───────►
  └──,─ SSLTLS ─┬───────────────────┬─┬──────────────────────────────┤
                └─<SSL port number>─┘ └─ + ─<additional idle worker>─┘
►─┬───────────────────────────────────────────────────────┬──────────────────►
  └─ , ── SSLKEYCONTAINER ──<security key container name>─┘
►─┬─────────────────────────────────────┬────────────────────────────────────►
  └─ , ── DSSPROVIDER ──<provider name>─┘
►─┬───────────────────────────────┬──────────────────────────────────────────┤
  └─ , ── MAXBUFFSIZE ──<integer>─┘

<timeout specification>

──<BLOCKEDTIMEOUT value>─┬──────────────────────────────────┬──────────┤
                         └─ : ──<DIALOGCHECKINTERVAL value>─┘

The following table explains the elements of the syntax diagrams. 

Element

Definition

<port number>

Identifies the port number of the Query Processor server. The default port number is 2012. You must also define the port number in the DSS MCPSQL_TCPIP endpoint and in either the connection attributes file or the connection defaults file.

<SSL port number>

Identifies the SSL port number of the Query Processor server. You must also define the port number in the DSS MCPSQL_SSLEP endpoint.

<additional idle worker>

Specifies the number of additional designated idle workers. Each attribute defaults to three idle workers. This value must be an integer.

The default <additional idle worker> value is 0.

<security key container name>

Specifies the key container to use during SSL and SSH negotiation. When you create a key using Security Center, you must also specify an application and service name. The application name and service name are concatenated to form the key container name.

Refer to the section, “Creating and Using RSA Keys,” under the section, “MCP Cryptographic Services Manager,” in the Security Center Help for more information on the format of the this attribute and key generation.

<BLOCKEDTIMEOUT value>

Specifies the length of time, in minutes, that the connection between the workstation and the server stays open after the workstation has stopped responding to inactivity handshaking procedures. This value must be an integer.

The default BLOCKEDTIMEOUT value is 10 minutes.

<DIALOGCHECKINTERVAL value>

Specifies the length of time, in minutes, that the server waits without a response from an attached system before it automatically invokes inactivity handshaking procedures. This value must be an integer.

The default DIALOGCHECKINTERVAL value is 5. A value of 0 (zero) prevents inactivity handshaking procedures from being invoked.

<provider name>

Specifies the name of the DSS provider that provides the Query Processor DSS. The default DSS provider name is MCPSQLPROV.

<integer>

Identifies the buffer size in bytes. The default buffer size is 15000. The allowed range is 300 to 32768.
Prev  Up  Next
Changing the Name and Location of the Query Processor Configuration File  Home  Setting the Query Processor Server Timeout Interval