HPlogo ALLBASE/SQL Reference Manual > Chapter 2 Using ALLBASE/SQL

Administering a Database

MPE documents

Complete PDF
Table of Contents
Index

E0300 Edition 9 ♥
E0399 Edition 8
E0897 Edition 7

Activities that protect and maintain a DBEnvironment and its databases are collectively referred to as database administration. Several of the SQL statements are used in the following database administration activities:

  • Security management

  • Restructuring

  • Space management

  • Logging

  • Recovery

  • DBEnvironment management

  • DBEnvironment statistics maintenance

Refer to the ALLBASE/SQL Database Administration Guide for full details on these and other matters of database administration. That manual provides full information on SQLUtil, which is the primary tool for DBEnvironment reconfiguration and backup.



Using Multiple Connections and Transactions with Timeouts

Understanding the System Catalog