Modifying Schema Entities › Index Modifications › Changing the Location of an Index

Changing the Location of an Index

Types of changes

You can change the area (or portion of an area) in which the index structure resides.

What components are affected

The schema set definition and data are affected. Subschemas and access modules that reference the member record are also affected.

Note: If a subarea symbolic is associated with the index, you change the portion of the area in which the index is stored by changing the physical area definition and regenerating DMCLs. See Chapter 27, “Modifying Physical Database Definitions” for more information.

Steps to change the area

To change the area (or portion of an area) in which an index resides when data has been loaded:

1. Add a new schema based on the original schema
2. Add the area, if necessary
3. Modify the indexed set to map to the new area or subarea/page range
4. Validate the schema
5. Create a new global subschema
6. Rebuild the index using both an old and new subschema using the MAINTAIN INDEX utility statement

Considerations

• If the area does not exist in the subschema, you will receive an error when you issue REGENERATE AFFECTED SUBSCHEMAS.