MAINTAIN INDEX Utility Statement

Modifying Non-SQL Defined Databases › Changes to Schemas and Subschemas › MAINTAIN INDEX Utility Statement

MAINTAIN INDEX Utility Statement

What MAINTAIN INDEX Does

The MAINTAIN INDEX utility statement allows you to build, rebuild, and delete both system-owned and user-owned indexes (indexed sets). You can also change the characteristics of an index, such as changing an index key from a compressed to an uncompressed format.

Steps to Modify Indexes

To make changes to an index, follow the procedure described in 32.2.2, "Procedure for Modifying the Non-SQL Definitions", adding the steps listed in the following table.

After ...	Do this
Modifying the schema and global subschema	For system-owned indexes: Use MAINTAIN INDEX to build, rebuild, or delete an index. For user-owned indexes (indexed sets): Write a program that calls IDMSTBLU and passes descriptor information

After ...

Do this

Modifying the schema and global subschema

For system-owned indexes:

Use MAINTAIN INDEX to build, rebuild, or delete an index.

For user-owned indexes (indexed sets):

Write a program that calls IDMSTBLU and passes descriptor information

Note: Depending on the operation, you will need either a subschema reflecting the old schema, the new schema, or both.

Note: For more information about MAINTAIN INDEX and IDMSTBLU, see the CA IDMS Utilities Guide.