Modifying Schema Entities › Index Modifications › Adding or Deleting Index Pointers

Adding or Deleting Index Pointers

Types of changes

You can delete or add index pointers. The index pointer in a member record is optional for system-owned indexes.

Adding or deleting index pointers

To add or delete an index pointer:

1. Modify the schema specifying INDEX POSITION IS NONE
2. Add or delete the pointer position using the RESTRUCTURE utility statement
3. Rebuild the index using the MAINTAIN INDEX utility statement