Neoview Database Administrator's Guide (R2.2)

6 Performing Database Operations
This chapter describes:
• “Schedule Maintain Wizard” (page 77)
• “Schedule Table Row Deletion” (page 80)
• “Displaying Scheduled Operations’ Status” (page 82)
• “Modifying Scheduled Operations” (page 83)
• “Deleting Scheduled Operations” (page 83)
• “Data Backups” (page 84)
• “Neoview VTS System Status Page” (page 84)
• “Displaying the System Status Page” (page 84)
• “Interpreting the System Status Page” (page 85)
• “Data Recovery” (page 85)
Schedule Maintain Wizard
You can perform a variety of maintenance tasks on tables and materialized views, such as
scheduling update statistics or defragment operations, with the Schedule Maintain wizard. For
information on enabling or disabling Reorganize or Update Statistics on a table, see “Enabling
or Disabling Reorganize and Update Statistics on Tables” (page 56).
1. Start DB Admin and log on using any user ID allowed to maintain tables or materialized
views. The DBA role is intended for this task.
2. Click the Database tab and then and navigate to the schema and table that you want to
maintain.
3. Right-click the table name or materialized view name and select Maintain to start the
Schedule Maintain wizard. For a table, DB Admin displays this screen:
For a materialized view, DB Admin displays this screen:
Schedule Maintain Wizard 77