Neoview SQL Reference Manual (R2.4)

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 scheduled 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. A MAINTAIN command issued after the task has been disabled
will have no effect. The task will have to be explicitly enabled before performing it. This
option is only available for REORG TABLE and UPDATE STATISTICS TABLE tasks.
Disabling REORG of the table also disables REORG of all indexes.
ENABLE
enables the maintain task that was previously disabled using the DISABLE option. This
option is only available for REORG TABLE and UPDATE STATISTICS TABLE tasks.
Enabling REORG of the table also enables REORG of all indexes.
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 DISPLAY option can be used to see whether the status of the task is enabled or disabled.
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 as specified, an error will be returned. Reorg is
the only maintain task available for multiple tables.
NOTE: The MAINTAIN command is not supported for use with volatile tables.
RATE percentage
specifies that the reorg operation should spend a percentage of its time doing the reorg
and the rest of its time delaying. percentage is an integer in the range of 1 through 100. If
this option is not specified, the default value of 40 is used.
Considerations for MAINTAIN
Using MAINTAIN in JDBC or ODBC Applications
If you plan to use the MAINTAIN command in a JDBC or ODBC application, keep in mind that
the MAINTAIN command executes with cursor-like behavior and returns status information for
each task that it performs. In ODBC or JDBC applications, you must issue fetch calls while
MAINTAIN Command 213