auto_dbanalyzer
Use this command to switch on or off a function which automatically restarts Database Analyzer whenever the database is started. Also use it to display the status of this function.
You can switch the function on and off in any of the defined operational states of the database.
However, Database Analyzer only collects data if the database is in the ONLINE operational state.
If the database is ONLINE when you switch this function on, Database Analyzer immediately collects data on the status of the database. After this initial data collection, Database Analyzer periodically collects data (as per the valid time interval).
You can change the default time interval when switching on the automatic restart of Database Analyzer. The changed interval remains valid until Database Analyzer is switched off. When switching on Database Analyzer again, you must specify the desired interval again. Otherwise, Database Analyzer will be restarted with the default time interval.
If you start or stop the database while Database Analyzer is on, the automatic restart function for the Database Analyzer will use the time interval that was valid when the database was stopped.
You have the DBInfoRead server permission.
auto_dbanalyzer <option>
<option> :: = ON [<interval>] | OFF | SHOW
|
Option |
Description |
|---|---|
|
ON |
Activates the function for automatically starting Database Analyzer when the database is started, Database Analyzer starts collecting data if the database is in the online operational state |
|
<interval> |
Time interval in seconds applied by Database Analyzer for collecting data If you do not specify a value, the system default value of 900 is used. |
|
OFF |
Deactivates the function for automatically starting Database Analyzer when the database is started, Database Analyzer stops collecting data |
|
SHOW |
Displays whether the function for automatically starting Database Analyzer is ON or OFF and in which time intervals data is collected if the database is in the online operational state |
OK
[Automatic start of Database Analyzer is <ON | OFF>.]
[At the moment Database Analyzer is <ACTIVE | INACTIVE>.]
In the event of errors, see Reply Format.