HP 3000 Manuals

Information Access Server: System Management

Access Server Components 

The major components of Access Server are illustrated in Figure 1-1 and
described below.


          Figure 1-1.  Access Server Components 

Host Data Server Process 

The Host Data Server Process (HDSP) on Access Server retrieves data from
host and remote HP 3000s when a PC user requests it through Access PC. It
also uploads tables to the HP 3000 at the user's request.

Data Dictionary 

The Information Access data dictionary consists of two IMAGE databases,
HDPDIC and HDPENV, both in the group PPCDICT.HPOFFICE.

   *   HDPDIC contains all the information about remote HP 3000 systems,
       data sources, table items, and access groups that Access Server
       needs to allow access to data viewed as relational tables.

   *   HDPENV contains all the information about saved tables,
       Administrator Utility screens, and Access Server users.

Administrator Utility 

The primary DBA and secondary DBAs use the Administrator Utility to
maintain the Information Access data dictionary.  This utility also
provides tools you can use to help manage Access Server operations.  The
Administrator Utility performs four major functions:

   1.  Configures the data sources.  The Configuration screens allow the
       DBA to add definitions of HP 3000 databases and files to the
       Information Access data dictionary, and to configure tables from
       IMAGE datasets and files.

       The tables can contain data from one or more IMAGE datasets or
       files, and can use up to 64 items per table.  Three types of
       tables are configured with the Administrator Utility.

          *   IMAGE tables contain information taken from a single
              dataset, displayed in a relational format.

          *   File tables contain information taken from a single file,
              displayed in a relational format.

          *   View tables can contain information from one or more
              datasets or files.  View tables give a relational view of
              data that is not necessarily stored together.

   2.  Synchronizes data definitions.  The synchronization portion of the
       Administrator Utility compares the table definitions in the data
       dictionary with the various sources of the definitions.  DBAs can
       check the synchronization of single tables, all tables, and sets
       of tables by HP 3000 system, database, and file.

   3.  Displays system status.  The System Status screens let the primary
       DBA monitor Access Server operations and status.  These screens
       allow the primary DBA to:
          *   List all active users.
          *   List tables saved by all users.
          *   List tables saved by individual users.
          *   Delete saved tables.

   4.  Produces reports.  The Report Main screen is used to produce
       reports on configuration and system status information.  The
       primary DBA can print all data available or select the areas on
       which to report.  The secondary DBA can print only certain
       reports.

Translator Utility 

In systems with Dictionary/3000, the primary and secondary DBAs can use
the Translator Utility to translate Dictionary/3000 definitions of IMAGE
databases and datasets into Information Access data dictionary format,
and add them to the data dictionary.

When the DBA initially configures Access Server data, the Translator
Utility is used to translate definitions from Dictionary/3000 (host and
remote) data dictionaries into the Information Access data dictionary on
the host.  After the initial configuration, the DBA can use this utility
to add new Dictionary/3000 data definitions to the Information Access
data dictionary.

Host Batch Facility 

The Host Batch Facility allows users to drive Access Server from a job
file or interactively on the HP 3000 rather than from the PC.

Everything the PC user can do from Access PC can also be done with the
Host Batch Facility, except for the following:

   *   Downloading data to the PC
   *   Uploading data from the PC
   *   Accessing databases on the PC
   *   Using the Report Writer

The Host Batch Facility provides virtually the same functions as the PC
command file as well as powerful alternate commands.

UDC File 

The UDC file ACUDC.PPCUTIL.HPOFFICE contains the following user-defined
commands:  (For more information, see the Information Access Server: 
Database Administration manual.)

   *   ADMIN runs the Administrator Utility.

   *   CHGDICPASS notifies Access Server that the password for the HDPDIC
       database has been changed.

   *   CHGENVPASS notifies Access Server that the password for the HDPENV
       database has been changed.

   *   CLEARAC does a disable followed by an enable.

   *   DISABLEAC makes Access Server unavailable to users.

   *   ENABLEAC makes Access Server available to users.

   *   GONOGO tests whether or not HDSP successfully opens and runs in
       the Host Batch Facility.

   *   HOSTVERIFY verifies that all Access Server software is present,
       that the versions match, and that the host side of the PC-to-host
       communication link is in place.

   *   JSPURGE is used to delete or examine status entries in the data
       dictionary related to batch processing.

   *   PARMHELP give help text for Administrator Utility parameters.

   *   SITECHARSET specifies the site language.

   *   TRANS runs the Translator Utility.

   *   TUTORIAL resets the definitions required in the data dictionary to
       enable DBAs to do their tutorial.


NOTE  When ACUDC.PPCUTIL.HPOFFICE is installed on your system, its
      security is set to "creator only" (CR); the creator is
      MGR.HPOFFICE. Because the UDC file may contain passwords, we
      recommend that it be activated for use only by MGR.HPOFFICE or by
      another protected user responsible for Access Server control.  If
      you do not choose to allow data access across account boundaries,
      the DBA will need to run the Administrator Utility from accounts
      other than HPOFFICE. In that case, be sure the utility has a
      lockword and that the lockword is not included in the RUN string of
      the UDC commands.


Diagnostics 

Host diagnostic tests available for Access Server are:

   *   A Verification Test, which checks for the presence of all files
       and program components required for Access Server and ensures that
       the version numbers are compatible.

   *   A Go/No Go Test, which exercises the minimum functions of Access
       Server to ensure that basic operation is possible.

For more information, see "Verifying the Installation" in Chapter 3,
"Installing Access Server."

MPE/iX 5.0 Documentation