Optional Installation Tasks

As part of the Query Processor product installation, you can optionally direct the MCP host to use a pack other than the pack on which the Query Processor is installed for

  • The logging and tracing capabilities of the Query Processor server

    By default, the system writes requested log and trace files to the pack on which the *SYSTEM/MCPSQL/SERVER code file resides.

  • The location of the *MCPSQL/SERVER/CONFIG file

    By default, the system looks for the server configuration file (*MCPSQL/SERVER/CONFIG) on the pack on which the *SYSTEM/MCPSQL/SERVER code file resides.

Perform the following steps to change the location of the log or trace files, or the *MCPSQL/SERVER/CONFIG file:

  1. Stop the Query Processor server by entering the following system command: 

    NA MCPSQL QUIT NOW

  2. Remove the function name specification for MCPSQLSERVER by entering the following system command: 

    SL - MCPSQLSERVER

  3. Execute the following commands:

    WFL MODIFY *SYSTEM/MCPSQL/SERVER ON <pack name>;

FILE LOG_FILE (FAMILYNAME = <pack name>);

FILE TRACE_FILE (FAMILYNAME = <pack name>);

FILE MCPSQL_SERVER_CONFIG (FAMILYNAME = <pack name>);

  4. Map the function name MCPSQLSERVER to the Query Processor server code file by entering the following SL (Support Library) system command: 

    SL MCPSQLSERVER = *SYSTEM/MCPSQL/SERVER ON <pack name>:
   LINKCLASS = 1, TRUSTED

    The pack name represents the name of the pack to which you copied the code file *SYSTEM/MCPSQL/SERVER.

    The :LINKCLASS = 1, TRUSTED clause of the preceding command is required.

  5. Type the following command to start the Query Processor server software: 

    NA MCPSQL +

  6. Type the following command to display the status of the Query Processor connection: 

    NA MCPSQL STATUS

    The status report includes the following information:

    • DSS name is MCPSQL.

    • DSS provider name is MCPSQLPROV.

    • TCP/IP options are as follows:

      • Using port is 2012.

      • BlockedTimeout value is 10 min.

      • DialogCheckInterval value is 5 min.

Prev  Up  Next
Configuring the TCP/IP Distributed Systems Services (DSS)  Home  Installing the Query Processor Utilities in the Windows Environment