Progress
DataServer
for ORACLE Guide


Setting Up a Schema Holder As an NT Service

The schema holder can reside on the NT host or on the client machine. A schema holder on a client machine (a local schema holder) performs better. However, a schema holder on the NT host (a remote schema holder) might be easier to maintain in a multi-user environment. Setting up the schema holder so that it can run as a ProService (that is, a native NT service) means that the schema holder can run without users connected to it. Its availability is not dependent on any one user connection.

To set up a remote schema holder on an NT host and make it accessible to multiple users, follow these steps:

  1. Access the Data Administration tool by double-clicking its icon in the Progress program group.
  2. Create an entry for the schema holder using ProControl. Creating an entry in ProControl for a Progress database allows it to run as a ProService (a native NT service).
  3. Access ProControl by double-clicking its icon in the NT Control Panel.
  4. Choose Detail. Tabbed folders appear.
  5. Choose the Databases tab and choose Insert. The General, DB-Writers, and Environment tabbed folders appear.
  6. Enter the appropriate information in the following fields in the General folder:
    • Identifiers — Provide a unique name to identify the service. The name must be unique to the host. The identifier can be up to 30 characters long. It does not have to be the same name as the schema holder.
    • Executable Name — By default, the _mprosrv.exe executable displays. If you want to use a customized Progress server executable that you built using the PROBUILD utility, specify it here.
    • Working Directory — Specify the directory that the service uses, for example, to create the before-image file.
    • Physical DB-Name — Specify the schema holder’s physical name.
    • Startup Parameter — Specify any optional parameters, such as -RO.
  7. Entering information in the DB-Writers and Environment folders is optional.

Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095