Use the following system command to start or stop the Query Processor server in the MCP environment:

── NA MCPSQL ─┬─ + ────────────┬────────────────────────────────────────┤
              ├─ ─ ────────────┤
              └─ QUIT ─┬───────┤
                       └─ NOW ─┘

Starting the Query Processor Server

Use the NA MCPSQL + command to initiate the Query Processor server. The system displays the following message to indicate that the server is active:

Initiation of the DSS "MCPSQL" is being attempted.

In addition, when the Query Processor server is successfully initiated, a message such as the following appears in the system messages. You can view the system messages by using the SMSG (System Messages) command in Menu-Assisted Resource Control (MARC).

MPCSQL: INITIALIZED: VERSION: 52.150.0051

Stopping the Query Processor Server

Use the NA MCPSQL - command, the NA MCPSQL QUIT NOW command, or the NA MCPSQL QUIT command to terminate the Query Processor server.

The command that you use depends on the level of termination you want to occur for the Query Processor server. Using the NA MCPSQL - or NA MCPSQL QUIT NOW command causes an abrupt termination of the server regardless of whether there is any server activity. This termination stops all network connections to the Query Processor. However, MCP-based applications accessing the Query Processor continue to operate. The system displays the following message to indicate that the server is stopped:

Termination of the DSS "MCPSQL" is being attempted.

Using the NA MCPSQL QUIT command causes the Query Processor server to terminate only if no workers are active. If any worker is active, the system displays the following message to indicate that there continues to be server activity:

QUIT MCPSQL ignored; workers still active.

If no workers are active, the system displays the following message to indicate that the Query Processor server is stopped:

MCPSQL terminated

In either case, when the Query Processor server is successfully terminated, a message such as the following appears in the system messages. You can view the system messages by using the SMSG system command in MARC.

MCPSQL: TERMINATED: VERSION 52.150.0045 

If the confirmation messages do not appear, check the system messages for any related messages. Also check the system waiting entries or system scheduled entries to ensure that no Query Processor-related tasks are waiting or scheduled.