 |
» |
|
|
|
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. |
