Neoview Database Administrator's Guide (R2.3)

6 Performing Database Operations
This chapter describes:
• “Schedule Maintain Wizard” (page 85)
• “Schedule Table Row Deletion” (page 88)
• “Displaying Scheduled Operations' Status” (page 88)
• “Modifying Scheduled Operations” (page 91)
• “Deleting Scheduled Operations” (page 91)
• “Neoview VTS System Status Page” (page 91)
• “Displaying the VTS System Status Page” (page 91)
• “Interpreting the VTS System Status Page” (page 92)
• “Data Recovery” (page 93)
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 58).
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 85