Recreating database indexes

Use this procedure to solve unexpected errors in the database indexes, for example, accidentally deleting an index.

  1. Right-click your environment and select Database > Recreate Database Indexes.
    Note:  You can also open the task by clicking Database > Recreate Database Indexes on the dashboard.
  2. Perform either of these options depending on the status of the environment:

    • If the environment is running, the message "Set M3 BE in maintenance mode" is displayed. Click Next.

    • If the environment is stopped, the environment will be started in maintenance mode.

      Note: The environment is in maintenance mode until the application is started or set online.
  3. Specify the user name and password of the database administrator.
  4. Click Next. The Component window is displayed.
  5. Specify this information:
    Component

    Select the component related to the database index.

    The component is specified in the Environment Configurator Components pane (MNS104). For standard M3 Business Engine, select the MVX component.

    System configuration

    Select the system configuration where the selected component is connected.

    The system configuration is specified in the Environment Configurator Configurations pane (MNS102). For the component MVX, the system configuration MVX is set by default.

    Table filter

    Specify the filter used to recreate indexes only for a specific table or list of tables using a comma separated list. If no filter is indicated, all indexes are recreated for all the tables related to the selected component.

    Number of threads

    Select the number of threads used for a parallel execution. The recommended number of threads is 2-3 threads per CPU.

    Recreate indexes only if it is necessary

    Select this option if you want that an index is only created or recreated if the index is missing or the keys for the index are out of sync. Otherwise, all the indexes are recreated. This option is selected by default.

  6. Click Next. The Summary window is displayed.
  7. Verify the values provided and click Finish.
  8. When the task is finished, a window is displayed. Click OK or click View log. You can also go to the Logs tab to view the log file.