HP 3000 Manuals HP 3000 Manuals
Information Access Server: Learning the Administrator Utility Printed in U.S.A. HP Part No. B1716-90023 Edition Third Edition E0290
(c) 1987, 1988, 1990 by HEWLETT-PACKARD COMPANY Printed 19900201 Notice The information contained in this document is subject to change without notice. HEWLETT-PACKARD PROVIDES THIS MATERIAL "AS IS" AND MAKES NO WARRANTY OF ANY KIND, EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. HEWLETT-PACKARD SHALL NOT BE LIABLE FOR ERRORS CONTAINED HEREIN OR FOR INCIDENTAL OR CONSEQUENTIAL DAMAGES IN CONNECTION WITH THE FURNISHING, PERFORMANCE OR USE OF THIS MATERIAL WHETHER BASED ON WARRANTY, CONTRACT, OR OTHER LEGAL THEORY. Hewlett-Packard assumes no responsibility for the use or reliability of its software on equipment that is not furnished by Hewlett-Packard. This document contains proprietary information which is protected by copyright. All rights are reserved. No part of this document may be photocopied, reproduced or translated to another language without the prior written consent of Hewlett-Packard Company. ________________________________________________________________________ Company or product names followed by (R) are U.S. registered trademarks of the respective company. Company or product names followed by (TM) are registered trademarks of the respective company. Lotus 1-2-3(R), Symhpony(R), and VisiCalc(R) are U.S. registered trademarks of Lotus Development Corporation. Omnidex(TM), and IMSAM(TM) are U.S. trademarks of Dynamic Information Systems Corporation. CONDOR(TM) is a U.S. trademark of Condor Computer Corporation. dBASE II(R), dBASEIII(R), and dBASE IV(R), are U.S. registered trademarks of Ashton-Tate Corp. IBM(R), PC(TM), XT(TM), AT(TM), PC-DOS(R), and DisplayWrite 3 are trademarks of International Business Machines Corp. MS-DOS(R), Microsoft(R), and Multiplan(R) are U.S. registered trademarks of Microsoft Corporation. Data Management Systems Division 8010 Foothills Boulevard Roseville, CA 95678, U.S.A. Printing History New editions are complete revisions of a manual. Update packages are issued between editions. They contain additional and replacement pages to be merged into the manual by the customer. The following print dates are in effect for this manual: Printed in: ________________________________________________________________________ First Edition, April, 1987 .............................. U.S.A. Second Edition, June, 1988 ................................... . Third Edition, February, 1990 ................................ . Conventions Convention Description This symbol represents a labeled key on the keyboard. For example, Shift is the shift key, Y is the Y key, etc. Exceptions Keyboard Instructions: The Enter and Return keys discussed in our procedures and examples specifically refer to the Enter and Return keys on a terminal. If you are using an HP Vectra, IBM, Compaq, or IBM-compatible personal computer with a terminal emulator, use the keys that are the equivalent of Enter and Return. Function Label f1 Function Labels correspond to function keys labeled f1 through f8 on the keyboard. If your keyboard has another set of keys labeled f1 through f10, these keys will not work for utilities on the HP 3000. To choose a Function Press the corresponding function key on your keyboard. Label... Although PC users can choose function labels using HP Touch or a mouse, these input devices are not active for utilities on the HP 3000. SCREEN TEXT Screen text represents text, examples, or syntax statements displayed on the screen. Examples and syntax statements may include a program prompt, COMMANDS, ELEMENTS, variables, symbols, and punctuation. For example: :HELLO username.accountname :FILE T;DEV=TAPE;DEN=1600 :STORE filename.group.account;*T;SHOW Table Front-0. (cont.) Convention Description COMMANDS and are displayed in UPPERCASE to indicate that ELEMENTS they are to be typed as shown. variables represent parameters you MUST replace with appropriate information. ``;,". punctuation are typed as shown except for {} braces and and [] brackets which are used to indicate *!@= symbols alternates and options. {ALTERNAMES} are COMMANDS, ELEMENTS, or variables within {braces}. At least one is required. { ALTERNATE A} Type A or B { ALTERNATE B} [OPTIONS] are commands, elements, or variables within [brackets]. All are optional. [ OPTION A] Type A, B, or neither [ OPTION B] SCREEN HIGHLIGHT Represents highlighted text or data entry fields on the screen. _______________________________________ | | | | | Screen Title | | Instructions | | | | Field data entry | | | | | | | _______________________________________ This screen image represents your workstation screen. Our example includes a Screen Title displayed on the top banner line. This may be followed by a single line of Instructions. Within the body of the screen we have an example of a Field name and an associated data entry field where you would type in your data. Function labels along the bottom of the screen display operations you can perform, or provide assistance. Before You Begin This manual will give you a basic understanding of Information Access Server and some hands-on experience with the Administrator Utility. While it does not cover all the features of the product, it will acquaint you with the functions you'll use most often. You use this manual first as the second stage in the five- stage process of setting up (or updating) Information Access Server. Afterwards, others needing to learn the Administrator Utility can use this manual on a stand-alone basis.
NOTE Throughout this manual, the term IMAGE is used as a shorthand term for TurboIMAGE. Access PC and Access Server are often used as shorthand terms for Information Acccess PC and Information Access Server, respectively. For U-based (and later) MITs, Information Access Server works with TurboIMAGE/3000 on the host HP 3000. Remote databases accessed by Information Access Server can be either IMAGE/3000 or TurboIMAGE/3000 databases.
Who Should Read this Manual If you are a Database Administrator (DBA) or someone working in that capacity, these lessons are for you. We assume that you have: * An understanding of Database Administration concepts and practices. * Programming experience in commercial applications. * A working knowledge of PCs and their applications. * A working knowledge of the HP 3000. * A working knowledge of IMAGE/3000 and databases. * An understanding of Dictionary/3000 (optional). Information Access allows more than one DBA to run the Administrator Utility. However, not all DBAs can perform all the Administrator Utility functions. The primary DBA has complete control over the Administrator Utility and its functions and can delegate responsibility to one or more secondary DBAs. For a description of what the primary DBA and a secondary DBA can do, see "DBA Capabilities" in Chapter 2 of the Information Access Server: Database Administration manual. This manual is designed for use by either the primary DBA or a secondary DBA. What You'll Learn By the time you finish these lessons, you will have an understanding of how Access PC and Access Server interact. You will also learn the basics of using and maintaining Access Server through its Administrator Utility. Through reading and hands-on practice, you will learn how to: * Define information that resides on an HP 3000 computer in the form of tables that can be accessed by PC users. * Specify how individual Information Access users (and groups of users) can use Access Server and system resources such as disc space and MPE priority (primary DBA only). * Secure table information by selectively limiting user access. * Examine and verify some or all of the above configuration, which is defined in the Information Access data dictionary. * Change and delete entries you've added to the data dictionary. * Print reports about what is currently configured. * Make Access Server ready for this DBA tutorial. How to Do the Lessons Each of the six lessons in this manual concentrates on a group of related tasks. Lesson Structure Each lesson has the following structure: Lesson Plan. The objectives, time estimate, and resources needed. Lesson Tasks. The tasks, including reading, exercise instructions, observations, notes, and references. Lesson Summary. A summary of what you just learned. Review Questions. A quick review of the important points. If Someone Else Wants to Learn If several people are using this tutorial, one must finish before the next begins. The hands-on exercises in the tutorial configure Access Server. This configuration must be cleared before each new DBA takes the tutorial. Lesson 6 describes how to clear the configuration automatically. When You Need Help The Administrator Utility features a large number of help screens. These provide a quick reference for most of the Administrator Utility screens. Feel free to use the help screens at any time by choosing Help f7. For additional information, see the Information Access Server: Database Administration manual. The boxed references at the beginning of each exercise will help you find the appropriate sections. Error messages are listed and explained in numeric order in the Information Access Server: Error Messages manual. (Error message numbers appear on-screen at the end of each error message.) If you need further help, ask your System Manager, who may need to call your Hewlett-Packard support representative. (Information to gather before calling is listed in the Information Access Server: System Management and Database Administration manuals.) Where to Find More Information In addition to this manual, you may need to consult the following manuals: * Learning Information Access PC * Using Information Access PC * Information Access PC Connections and Batch Files * Information Access Server: Database Administration * Information Access Server: Planning and Configuring * Information Access Server: Error Messages * Information Access Server: System Management * TurboIMAGE Data Base Management System Reference Manaual Description of Sample Databases Two sample databases provided with Access Server, SAMPL1 and SAMPL2, are used in this tutorial. Each of them contains information about the sale and distribution of products. The sample databases are from a fictitious office supply company that takes orders from customers scattered throughout North America. The company has sales representatives, buyers, clerical staff, and an operations manager. When orders are received, they are sent to a warehouse to be filled. A master list of products and the current inventory are used by the warehousing staff to confirm and ship orders. SAMPL1 is the Order Management database. SAMPL2 is the Inventory Control database. The structures of SAMPL1 and SAMPL2 are shown in Figures 1 and 2. An overview of each structure is given below using the circled letters (A, B, etc.) as a guide. For your convenience, the schemas for both databases are provided in Appendixes A and B. Each dataset in the two databases has a small capacity and comes with a representative sample of information already entered in it. During the course of the lessons, you'll define most of the datasets in both databases as IMAGE tables. You'll then derive both simple and complex view tables from these IMAGE tables. The view tables are what your PC users will see and work with. (Don't worry about any unfamiliar terms. They'll be explained in the lessons.)Structure of SAMPL1 Database SAMPL1: Order Management Database SAMPL1 is a database that contains order information. In our mock application, this database is used to record incoming orders. Sales representatives query the database regarding orders. Clerical staff enter orders. Buyers review what is on order to schedule orders from suppliers. An operations manager reviews the performance of a given sales representative. You can easily see the possible types and combinations of information needed in our office supply company. * CUSTOMER-MASTER (A): A manual master dataset containing basic customer information, such as account number (ACCOUNT), customer name (CUSTOMER), etc. * DATE-MASTER (B): An automatic master containing the order date (ORDER-DATE) for any given order. * SALES-STAFF (C): A manual master dataset containing information about the sales representatives. This includes sales representative name (SALES-REP), employee number (EMP-NBR), sales dollars generated per month (SALES), etc. * ORDER-DETAIL (D): A detail dataset containing all the information for any given order, such as the product ordered (PRODUCT-NBR), the quantity ordered (ORDER-QTY), etc.Structure of SAMPL2 Database SAMPL2: Inventory Control Database SAMPL2 is a simplified inventory control/status database. The order processing department of our fictitious company uses this database to determine the location from which goods are shipped. Shipping uses the database to gather shipping data. * PRODUCT-MASTER (F): A manual master dataset containing the master product description. * WAREHOUSE-MASTER (G): An automatic dataset containing the warehouse location name. * INVENTORY (H): A detail dataset containing inventory status information such as the quantity on hand, etc.
![[]](../../pic3k/M012040/FFN23c50.gif)
![[]](../../pic3k/M012040/FFN33c50.gif)