With this command you instruct the database to recreate bad indexes automatically. You can 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.
The group of DBM commands that uses the built-in event dispatcher requires its own event task. For this reason, make sure when you switch on this function that the FloatingServiceTasks and PreservedEventTasks database parameter values are large enough.
Also make sure that the X server keeps running since the auto_recreate_bad_index function only works if X server is running on the database computer.
You have the server permissions EvtDispMgm and AccessSQL.
auto_recreate_bad_index <mode>
<mode> :: = ALL | UNIQUE | OFF | SHOW
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 status |
OK
[ALL | UNIQUE | OFF | UNKNOWN]
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.