HP 3000 Manuals HP 3000 Manuals
Information Access Server: System Management Printed in U.S.A. HP Part No. B1716-90018 Edition Sixth Edition E0290
(c) 1985 - 1990 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, August, 1985................ U.S.A. Second Edition, August, 1986.............. Third Edition, April, 1987................ Update 1, August, 1987.................... Fourth Edition, February, 1988............ Fifth Edition, June, 1988................. Sixth 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 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. {ALTERNATES} 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 Half-brightand represents highlighted text or data entry fields on the screen. About This Manual InformationAccess in Brief Information Access is a service of HP NewWave Office. It consists of Information Access Server, Information Access SQL/XL, Information Access SQL/UX, and Information Access PC. Information Access allows PC workstations to access information resident on HP 3000 or HP 9000 computers, depending on which server is used, as well as to manipulate PC-resident databases. * Information Access Server is the HP 3000-based data server running on MPE/V and MPE/XL. It includes the Administrator Utility and the Translator Utility. * Information Access SQL/XL is the HP 3000-based SQL server running only on MPE/XL. * Information Access SQL/UX is the HP 9000-based SQL server running on HP-UX. * Information Access PC is the PC-based software with which users retrieve, manipulate, and save information, locally or on the HP 3000 or HP 9000.
NOTE Throughout this manual, the term IMAGE is used as a shorthand term for either IMAGE/3000 or TurboIMAGE/3000. For U-based (and later) MPE/V 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. Under MPE/XL, only TurboIMAGE/3000 databases are supported. In addition to databases, you can also access files. Also in this manual, the term "MPE" is used generically, except when the reference is to a specific version such as MPE/V or MPE/XL. Access PC and Access Server are used as shorthand terms for Information Access PC and Information Access Server, respectively.
Who Should Read This Manual This manual is a guide to Access Server system management. It is written for the person who functions as the System Manager of the HP 3000 system on which Access Server is installed. Although your title may not be System Manager, you'll need to have HP 3000 System Manager (SM) capability to do this job. The System Manager is responsible for installing and maintaining Access Server, troubleshooting, and keeping the product and the HP 3000 running efficiently. You should have a working knowledge of HP 3000 software and hardware and be familiar with standard HP 3000 operating procedures. This manual assumes that you have the knowledge and expertise provided by HP's System Operator and System Manager training. The System Manager function is one of the two primary functions involved in the successful operation of Access Server. The other is that of the primary Database Administrator (DBA). The primary DBA is responsible for data management and security. In addition, the primary DBA can also appoint secondary DBAs and give them authority to control specific data and to configure access groups and users. If your operation includes Office Products Coordinators (OPCs) who help the PC users with the Access PC software, they are likely to be the first persons users turn to for answers to questions about Access Server. You'll want to organize the information path from users to you and the DBA. You, the primary DBA, and any secondary DBAs should understand each other's role, and the functions and responsibilities of Access Server operation. All of you should read this manual and the Information Access Server: Database Administration manual. Since you will work with the Access PC software on the PC, it's also important that you understand that product. Titles of Access Server, Access PC, and other documentation are listed in the "Where to Find More Information" discussion below. What Is in This Manual This manual describes the effects of the Access Server software on the day-to-day operation of your HP 3000. It explains the things a System Manager needs to know about Access Server: what it is, how it works, how to install it, and how to keep it running smoothly. Chapter 1, "System Management and Access Server," lists the functions performed for the PC user by Access Server, describes Information Access software components, explains how the software works, and provides an overview of security considerations. Chapter 2, "The Access Server Environment," describes the software and hardware requirements for HP 3000s and personal computers to ensure successful operation of Access Server. Chapter 3, "Installing Access Server," guides you through the installation process, explains how to verify the installation, and lists the MPE files that comprise the product. Chapter 4, "Access Server Operations," provides useful information for day-to-day maintenance of Access Server on your HP 3000, including required procedures, recommended configuration values, and recovery procedures. Chapter 5, "Performance Tuning," provides suggestions to help you ensure optimum performance of Access Server on your system. Appendix A, "Migrating the Data Dictionary and Databases," describes how to migrate the data dictionary and databases from an MPE/V system to an MPE/XL system. 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: Learning the Administrator Utility * Information Access Server: Error Messages * Using Basic Serial Connection Files * TurboIMAGE Data Base Management System Reference Manual * TurboIMAGE/XL Reference Manual * HP 2334A Multimux Reference and Service Manual * HP OfficeShare Networking PC Workstation Configuration Guide for LANs * OMNIDEX Information Management System Reference Manual How to Get Help On-line help is available in the Administrator Utility and the Translator Utility. Choosing Help f7, available from most screens, displays information about that screen. In the Host Batch Facility, type HELP for information. If you need further help with a problem you've been unable to solve by using the product manuals, contact your Hewlett- Packard support representative. You may be asked for the following kinds of information when you call: Version Numbers. For MPE, type :SHOWME. For the version number of Access PC, run Access PC and look for the version in the opening banner before it is replaced by the Main Menu. For Access Server, log on and use the UDC command :HOSTVERIFY. Or, RUN ADMIN.PPC.SYS;PARM=5 Access Server's version number will be displayed. For version A.04.00 and later of Access Server, a complete version verification of all its modules will be performed. Environment. You may be asked for the following information about your environment: * The type and configuration of the host system * The type and configuration of any remote HP 3000 systems used with the product * The number of users connected directly to the host * The number of users connected over a modem * The number of users connected on a LAN * If a PC problem, which PC and how connected * The number of configured users and active users Security. You may be asked for the following information related to security: * The Access Server, MPE, and IMAGE security in effect. * The accounting structures in effect. In particular, you may be asked what security has been established for the group PPC.SYS, the PPCDICT, PPCSAVE, and PPCUTIL groups in the HPOFFICE account, the logon groups and accounts of users, and the groups and accounts in which data resides. Problem Details. Keep track of details pertaining to your problem: * If you can reproduce the problem, write down the details of the user actions that will reproduce it. * If the problem is intermittent, write down the actions that preceded it. * Note the type of software in use when the problem occurred (Access PC, Administrator Utility, Host Batch Facility, and so on). * Note the function being performed and the screens displayed. * Write down any error messages and/or numbers that appeared. * Print out spoolfile listings containing error information.
CAUTION The integrity of the Information Access data dictionary can be destroyed if you use a utility against it that is not listed below. Hewlett-Packard will only support the following utilities used in conjunction with the data dictionary: The Administrator Utility (ADMIN.PPC.SYS) The Translator Utility (TRANS.PPC.SYS) DBUTIL DBLOAD/DBUNLOAD DBCHANGE QUERY/3000 DBSTORE/DBRESTOR *STORE/RESTORE *SYSDUMP DBCHANGE is only supported for changing dataset capacities or the passwords used to open HDPDIC and HDPENV. QUERY/3000 is also supported except when it is used to modify the data dictionary in any way. Hewlett-Packard will investigate and attempt to resolve problems resulting from the use of utilities that do not appear on the above list. This service is not provided under HP's standard support agreements, but is available on a time and material basis. HEWLETT-PACKARD IS NOT RESPONSIBLE FOR ANY LOSS OR DAMAGE RESULTING FROM A CUSTOMER'S USE OF THE INFORMATION ACCESS DATA DICTIONARY WITH UTILITIES NOT LISTED ABOVE. *Please note that STORE/RESTORE and SYSDUMP are supported only when used on the data dictionary in its entirety (the root files and all the datasets in the HDPDIC and HDPENV databases).