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