Log Files 

The analysis data collected during the day is saved in the subdirectory / YYYYMMDD that you specify with the option –o when you call the Database Analyzer.

If you start the Database Analyzer on the server on which the database instance is installed, then you do not need to specify –o. In this case, the Database Analyzer uses the subdirectory analyzer in the run directory of the database instance.

The Database Analyzer generates the following log files:

DBAN_<monitor_class>.csv

These files contain all analysis data and are used to check runtime behavior.

One file exists for each monitor class (analysis area). You can use Microsoft Excel to open and read this file as soon as the Database Analyzer stops writing to it.

DBAN.prt

This file contains the following information:

·        Unique information about the configuration and performance-relevant data of the database instance

·        Bottlenecks discovered by the Database Analysis after each measurement

The Database Analyzer weights the information and bottlenecks:

I	Information	General information, such as the number of executed commands
W1 to W3	Warning levels 1 to 3	Bottleneck warnings with low, medium, and high priority
E	Emergency	Critical problems, such as an imminent database crash

See also:

List of All Log Files

List of Messages in the File DBAN.prt