Neoview Database Administrator's Guide (R2.2)

DescriptionOperation
Update all the Materialized Views in a group with the latest contents from the
base table or tables.
Refresh Materialized View
Group
Defragment Materialized Views for this table.Reorganize Materialized Views
Defragment the indexes on Materialized Views for this table.Reorganize Materialized View
Indexes
If you select Continue on Error, maintenance operations continue if they encounter an error.
You can view messages logged by an operation that encounters an error.
Clear this option if you want the maintenance operation to stop if it encounters an error.
Refresh Options apply to materialized views that reference the table. These options are
enabled for a table only if you select the Refresh Materialized Views option. These options
are enabled for a materialized view if the All or Refresh Materialized View options are
checked. These options are always enabled for a materialized view group. Refresh options
are:
DescriptionOption
Refreshes individual materialized views. When checked, the refresh utility creates
a virtual group that includes the current materialized view and all the materialized
views that it relies on, and refreshes them in the right order. Note that a materialized
view can be defined to use a table or another materialized view.
Cascade
Derives the materialized view from scratch. This option is used on the initial refresh
of the materialized view and also to re-derive the materialized view if it is in an
inconsistent state (for example, if the previous refresh was aborted abnormally).
Recompute
Cleans up locks on the log table. If an earlier refresh failed, there might be DDL
locks. The Cancel operation can clear those locks. You should then retry the refresh
operation again by scheduling another Maintain. The Cancel option is mutually
exclusive of the other Refresh options. If the Cancel option is selected, the other
options are disabled.
Cancel
Refreshes the materialized views without cleaning up the log table. To clean up the
log, you can schedule another Maintain operation later with the Do Only Log
Cleanup option. Without Log Cleanup speeds up the Refresh by avoiding the
overhead of cleaning up the log.
Without Log Cleanup
Cleans up the log table but does not refresh the materialized view. The log cleanup
is time-consuming, so you might want to clean up the log at a time when the system
is not busy. You can select either Without Log Cleanup or Do Only Cleanup, but
not both.
Do Only Log Cleanup
Schedule Maintain Wizard 79