HP SQL/V Database Administration Guide

Table of Contents

 HP SQL/V Database Administration Guide
   HP SQL/V Database Administration Guide : COPYRIGHT NOTICE
   Introduction
   HP SQL
   HP SQL OBJECTS
   HP SQL DATABASES
   Scope of Data Access
   LOGGING
   DBA TASKS
   Logical Design
   Defining Data For Tables
   Normalizing Data
   Table Design
   View Design
   Index Design
   Security Design
   Defining Authorization Groups
   Defining Classes
   Defining The DBEnvironment Scope
   Physical Design
   HP SQL Files
   Calculating Storage for DBEnvironment Configuration
   CALCULATING DATABASE STORAGE
   ALLOCATING STORAGE TO DBEFILES AND DBEFILESETS
   Memory Requirements
   IMPLEMENTING THE DESIGN
   DBEnvironment Configuration and Security
   MPE CAPABILITIES
   USING START DBE NEW
   CREATING DBEFilesets and DBEFiles
   Database Creation and Security
   Creating Tables
   CREATING VIEWS
   CREATING INDEXES
   CONTROLLING TABLE ACCESS WITH AUTHORITIES
   CONTROLLING TABLE ACCESS WITH VIEWS
   LOADING TABLES
   COMMAND FILES
   Controlling Performance
   TRANSACTIONS
   Lock Management
   Using Checkpoints
   Monitoring Performance
   Maintenance Expenses
   Number of Buffer Pages
   Backup and Recovery
   Choosing a Backup and Recovery Method
   Backing Up Database Files
   Recovering the DBEnvironment
   Managing Log Files
   Maintenance
   Simple And Complex Operations
   Maintaining the DBEnvironment
   Database Maintenance
   Maintaining Applications
   Maintaining Security
   Cleaning Up The DBEnvironment
   System Catalog
   System.Account
   System.Call
   System.Colauth
   System.Column
   System.Counter
   System.DBEFile
   System.DBEFileSet
   System.Group
   System.Index
   System.Modauth
   System.Section
   System.Specauth
   System.Tabauth
   System.Table
   System.Transaction
   System.User
   HP SQL Limits
   SPACE MANAGEMENT LIMITS
   LOGICAL DATA LIMITS
   Authorities Reguired by SQL Commands
   SQL Syntax Summary
   Expressions
   Search Conditions
   SQL Commands
   ISQL COMMAND SUMMARY
   Sample DBEnvironment
   Sample DBEnvironment Files
   CREASQL Stream File
   STARTDBE Command File
   CREATABS Command File
   LOADSTABS Command File
   CREAINDEX Command File
   CREASEC Command File
   SAMPLE DATA
   SupplyPrice Table
   Vendors Table
   Orders Table
   OrderItems Table
   Inventory Table
   Members Table
   Clubs Table
   Events Table
   Sample Program Files
   SQLUtil
   Using SQLUtil
   SQLUTil Commands
   ALTDBE
   CLEANDBE
   EXIT
   HELP
   MOVEFILE
   PURGEDBE
   PURGEFILE
   QUIT
   RESTORE
   SETDBEMAINT
   SHOWDBE
   SHOWDBE-ALL
   SHOWDBE-EXIT
   SHOWDBE-HELP
   SHOWDBE-MAINT
   SHOWDBE-STARTPARMS
   SHOWDBE-QUIT
   STARTDBEMON
   STORE
   SQLGEN
   EDITOR
   EXIT
   GENERATE ALL
   GENERATE DBE
   GENERATE DBEFILES
   GENERATE GROUPS
   GENERATE INDEXES
   GENERATE LOAD
   GENERATE MODAUTH
   GENERATE SPECAUTH
   GENERATE STATISTICS
   GENERATE TABAUTH
   GENERATE TABLES
   GENERATE VIEWWAUTH
   HELP
   RELEASE
   SET EDITOR
   SET SCHEMA
   Locks Held on the System Catalog by SQL Commands