Use of the Query Processor Schema Administrator requires that you have the appropriate access to files in the MCP environment. As part of enabling SQL access to databases, the SQL database generation process (using the SQLVIEW command) must be able to read the applicable description file and control file. The generation process also requires the creation of an SQL catalog file under the same usercode as the control file or the data file.

The SQL description you generate resides in a description file that is named according to the following format:

DESCRIPTION/<database name>/MCPSQL-CATALOG

This description file is the SQL catalog and is stored under the usercode and family you define for the database control file when you generate the SQL mappings for Enterprise Database Server databases. This SQL catalog inherits the physical security of the control file.

Ensuring File Accessibility

The easiest way to ensure that the system can locate and read the database control file, and create the SQL catalog file without security problems is to perform all database processing under the usercode of the control file.

If you choose to run the SQLVIEW command from a different usercode, explicitly specify the location of both the control file and the database description file when you generate your description file. In addition, ensure the usercode from which you run has the appropriate privileges to read the Enterprise Database Server description file and create the SQL catalog file.