Processing dependent indexes

Edit online

You can automatically process all indexes that are related to a table space by using the Process Dependent Indexes field.

About this task

  1. If Process Dependent Indexes is set to N, and the object profile is used with a RECOVER utility, indexes that are related to the recovered table spaces will be placed in REBUILD PENDING status by Db2 after the recovery.
  2. If you specify to process dependent indexes and you request both a REORG TABLESPACE and a REORG INDEX in the same job profile, a REORG INDEX step is not generated for the dependent indexes. These indexes are automatically reorganized by the REORG TABLESPACE utility and do not need to be processed in a separate step.

Procedure

  1. To process dependent indexes, do one of the following:
    • On the Enter Tablespaces Like to Display window, enter Y in the Process Dependent Indexes field.
    • On the Update Object Profile Display, when viewing objects already included in the profile, enter Y in the Process IX column for the selected objects.
  2. On the Update Object Profile Display, you can view the indexes that are included in the profile by using the EXPLODE primary or line command.