Procedure documentationCalling Database Analyzer Locate this document in the navigation structure

Procedure

Calling Database Analyzer from CCMS (in SAP Systems only)

Database Administration in CCMS, Database Analyzer

Calling Database Analyzer from Database Studio

Database Studio, Starting or Stopping Database Analyzer

Calling Database Analyzer from Database Manager CLI

Database Manager CLI, Analyzing the Database Instance

Calling Database Analyzer on the Command Line

Enter the following command on the command line:

dbanalyzer [<option_list>]

<option_list> : = <option> | <option> <option> ...

Database Analyzer: Call Options

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