The Query Processor Windows-based utilities use a TCP/IP connection to the ClearPath MCP server. This connection is managed as a distributed systems service (DSS).
You can manually configure the DSS connection using the following ClearPath MCP commands. However, if you use the Simple Installation (SI) program, the DSS connection is automatically configured, and it is not necessary to enter the following commands:
| Note: | You must be a system user to run the following commands. |
NA REG ADD PROVIDER MCPSQLPROV DSS = MCPSQL, SUPPORTLIBRARY = MCPSQLSERVER, TASK TYPE = NONMONITOREDSUPPORTLIBRARY, INTERFACE = MESSAGE; NA REG ADD DSS MCPSQL ENDPOINT = MCPSQL_TCPIP, CLASS = OTHER, INITIALIZE = TRUE, RECOVER = FALSE; NA REG ADD EP MCPSQL_TCPIP FILENAME = MCPSQL_TCPIP, MYNAME = "2012", PUBLIC = TRUE;
You can also copy the preceding commands to a ClearPath MCP sequential data file and load them using the following command:
NA LOAD <file title>
Configuring Secure Connections
You can configure a secured (also known as encrypted) connection between Windows-based Query Processor utilities and ClearPath MCP servers using SSL/TLS. To use secure connections, do the following:
-
Enter the SECOPT command in MARC to determine the current values of the SECURECOMM MCPSQL option:
SECOPT
Alternatively, you can use the following command to determine the current values of the SECURECOMM MCPSQL option:
NA MCPSQL STATUS
-
Enter the following command, as necessary, to configure the SECURECOMM settings:
SECOPT SECURECOMM MCPSQL <value for MCPSQL>
Alternatively, to specify the value of the SECURECOMM option for NXEDIT, MCPSQL, MCPSERVER, and TELNET, use the following command:
SECOPT SECURECOMM <value>
where <value> is one of the following options:
-
ALLOWED
Both secure and non-secure connections are permitted.
-
DISABLE
Only non-secure connections are permitted.
-
REQUIRED
Only secure connections are permitted.
-
For more information about MCP security options, refer to the MCP Security Overview and Implementation Guide.
