Neoview SQL Reference Manual (R2.4)

Not all tasks and options are available for each object type. The syntax for each object type is
presented here.
For single tables:
MAINTAIN object-type object-name
[,maintain-task ['task-options']...]
[, other-options...][,control-options]
object-type is:
TABLE
INDEX
MVGROUP
MV
maintain-task is:
ALL
REORG
REORG ALL INDEXES
UPDATE STATISTICS
UPDATE STATISTICS ALL MVS
REFRESH
REFRESH ALL MVS
REORG ALL MVS
REORG ALL MVS INDEXES
other-options is:
CONTINUE ON ERROR
STOP ON ERROR
RETURN DETAIL OUTPUT
DISPLAY
DISPLAY DETAIL
control-options is:
ENABLE
DISABLE
For multiple tables:
MAINTAIN TABLES ( object1, object2, ..., objectN )
[,multi-table-maintain-task ['task-options']...]
[, other-options...]
mult-table-maintain-task is:
REORG
task-option for REORG is:
, RATE percentage
Syntax Description of MAINTAIN
The MAINTAIN command performs all or a subset of tasks on a specific object. The order of
execution depends on the natural order of tasks. You can also use the command to perform all
tasks for a particular object type.
NOTE: MAINTAIN of multiple tables is available only through the command-line interface in
NCI or the SQL Whiteboard in HPDM. It is not available in Neoview DB Admin.
The group of tasks to be executed depend on the object-type.
If you specify ALL, all tasks relevant to that object-type are performed. The detailed tasks
for each object-type are:
• TABLE — The object-name specified is the table that needs to be maintained. Tasks done
are reorg of the table, reorg of all indexes on the table, update of table statistics, update of
MAINTAIN Command 211