This chapter describes
the steps in which a SESAM/SQL database is built, and how the database structure can be modified
how user data can be loaded and unloaded
the maintenance tasks associated with a SESAM/SQL database
Statements and tools for building and maintaining a database
The utility monitor is a convenient tool that is used to build and maintain SESAM/SQL databases. It provides the database administrator with the means he/she requires in order to carry out all the tasks associated with building and maintaining a SESAM/SQL database through a menu-driven interface (see the “Utility Monitor” manual).
Alternatively, the database administrator can use ESQL programs to build and maintain SESAM/SQL databases. The following groups of statements are available for using this program:
Utility statements
SQL statements for managing the storage structure
an SQL statement for administering user entries
SQL statements for the definition and administration of schemas
The SQL statements are described in detail in the “SQL Reference Manual Part 1: SQL Statements” and the utility statements are described in the “SQL Reference Manual Part 2: Utilities”.