Neoview SQL Reference Manual (R2.5)

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.
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. Maintain
tasks include:
— Reorg of the table
— Reorg of all indexes on the table
— Update of table statistics
MAINTAIN Command 213