Neoview SQL Reference Manual (R2.5)

MAINTAIN Command
• “Syntax Description of MAINTAIN”
• “MAINTAIN MVGROUP”
• “Examples of MAINTAIN”
The MAINTAIN command is a syntax-based utility that can be executed in the Neoview
Command Interface (NCI) or in the SQL Whiteboard of the HP Database Manager (HPDM).
The MAINTAIN command performs one or more table maintenance tasks, such as REORG,
UPDATE STATISTICS, and REFRESH, on a specified database object.
The MAINTAIN command provides support to specify multiple tables in one MAINTAIN
command. This feature is applicable only to base tables and the reorg task. It also optimizes
parallel reorg execution among all partitions from all tables.
IMPORTANT: The MAINTAIN command executes with cursor-like behavior and returns status
information for each task that it performs. If you plan to use the MAINTAIN command in a JDBC
or ODBC application, you must use fetch calls with the MAINTAIN command. For more
information, see “Using MAINTAIN in JDBC or ODBC Applications” (page 216).
The MAINTAIN command provides support:
• For users to specify one or more maintenance tasks for a specific object.
• For specifying a specific maintenance task for a particular object.
• To synchronously return status information as each task is executed.
• To perform tasks in parallel when it makes sense to do so.
• To continue object maintenance in the case of an error.
• Enable and disable maintenance tasks.
The forms of the MAINTAIN command are:
• MAINTAIN INDEX command
• MAINTAIN MV command
• MAINTAIN MVGROUP command
• MAINTAIN TABLE command
• MAINTAIN TABLES command
212 SQL Utilities