Dropping an index

You can remove a secondary index from a DEDB database if it is no longer necessary.

To remove a secondary index:

1. Remove the LCHILD and XDFLD statements in the DBD for the primary DEDB database.
2. Remove or change the FIELD statement that specifies a /CK name.
3. Delete the DBD definition for its associated Fast Path secondary index database.
4. Delete any PSB definitions that have the PROCSEQD= parameter for the Fast Path secondary index database.
5. Run the DBDGEN utility with the new definitions without the Fast Path secondary index defined.
6. Run the PSBGEN utility with the new definitions without the Fast Path secondary index defined.
7. Run the ACBGEN utility with the new definitions without the Fast Path secondary index defined.
8. Take offline the primary DEDB database and its Fast Path secondary index database.
9. Perform an online change to revert changes in the primary DEDB database definition without secondary index defined.
10. Start the database on the primary DEDB database to make the database available for IMS online access.