Database Administration in CCMS, Database Analyzer
Database Studio, Starting or Stopping Database Analyzer
Database Manager CLI, Analyzing the Database Instance
Enter the following command on the command line:
dbanalyzer [<option_list>]
<option_list> : = <option> | <option> <option> ...
Option |
Description |
---|---|
-c <level> |
Displays debugging information You can specify a value between 1 (low) and 4 (high). |
-d <database_name> |
Database name |
-delete <date> |
Deletes all analysis data and log files of Database Analyzer up to and including the date <date> Enter <date> in the format YYYYMMDD. |
-f <configfile> |
Name of the configuration file If you do not specify a configuration file, Database Analyzer uses the dbanalyzer<version>.cfg file in the <dependent_path>/env database directory. More information:Glossary, Directory |
-i |
Deletes any existing log files for the same day |
-keep <days> |
Database Analyzer automatically deletes all Database Analyzer files and directories that are older than <days> days. |
-n <database_computer> |
Name of the computer on which the database is running If you specify the computer name, you must also use the –o option to specify the directory for the log files. More information: Database Administration, Log Files |
-noenv |
Suppresses logging and output of the environment variables from the configuration file |
-nologo |
Suppresses the logo |
-o <outputdir> |
Directory for the log files If you start Database Analyzer on the computer on which the database is installed, you do not need to specify –o. If you do not specify -o, Database Analyzer uses the analyzer subdirectory in the run directory of the database. More information: Glossary, Run Directory |
-state |
Displaying information about the running Database Analyzer |
-stop |
Stopping Database Analyzer |
-t <interval>[,<number>] |
Time interval <number> between two analyses (in seconds) and the chosen number <interval> of analyses The system default for <interval> is 900 seconds. If you specify a value for <number>, Database Analyzer ends after this number of analyses. |
-trace <treshold> |
If the system needs longer than <threshold> milliseconds to calculate a Database Analyzer object (SQL statement, parameter, array, or monitor), it is logged in the <outputdir>/<date>/DBAN.trc trace file. |
-u <database_user>,<database_user_password> |
Name and password of the database user |
-V |
Displaying the version of Database Analyzer |
-? |
Displaying help for Database Analyzer |
More information: Glossary, Syntax Notation