Configuring Query Processor Server Resources

What Is a Resource?

When a Query Processor user establishes a connection between an application and a data source in the MCP environment, the connection is not made to the data source directly. Between the workstation application and the physical data source is a resource. A resource is a logical identifier that maps a data source identifier to one or more physical databases.

When an application using the Query Processor software attaches to a resource, the system automatically routes instructions and data between the application and the physical data source or sources to which the resource is mapped. Whether a resource is mapped to one or several physical data sources is transparent to the application user.

Resource Configuration Process

You configure resources using the Query Processor configuration control facility, which reads statements from the Query Processor configuration file. These statements define the resources and their location. For more information on this file, see Query Processor Configuration Control Facility.

For each resource needed, specify the following information in the Query Processor configuration file:

  • Definition of the data sources that are to be accessed

  • Definition of a repository that can be used to locate the data sources (optional)

  • Repository attributes of the database

  • Mode in which the databases are to be accessed (that is, inquiry or update)

  • Coded character set to use when transferring character data between the MCP environment and the workstation (optional)

Modifying Resource Definitions During Processing

The following steps enable you to alter the contents of the Query Processor configuration file in the MCP environment while the system is running without affecting current users:

  • Edit the contents of the Query Processor configuration file and add, change, or delete any resources.

  • Run SYSTEM/MCPSQL/CONFIG to validate the contents of the file.

For more information about the Query Processor configuration file, refer to Query Processor Configuration Control Facility.

Notes:

  • Modifications made to a resource definition while the resource is in use do not take effect until you close, open, and reconnect to the data source.

  • Deleting a resource does not automatically terminate an Query Processor application using the deleted resource.

  • The Query Processor configuration control facility does not notify Query Processor servers or users when resources have been added, changed, or deleted.

Prev  Up  Next
Query Processor Server Administration     Home  Preparing a Database to Be a Resource