Procedure documentationStarting or Stopping Database Analyzer Locate this document in the navigation structure

 

Database Analyzer is a database tool for analyzing database performance.

Prerequisites

  • You are logged on to the database as database system administrator or as a DBM operator with server authorization for using Database Analyzer.

    More information: Glossary, Server Permission

  • The database is in the ONLINE operational state.

Procedure

  1. Select the database in the explorer tree.

  2. In the context menu of the database, choose Administration.

  3. Open the Overview tab page.

  4. Choose Database Analyzer.

  5. To start Database Analyzer, choose Activate Database Analyzer and specify the start options.

    Database Analyzer: Start Options

    Property

    Description

    Interval

    Time interval between two analyses

    Default value: 900 s

    Number

    Number of analyses to be performed

    Configuration file

    Name of the configuration file to be used

    If you do not specify a configuration file, Database Analyzer uses the dbanalyzer<version>.cfg file in the <installation_path>\env directory.

    You can display the installation path using the dbm_getpath DBM command: dbmcli dbm_getpath InstallationPath

    More information: Database Analyzer, Database Analyzer Configuration File

    Delete Logs

    Delete Database Analyzer log files

    To change options, specify the new options and choose Restart Database Analyzer.

    To stop Database Analyzer, choose Deactivate Database Analyzer.

Result

Database Analyzer writes its messages to the following log files.

Database Analyzer Log Files

File Name

Directory

Content

DBAN.prt

<run_directory>\analyzer\<date>

For more information, see Run Directory.

Database Analyzer log files

DBAN.inf

<run_directory>\analyzer

Database Analyzer status

DBAN.err

<run_directory>\analyzer

Database Analyzer errors

Further Database Analyzer Log Files

-

-