Neoview SQL Reference Manual (R2.5)

other-options
CONTINUE ON ERROR
If any of the maintain tasks return an error, that error is returned, and execution continues
to the next task. The default is to continue on error.
STOP ON ERROR
If any of the maintain tasks return an error, that error is returned, and execution stops.
RETURN DETAIL OUTPUT
displays a detailed message from each of the individual tasks. The default is OFF.
DISPLAY
displays the tasks that are enabled to be executed without actually executing them.
DISPLAY DETAIL
displays the tasks, and the queries that will be used to execute them, without actually
executing the tasks.
control-options
NOTE: Control options are not supported for multiple tables.
DISABLE
disables the maintain task. When the MAINTAIN DISABLE task is performed, MAINTAIN
internally records that this task is in a disabled state. When a subsequent MAINTAIN
command is performed matching this task, MAINTAIN will confirm if the task can be
performed. If the task is in a disabled state, the task will not be performed. The MAINTAIN
ENABLE task must be performed before the disabled task can be performed under a new
MAINTAIN command.
ENABLE
enables the maintain task. When the MAINTAIN ENABLE task is performed, MAINTAIN
internally records that this task is in an enabled state. When a subsequent MAINTAIN
command is performed matching this task, MAINTAIN will confirm if the task can be
performed. If the task is in the enabled state, the task will be performed. The MAINTAIN
ENABLE task re-enables the MAINTAIN task that was previously disabled using the
DISABLE option. Tasks are enabled by default under MAINTAIN.
These control options are available for:
• REORG and UPDATE STATISTICS for TABLE
• REORG, REFRESH, and UPDATE STATISTICS for a materialized view
• Disabling REORG of a table also disables reorg of all indexes
• Enabling of REORG of a table also re-enables reorg of all indexes
The MAINTAIN DISPLAY option can be used to see whether the status of the task is enabled
or disabled.
MAINTAIN For Multiple Tables
TABLES
Multiple object-names (table names) are specified. The maximum number of specified
objects in one command is 100. If any table in the list of specified tables has been disabled
for maintain operations, it will not be maintained. All other enabled tables will be maintained.
If any table in the list of tables is not a base table, an error will be returned, and the MAINTAIN
command will fail. If duplicate table names are specified, an error will be returned. REORG
is the only maintain task available for multiple tables.
MAINTAIN Command 215