ALLBASE/SQL Reference Manual (36216-90216)

Chapter 1 43
Introduction
ALLBASE/SQL Components
Utility Programs
In addition, these utility programs help you perform the necessary maintenance tasks:
• SQLUtil assists with file maintenance, backup, and recovery.
• SQLGEN generates statements for re-creating a given DBEnvironment.
• SQLMigrate lets you move DBEnvironments between releases of ALLBASE/SQL.
• SQLCheck checks the integrity of a DBEnvironment.
• SQLMON helps you monitor DBEnvironment performance.
• SQLVer checks the version strings of the ALLBASE/SQL files.
• SQLAudit organizes audit log records for analysis of operations such as UPDATE,
INSERT, or DELETE, perhaps for security reasons.
The utility programs listed that are not included in Figure 1-1 all interact with the Storage
Manager (DBCore).
ISQL is described in the ALLBASE/ISQL Reference Manual. The preprocessors are
documented in separate ALLBASE/SQL application programming guides for each
language and the release specific ALLBASE/SQL Advanced Application Programming
Guide.
SQLUtil, SQLGEN, SQLMigrate, SQLCheck, SQLVer, and SQLAudit are documented in
the ALLBASE/SQL Database Administration Guide. SQLMON is documented in the
ALLBASE/SQL Performance and Monitoring Guidelines. The rest of this manual
describes SQL, pointing out differences between interactive and programmatic usage
when they exist. Most of the SQL statements can be executed through either interface.