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

Chapter 4 DBEnvironment Configuration and Security

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

Table of Contents

Required MPE/iX Capabilities
Using START DBE NEW
Supplying Startup Parameters with START DBE NEW
Log Files
Specifying a Native Language Parameter
Looking at the DBEnvironment Elements
Creating Audit DBEnvironments
Example of Setting Up an Audit DBEnvironment
Defining Additional Audit DBEnvironment Log Files
Disabling Audit Logging
Creating DBEFileSets and DBEFiles
Creating DBEFileSets
Assigning Default DBEFileSets
Creating DBEFiles
Adding DBEFiles to DBEFileSets
Allocating Expandable DBEFile Space
Allocating Expandable DBEFile Space in the SYSTEM DBEFileSet
Partial DBEFile Expansion
Obtaining Information about Expandable DBEFiles
Creating the DBEnvironment Security Scheme
Creating Authorization Groups
Managing Authorization Groups
Using DBA Authority
The DBECreator
Granting Authorities to PUBLIC
Granting/Revoking CONNECT Authority
Granting/Revoking RESOURCE Authority
Granting/Revoking RUN Authority
Granting/Revoking EXECUTE Authority
Granting/Revoking SECTIONSPACE or TABLESPACE Authority
Verification of Authority
Managing DBEnvironment Sessions
Using Autostart
Using START DBE
Connecting to a DBE
Terminating a DBE Session
Setting Timeout Values
Remote Database Access

Before you can create ALLBASE/SQL databases, you must configure a DBEnvironment. After you configure the DBEnvironment, you create the physical storage space for the databases, then you create the actual tables, views, and indexes.

If this is your first time using ALLBASE/SQL, you should study the examples in this chapter, which are based on the sample DBEnvironment, PartsDBE. The "Sample DBEnvironment" appendix in the ALLBASE/SQL Reference Manual contains a complete description of PartsDBE.

The topics described in this chapter are:

  • Required MPE/iX Capabilities

  • Using START DBE NEW

  • Creating Audit DBEnvironments

  • Creating DBEFileSets and DBEFiles

  • Creating the DBEnvironment security scheme

  • Managing DBEnvironment Sessions

After reading this chapter, you can configure your own DBEnvironments and create databases using your own design specifications.

Feedback to webmaster