auto_recreate_bad_index

You can instruct the database to recreate bad indexes automatically. You can also specify whether you want all bad indexes to be recreated automatically or only unique indexes that prove to be bad.

You can switch this function on or off. The default setting is OFF.

You also use this DBM command to display the status of this function.

If the function is ON, the system recreates bad indexes after having received a respective event from the database kernel.

Note Note

Make sure that X server is running.

End of the note.

Prerequisites

You have the server permissions EvtDispMgm and AccessSQL.

Structure

auto_recreate_bad_index <mode>

<mode> :: = ALL | UNIQUE | OFF | SHOW

Options
Option	Description
`<mode>`	Function for automatically recreating bad indexes Possible values are: `ALL`: Recreate all bad indexes `UNIQUE`: Recreate unique indexes that prove to be bad `OFF`: Disable function `SHOW`: Display function

Result

OK

[ALL | UNIQUE | OFF | UNKNOWN]

Values for the Reply Fields
Value	Description
`ALL \| UNIQUE \| OFF \| UNKNOWN`	Output if the `SHOW` mode is used `ALL`: The function is on. All bad indexes are automatically recreated. `UNIQUE`: The function is on. Unique indexes that prove to be bad are automatically recreated. `OFF`: The function for automatically recreating bad indexes is inactive. `UNKNOWN`: The system cannot determine the status of the function for automatically recreating bad indexes.

In the event of errors, see Reply Format.