HPlogo ALLBASE/SQL Database Administration Guide: HP 3000 MPE/iX Computer Systems

Chapter 8  System Catalog
» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

spacerspacerspacer
spacer
spacer
  		 
 

Table of Contents

Views owned by SYSTEM and CATALOG
Summary of System Catalog Views by Function
Using the System Catalog
System Catalog Views
Using UPDATE STATISTICS on System Views
Locking of the System Catalog
Storedsect.System
Storedsect.DBEFileSetName
System.Account
Example
System.Call
Example
System.CheckDef
Example
System.Colauth
Example
System.Coldefault
Example
System.Column
Example
System.Constraint
Example
System.Constraintcol
Example
System.ConstraintIndex
Example
System.Counter
Example
System.DBEFile
Example
System.DBEFileSet
Example
System.Group
Example
System.Hash
Example
System.Imagekey
Example
System.Index
Example
System.Installauth
Example
System.Modauth
Example
System.Paramdefault
Example
System.Parameter
Example
System.Partition
System.Plan
Example
System.Procauth
Example
System.Procedure
Example
System.ProcedureDef
Example
System.ProcResult
Example
System.Rule
Example
System.RuleColumn
Example
System.RuleDef
Example
System.Section
Example
System.Setoptinfo
Example
System.Spaceauth
Example
System.Spacedefault
Example
System.Specauth
Example
System.Tabauth
Example
System.Table
Example
System.TempSpace
Example
System.TPIndex
System.Transaction
Example
System.User
Example
System.ViewDef
Example

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.



Cleaning Up after Abnormal Termination
  		 


Views owned by SYSTEM and CATALOG  
Feedback to webmaster