HP 3000 Manuals HP 3000 Manuals
Chapter 7 Maintenance 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 * Maintaining tables * Dropping and recreating hash structures * Maintaining indexes * Maintaining constraints * Maintaining rules and procedures * Maintaining sets of interrelated objects * Maintaining applications * Maintaining a nonstop production system * Maintaining security * 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.