HP 3000 Manuals

Description of Software [ Information Access Server: Database Administration ] MPE/iX 5.0 Documentation


Information Access Server: Database Administration

Description of Software 

The major software components of Access Server are as follows:

   *   The HP 3000 software interface needed by Access PC to retrieve
       IMAGE data and file data from the host HP 3000 and from remote HP
       3000s, and to retrieve and upload mainframe data.

   *   A data dictionary, in which you define (1) what data will be
       available to users running Access PC, (2) who the users are and
       how they are grouped, and (3) what portion of the data each group
       of users is permitted to access.

   *   Two utilities, the Administrator Utility and the Translator
       Utility, which provide a quick, friendly screen interface for
       performing all operations involving the data dictionary.

   *   A Host Batch Facility that allows Access Server to be run from a
       job file, invoked from the PC or the host.

Several of these components, as well as the UDC (user-defined commands)
file provided with the product, are described in greater detail below.

Data Dictionary 

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

   *   HDPDIC contains all the information Access Server needs to allow
       access to data viewed as relational tables.

   *   HDPENV contains all the information having to do with Access
       Server users.

Administrator Utility 

The Administrator Utility is a menu-driven utility that gives you control
over the environment in which Access Server operates.  The areas of
control you have depend on whether you are the primary DBA or a secondary
DBA.

You can think of the Administrator Utility as being divided into five
parts, according to the kind of task you want to accomplish:

   *   The Configuration screens let you add, change, delete, or examine
       entries in the data dictionary.  If you are a primary DBA, you
       have access to all functions within the Configuration screens and
       can control any entry in the data dictionary.  If you are a
       secondary DBA, you are limited to controlling only those entries
       that you configured.

   *   The System Status screens let you investigate the more dynamic
       aspects of Access Server.  You use these screens to see who your
       currently active users are and what amount of disc space all your
       users are using to save tables on the host machine.  You can use
       these screens only if you are the primary DBA.

   *   The Report Main screen lets you generate reports on various parts
       of the Access Server configuration and on the current status of
       Access Server.  If you are the primary DBA, you can generate
       reports for the entire Access Server configuration.  If you are a
       secondary DBA, you can generate reports for the entries you have
       configured.

   *   The Synchronization screens let you verify that table definitions
       in the data dictionary are correct.  If you are a secondary DBA,
       you can only verify the definitions of tables in the data
       dictionary that you control.

   *   The Environment Configuration screens let you control password
       visibility both in reports and on the screens, configure maximum
       table size, configure the maximum number of active users, and
       configure a view table editor.

Translator Utility 

The Translator Utility is a menu-driven utility that lets you automate
the process of taking database information already defined in a
Dictionary/3000 data dictionary and adding the same information to your
Information Access data dictionary.

For each Dictionary/3000 data dictionary you specify, the Translator
Utility lets you choose which database entries you want translated.  It
then adds the definition of each database to the Information Access data
dictionary, followed by the definitions, as IMAGE tables, of all the
datasets defined in the Dictionary/3000 data dictionary for the specified
database.

Host Batch Facility 

The Host Batch Facility allows you to drive Access Server from a job file
rather than from the PC.

Everything the PC user can do with remote tables from Access PC can also
be done using 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 gives you virtually the same functionality as the
PC command file facility in Access PC, as well as providing powerful
alternate commands.  (For details, please see Chapter 13, Batch
Processing with Command Files.)

UDC File 

The UDC file ACUDC.PPCUTIL.HPOFFICE contains the following user-defined
commands:

   *   ADMIN runs the Administrator Utility.

   *   TRANS runs the Translator Utility.

   *   ENABLEAC makes Access Server available to users.  In so doing, it
       clears out the active users list in the data dictionary.  It also
       checks to see that all saved table definitions have a
       corresponding file containing the saved table data.

   *   DISABLEAC makes Access Server unavailable to PC users.  It also
       checks to see that all saved table definitions have a
       corresponding file containing the saved table data.

   *   CLEARAC does a disable followed by an enable.  This command is
       used to clear out the active users list in the data dictionary in
       the event of a power failure, then make Access Server available
       once more.

   *   HOSTVERIFY is performed by the System Manager during installation
       of the product.  It verifies that all the Access Server software
       is present, that the versions of the software match, and that the
       host side of the PC-to-host communication link is in place.

   *   CHGDICPASS is used to notify Access Server that the password for
       the HDPDIC database has been changed.

   *   CHGENVPASS is used to notify Access Server that the password for
       the HDPENV database has been changed.

   *   TUTORIAL resets the definitions required in the data dictionary
       for DBA users to be able to perform their tutorials.

   *   JSPURGE is used to delete or examine status entries in the data
       dictionary related to batch processing.  For more information, see
       Chapter 13, "Batch Processing with Command Files."

   *   SITECHARSET is used to specify the site language.

   *   PARMHELP provides Help text for Administrator Utility parameters.

   *   GONOGO is used to test whether or not HDSP successfully opens and
       runs in the Host Batch Facility.



MPE/iX 5.0 Documentation