HPlogo ALLBASE/SQL Reference Manual: HP 9000 Computer Systems > Chapter 2 Using ALLBASE/SQL

Understanding the System Catalog
» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

spacerspacerspacer
spacer
spacer
  		 
 

The system catalog is a collection of tables and views that contain data about the following:

  • Tables and views in a DBEnvironment

  • Any indexes, hash structures, constraints, and rules defined for tables

  • DBEFiles and DBEFileSets in the DBEnvironment

  • Specific authorities granted to each user

  • Programs that can access data in the DBEnvironment

  • Current DBEnvironment statistics

  • Temporary space for sorts

  • Procedures

ALLBASE/SQL uses the system catalog to maintain data integrity and to optimize data access. The system views are primarily a tool for the DBA. Initially, only the DBA can access these views. Other users need to be granted SELECT authority by the DBA to access them. Users without SELECT authority can retrieve descriptions of database objects they own from the CATALOG views. For information on system and catalog views, refer to chapter "System Catalog" in the ALLBASE/SQL Database Administration Guide.

When a DBEnvironment is first configured, the information in the system catalog describes the system tables and views themselves. As database objects are defined, their definitions are stored in the system catalog. As database activities occur, most of the information in the catalog is updated automatically, so the system catalog provides an up-to-date source of information on a DBEnvironment.

Immediately following an UPDATE STATISTICS statement, the views in the system catalog, summarized in Table 2-2, are a source of up-to-date information on a DBEnvironment and the structure and use of its databases. Refer to the ALLBASE/SQL Database Administration Guide for additional information on the system catalog.

Table 2-2 System Views

View NamePurpose
SYSTEM.ACCOUNTIdentifies the I/O usage of current database sessions.
SYSTEM.CALLIdentifies current internal calls.
SYSTEM.CHECKDEFContains the search condition defined for each table check constraint. Contains the column name for each column check constraint.
SYSTEM.COLAUTHIdentifies users and groups and their column update and reference authorities.
SYSTEM.COLDEFAULTDescribes the default value of each column defined with a non-NULL default.
SYSTEM.COLUMNContains the definition of each column in each table and view.
SYSTEM.CONSTRAINTContains information on integrity constraints.
SYSTEM.CONSTRAINTCOLContains information on the columns within unique and referential constraints.
SYSTEM.CONSTRAINTINDEXDescribes each unique and referential constraint index.
SYSTEM.COUNTERDescribes the status of internal system counters.
SYSTEM.DBEFILEDescribes the characteristics of each DBEFile.
SYSTEM.DBEFILESETDescribes the characteristics of each DBEFileset.
SYSTEM.GROUPDescribes each authorization group.
SYSTEM.HASHDescribes each hash structure.
SYSTEM.IMAGEKEY Describes each Master and Detail Dataset key associated with TurboIMAGE databases attached to the DBE.
SYSTEM.INDEXDescribes each index.
SYSTEM.INSTALLAUTH Identifies users and authorization groups that have been granted INSTALL authority.
SYSTEM.MODAUTHIdentifies users and groups and the programs they can run.
SYSTEM.PARAMDEFAULTDescribes the default value of each parameter defined with a non-NULL default.
SYSTEM.PARAMETERDescribes each parameter of each procedure.
SYSTEM.PARTITIONContains partition information.
SYSTEM.PLANStores the result of one GENPLAN for each session.
SYSTEM.PROCAUTHIdentifies users and groups and the procedures they can execute.
SYSTEM.PROCEDUREDescribes each procedure.
SYSTEM.PROCEDUREDEFContains the definition of each procedure.
SYSTEM.PROCRESULTDescribes procedure result columns.
SYSTEM.RULEDescribes each rule.
SYSTEM.RULECOLUMNDescribes columns an update rule checks for.
SYSTEM.RULEDEFContains the referencing, WHERE, and EXECUTE PROCEDURE clause of each rule.
SYSTEM.SECTIONDescribes stored modules and views.
SYSTEM.SETOPTINFO Contains SETOPT settings for optimizing specific stored sections.
SYSTEM.SPACEAUTH Identifies users and groups and what DBEFileSets they can use when creating tables, or stored sections.
SYSTEM.SPACEDEFAULTIdentifies the default DBEFileSet to use for a new table or stored section.
SYSTEM.SPECAUTHIdentifies users and groups who have special authorities.
SYSTEM.TABAUTHIdentifies users and groups and table/view operations they can perform.
SYSTEM.TABLEContains a description of each table and view in the DBEnvironment, including size, owner, and associated DBEFileSet.
SYSTEM.TEMPSPACEDefines the TempSpace locations.
SYSTEM.TPINDEXDescribes third-party indexes used in TurboIMAGE databases attached to the DBE.
SYSTEM.TRANSACTIONIdentifies transactions.
SYSTEM.USERIdentifies users currently using the database.
SYSTEM.VIEWDEFContains the SELECT statement that created each view defined in the system.

 



Administering a Database
  		 


Chapter 3 SQL Queries  
Feedback to webmaster