Autonomous Update Statistics (-SQLAutoStats)
- Last Updated: August 23, 2021
- 1 minute read
- OpenEdge
- Version 12.2
- Documentation
| Operating system and syntax | UNIX / Windows |
|
||
|---|---|---|---|---|
| Use with | Maximum value | Minimum value | Single-user default | Multi-user default |
| DBS | — | — | OFF | OFF |
- ON
-
Set the value of this parameter as ON, during startup, to start the Autonomous Update Statistics (AUS) service. Once the value of the parameter is set, it is remembered for the lifetime of the server and for all connections.
While the database is running, you may change this parameter using PROMON or through the _DbParams VST. This change only affects the primary broker and any newly spawned servers. Changes to existing secondary brokers while the database is running require a restart.
You can use this parameter to support continuous operation of the database. For more information, see Change database parameters while the database is running.