HP 3000 Manuals HP 3000 Manuals
Information Access Server: Database Administration Printed in U.S.A. HP Part No. B1716-90020 Edition Sixth Edition E0290
(c) 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. Update 1, December, 1985.................. Second Edition, August, 1986.............. Third Edition, April, 1987................ Update 1, August, 1987.................... Fourth Edition, June, 1988............... Fifth 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] Table Front-0. (cont.) Convention Description 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. About This Manual InformationAccess in Brief Information Access is a component 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 and HP 9000 computers, depending on which server is used, as well as to access PC-resident databases. * Information Access Server is the HP 3000-based data server running on MPE/V and MPE/XL. * 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 and HP 9000.
NOTE Throughout this manual, the term IMAGE is used as a shorthand term for TurboIMAGE. 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. Access PC and Access Server are used as shorthand terms for Information Access PC and Information Access Server, respectively.
Who Should Read This Manual If you are responsible for maintaining Database Management Systems (DBMS) on an HP 3000 computer, then this manual is for you. Your job title may be something other than Database Administrator (DBA) but we'll assume you're performing the DBA function for Access Server. We do expect readers of this manual to have some expertise in dealing with databases and files. To be more specific, we assume you are an experienced HP 3000 user who: * Understands MPE account management including security and file access. * Has a working knowledge of IMAGE/3000 (you've completed the TurboIMAGE/DBMS 3000 course, 35053B, and its prerequisites). * Has programming experience involving commercial applications. * Has a basic understanding of the HP Vectra, supported IBM PCs, or supported IBM-compatible PCs, and a working knowledge of PC-to-host applications. * Understands and has some practical experience applying database administration concepts. * Understands Dictionary/3000, only if you want some or all of the information defined in a Dictionary/3000 data dictionary to be entered in your Information Access data dictionary as well (you've completed the self-paced course that comes with Dictionary/3000). What Is in This Manual This manual provides a Database Administrator's view of Access Server. Part I, OVERVIEW, gives an introductory look at Access Server and the DBA's involvement with it. Part II, THE ADMINISTRATOR UTILITY, provides procedures, screen descriptions, and reference information about the Administrator Utility (the tool you'll use most often). Part III, THE TRANSLATOR UTILITY, provides similar information about the Translator Utility. Part IV, MANAGING THE SYSTEM, covers PC user interaction with the HP 3000, the Host Batch Facility, and performance tuning. The Appendixes provide detailed information about the data dictionary, the creation of view table definitions, view table syntax, and ISO-7 support. What is New inThis Version This manual covers Version A.05 of Access Server. The following new features have been added: * Secondary DBAs can configure access groups and users (see Chapters 6 and 7). * A primary DBA or secondary DBA can assign default table security to configured tables (see Chapter 8). * The Administrator Utility allows listing of tables by access group (see Chapter 8). * View table functionality is provided by the new SQL command in the Host Batch Facility (see Chapter 13 and Appendix B). * Up to 16 tables can now be JOINed in a view table (see Chapter 5 and Appendix B). * The new left outer JOIN allows the inclusion of all records in a table (see Appendix B). * An asterisk (*) in the Item Clause in a view table now means that all items are included from all tables specified in the Using Clause (see Chapter 5 and Appendix B). * Up to 16 sort items are now allowed, up from 8 in previous versions (see Chapter 5 and Appendix B). * IMSAM keyed reads are now supported on MPE/XL for users that have the OMNIDEX Information Management System (see Appendix B). * Reports generated from the Administrator Utility's Report screens show the name of the DBA who requested the report (see Chapter 10). * Reserved words such as CASE, DIV, and MATCH, can be used for item and table names in view tables (see Chapters 2 and 5). * DBAs can configure an editor to create and change view tables (see Chapters 2 and 5). * The Host Batch Facility can output to ALLBASE/SQL tables (MPE/XL only) (see Chapter 13). * After performing a cancel in the Host Batch Facility, records that were retrieved before the cancel are retained (see Chapter 13). * The Host Batch Facility provides a mechanism for prompting for query values (see Chapter 13). * Up to 10 group by items are now allowed, up from 4 in previous versions (see Chapter 13). 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: Planning and Configuring * Information Access Server: Learning the Administrator Utility * Information Access Server: Error Messages * Information Access Server: System Management * Information Access SQL/XL * Information Access SQL/UX * Using Basic Serial Connection Files * TurboIMAGE Data Base Management System Reference Manual * 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. This manual covers in detail the tasks you'll perform as Database Administrator, and all of Access Server's functions. If you need further help, contact your System Manager, who may need to call 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, type the UDC: HOSTVERIFY or :RUN ADMIN.PPC.SYS;PARM=5 The version number appears in the last line of the Verification Test results. 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 IMAGE data or file data resides. Problem Details. Keep track of details pertaining to your problems: * 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. * The software in use when the problem occurred (Access PC, Administrator Utility, and so on). * Note the function being performed and the screens displayed. * Write down any error messages and/or numbers that appeared. * Print out any spoolfile listings containing error information.
NOTE When Access Server loads and manipulates large tables of HP 3000 data, those operations can take some time. The same may be true of large mainframe tables, depending on the speed of the datacom line, the number of records, and the record length. For performance data, please refer to the Information Access Server: System Management manual. For ways you and your users can improve product performance, please see Chapter 14 in this manual.
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).