Repairing R-tree indexes after migrating to a different version of a DataBlade® module

About this task

After you migrate to a different version of a DataBlade® module, you must synchronize R-tree index information and operator class functions for every R-tree index that uses the migrated DataBlade® module.

To repair R-tree indexes after migrating a DataBlade® module:

Procedure

  1. Determine which R-tree indexes are dependent on the migrated DataBlade® module.
  2. Run the following command for every affected R-tree index:
    oncheck -u update_capsules database:table# index

    Identify each index with its name, the name of the table it is based on, and the name of the database containing that table.

  3. Restart the database server.