This manual describes how to
design, create, and maintain ALLBASE/SQL databases
on HP 3000 computers running under
the MPE/iX operating system. ALLBASE/SQL is Hewlett-Packard's
proprietary relational database management product.
MPE/iX, Multiprogramming Executive with Integrated POSIX, is the latest
in a series of forward-compatible operating systems for the HP 3000
line of computers. In HP documentation and in talking with HP 3000 users,
you will encounter references to MPE XL, the direct predecessor of MPE/iX.
MPE/iX is a superset of MPE XL. All programs written for MPE XL
will run without change under MPE/iX. You can continue to use MPE XL
system documentation, although it may not refer to features added to
the operating system to support POSIX (for example, hierarchical
directories).
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 SECTs, as follows:
SECT 1, "DBA Tasks and Tools," presents the basic concepts and terms
relating to ALLBASE/SQL database administration.
SECT 2, "Logical Design," shows how to create a database schema prior to
creating an ALLBASE/SQL DBEnvironment.
SECT 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.
SECT 4, "DBEnvironment Configuration and Security," details the steps
in creating a new DBEnvironment.
SECT 5, "Database Creation and Security," shows how to create specific
database objects.
SECT 6, "Backup and Recovery," describes procedures for routine backup
and for recovery when needed.
SECT 7, "Maintenance," presents the tasks required for modifying a
DBEnvironment once it has been in operation.
SECT 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.
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.