Preparing a Database to Be a Resource

The Query Processor allows applications to communicate with resources in an MCP environment by using common interface routines and SQL to read data from multiple data sources. Because these applications use SQL, the database in the MCP environment must be prepared to process SQL queries. In addition, database security and configuration concerns must be addressed.

The following table describes database preparation tasks to complete before using the Query Processor software. Refer to the related documents identified in the table for more information on performing each task.

Task

Related Documents

Ensure that your data sources are SQL capable. SQL-capable data sources are

  • Enterprise Database Server databases processed using the SQLVIEW command

  • SQL databases

Relational Design Center Help (also Using Relational Design Center of this guide)

Query Processor Programming Guide

Specify the following Enterprise Database Server software titles in the database schema to ensure that a database opens successfully:

  • DMSUPPORT library

  • Accessroutines

  • Recovery

Note: When the Query Processor server opens a database, the MCP environment worker task inherits the user's family default as specified in the system user data file.

Enterprise Database Server Getting Started and Installation Guide

If a guard file is used to provide security for the Enterprise Database Server database, provide the server task SYSTEM/MCPSQL/WORKER with appropriate access to the physical database.

MCP Security Overview and Implementation Guide
Prev  Up  Next
Configuring Query Processor Server Resources   Home  Controlling the Query Processor Server