HP 3000 Manuals HP 3000 Manuals
Chapter 8 System Catalog For each DBEnvironment you configure, ALLBASE/SQL automatically builds and maintains a database known as the system catalog, which contains information about: * Tables and views in the DBEnvironment * Columns in the tables * Indexes on the tables * Constraints, procedures, and rules * DBEFiles and DBEFileSets * Users and their corresponding authorities * Programs that access the DBEnvironment * Current DBEnvironment usage and internal usage This information is actually stored in a set of base tables owned by the special users HPRDBSS and STOREDSECT. The DBA does not share ownership of the system base tables. The base tables of the system catalog are used by ALLBASE/SQL for tasks such as checking user authority, determining optimal access paths to data, and locating DBEnvironment objects. To provide user access to the information in the system catalog, ALLBASE/SQL creates a set of system catalog views on the base tables when the DBEnvironment is configured.