Preface

This manual describes how to design, create, and maintain ALLBASE/SQL databases on HP 9000 computers running under the HP-UX operating system. ALLBASE/SQL is Hewlett-Packard's proprietary relational database management product.

This manual contains advanced information about ALLBASE/SQL database administration. It is intended for experienced users of SQL and SQL application programmers. Topics are discussed in separate chapters, as follows:

Chapter 1, "DBA Tasks and Tools," presents the basic concepts and terms relating to ALLBASE/SQL database administration.
Chapter 2, "Logical Design," shows how to create a database schema prior to creating an ALLBASE/SQL DBEnvironment.
Chapter 3, "Physical Design," describes the physical files used in ALLBASE/SQL, and shows how to calculate the amount of space required for various database objects.
Chapter 4, "DBEnvironment Configuration and Security," details the steps in creating a new DBEnvironment.
Chapter 5, "Database Creation and Security," shows how to create specific database objects.
Chapter 6, "Backup and Recovery," describes procedures for routine backup and for recovery when needed.
Chapter 7, "Maintenance," presents the tasks required for modifying a DBEnvironment once it has been in operation.
Chapter 8, "System Catalog," contains a complete description of all the system catalog pseudotables and views.

The following appendixes contain additional reference material.

Appendix A describes system limits.
Appendix B presents a table of the authorities required to execute ALLBASE/SQL commands.
Appendix C is a summary of SQL syntax.
Appendix D is a summary of ISQL syntax.
Appendix E is a list of locks obtained on the system catalog by various SQL commands.
Appendix F contains the syntax of SQLUtil commands.
Appendix G contains the syntax of SQLGEN commands.
Appendix H contains the syntax of SQLMigrate commands.
Appendix I contains the syntax of SQLAudit commands.
Appendix J explains how to use HP-UX raw files with ALLBASE/SQL.

Most of the examples in this manual are based on the tables, views, and other objects in the sample DBEnvironment PartsDBE. For complete information about PartsDBE, refer to the ALLBASE/SQL Reference Manual, appendix C.

Preface

Technical documentation

» Table of Contents

» Index