Neoview SQL Reference Manual (R2.4)

MAINTAIN Command
• “Syntax Description of MAINTAIN”
• “Examples of MAINTAIN”
The MAINTAIN command is a syntax-based utility that can be executed in the Neoview
Command Interface 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.
In this release, the MAINTAIN command provides support to specify multiple tables in one
MAINTAIN command. This new 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 213).
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
210 SQL Utilities