HP 3000 Manuals

Information Access Server: Database Administration

The Database Administrator Tasks 

Your involvement with Access Server is twofold.  Initially, you'll need
to work together with the System Manager to set up Access Server.
Thereafter, you'll be maintaining Access Server and making whatever
changes to the data dictionary are required by your users' changing data
needs.

Setting Up Access Server 


          Figure 1-1.  Setting Up Access Server:  Five Stages 

Setting up Access Server is done in five stages:

   1.  Installing Access Server.  The System Manager installs Access
       Server.  As part of the installation, the System Manager streams a
       job that builds and initializes (for a first-time installation) or
       restructures (for an update to a new release) the Information
       Access data dictionary.

   2.  Learning the Administrator Utility.  If you are new to the
       product, take the DBA tutorial.

       If you have used the product before, you may find it useful to
       retake it or to read through it for new information.

   3.  Planning Your Configuration.  In this stage, you use the
       worksheets in Appendix A of the Information Access Server: 
       Planning and Configuring manual to gather information about PC
       users' data needs.

       Once the information is gathered, it is analyzed to see if the
       default capacity of any of the datasets in the data dictionary
       needs to be adjusted.  Then you and the System Manager come to
       some agreement on the allocation of system resources for Access
       Server, such as the disc space that can be used for saved tables.

   4.  Adjusting the data dictionary, if necessary. 

       Once you've determined what needs to be configured, you'll know
       whether you need to raise the default capacities of any of the
       datasets in the data dictionary.  Changes can also be made, if you
       like, to the database passwords in the schema files for HDPDIC and
       HDPENV, the two databases that comprise the data dictionary.

   5.  Configuring Access Server.  In this stage, you take the completed
       worksheets and use the Administrator Utility to configure Access
       Server.  Configuration involves adding entries to the data
       dictionary that define remote systems (if any), data sources,
       tables, access groups, users, and table and item security.

       If you have Dictionary/3000, you may want to use the Translator
       Utility to take information from Dictionary/3000 data dictionaries
       and add the corresponding database and IMAGE table definitions to
       the Information Access data dictionary.

These five stages are covered in greater detail in the Information Access 
Server:  Planning and Configuring, Learning the Administrator Utility, 
and System Management manuals.

Managing Access Server 

The ongoing management of Access Server, once the product is up and
running, involves the following:

   *   Handling PC user concerns and questions about Access PC and Access
       Server, beyond those your Office Products Coordinator (OPC) is
       able to address.

   *   Keeping in touch with the changing data needs of your PC users to
       be sure your data tables have been configured for greatest
       efficiency.

   *   Modifying the data dictionary (using the Configuration screens in
       the Administrator Utility) whenever there are changes required in
       the definitions of data, users, or data security.  You can, if you
       like, give selected groups of users the limited capability to add
       or delete definitions of databases and tables from their PC.

   *   Checking table synchronization periodically to make sure that your
       table definitions still correspond to the current state of their
       data sources.

   *   Monitoring your users' activities (using the System Status screens
       in the Administrator Utility) to see if you should limit the
       number or size of tables they can save, change the size of the
       data dictionary, or create some new tables that more closely
       correspond to what your PC users require.

   *   Purging your users' job status files on occasion, using the
       HDPUTIL program or the UDC command JSPURGE. These files are
       produced when the Host Batch Facility is run from the host or from
       the PC.

   *   Generating reports (using the Report Main screen in the
       Administrator Utility) on Access Server configuration and system
       status.

   *   Using the Translator Utility to translate new information entered
       in a Dictionary/3000 data dictionary into database and IMAGE table
       entries in the Information Access data dictionary.

   *   Modifying the schemas of the two databases that constitute the
       data dictionary if you find you need to increase the capacity of a
       dataset in one of these databases.

These tasks are covered in Part II (The Administrator Utility), Part III
(The Translator Utility), and Part IV (Managing The System), and in the
Appendixes.  For ways to improve the performance of Access Server, see
Chapter 14, "Performance Tuning."

MPE/iX 5.0 Documentation