During installation of the Query Processor on the ClearPath MCP host, you use CANDE to create the Query Processor configuration file called MCPSQL/CONFIG under the same usercode and on the same pack as the *SYSTEM/MCPSQL/CONFIG code file. The information in the configuration file is used by the system to determine the version of the Query Processor software to which a particular user has access.
Perform the following steps to create the configuration file:
-
Use the EXAMPLE/MCPSQL/CONFIG file as a template. This file is included with the Query Processor software.
-
Copy the file EXAMPLE/MCPSQL/CONFIG as MCPSQL/CONFIG under your usercode.
-
Update the following sections in the MCPSQL/CONFIG file to reflect your environment:
RELEASE RELEASE DIAGNOSTICS USER DEFAULT RESOURCE
Refer to Query Processor Configuration Control Facility for details on configuring these items to fit your environment.
-
Save the updated example file as *MCPSQL/CONFIG ON DISK.
Note: If you want to save the configuration file under another name and location, refer to Changing the Name and Location of the Query Processor Configuration File. -
From CANDE, issue the following statement to verify the accuracy of the syntax in the MCPSQL/CONFIG file:
RUN *SYSTEM/MCPSQL/CONFIG ON <pack name>
If the contents of the file are valid, a message similar to the following is displayed:
# RUNNING 8864 > The MCPSQL/CONFIG file just validated is: > *MCPSQL/CONFIG ON HL511D0 10/11/2005 16:03:05 > No errors. # ET=0.1 PT=0.0 IO=0.1
If errors are returned, refer to Query Processor Configuration Control Facility to determine how to correct the errors.
