Maintenance is a composite of activities that let you adjust
the DBEnvironment to the changing needs of your system's users.
The following are presented in this chapter:
Using simple and complex maintenance operations
Maintaining the DBEnvironment
Dropping and recreating hash structures
Maintaining rules and procedures
Maintaining sets of interrelated objects
Maintaining a nonstop production system
Disabling data definition
Judging maintenance expenses
Cleaning up after abnormal termination
For most maintenance operations, you use the data definition
statements in SQL.
For some maintenance operations, you use SQLUtil and SQLGEN, which are
described in the "DBA Tasks and Tools" chapter, or the ISQL LOAD and
UNLOAD commands.
Complete command syntax for SQLUtil and SQLGEN appears in the appendix
of this manual.
ISQL commands are described in the ISQL Reference Manual for ALLBASE/SQL and IMAGE/SQL.
To monitor DBEnvironment performance, you use SQLMON, which is
described in the ALLBASE/SQL Performance and Monitoring Guidelines.