Database Analyzer Log Files

When calling Database Analyzer, use option -o <outputdir> to specify the log file directory. Database Analyzer then saves the analysis data which is collected in the course of a day, as well as further log files, in the /YYYYMMDD subdirectories of the log files directory.

More information: Calling Database Analyzer

If you start Database Analyzer on the computer on which the database is installed, you do not need to specify the option -o. Database Analyzer then saves the log files in the analyzer subdirectory of the working directory of the database.

More information: Glossary, Working Directory

DBAN.prt

This file contains the following information:

Information about the configuration and performance-relevant data of the database
Bottlenecks discovered by Database Analyzer during each measurement

DBAN.prt: Abbreviations
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

More information: Database Analyzer Messages

DBAN_<monitor_class>.csv

These files contain all analysis data. They allow you to check runtime behavior retrospectively.

One file exists for each monitor class (analysis area). You can use Microsoft Excel to open and read these files.

Log Files for the Database Analyzer Program

Database Analyzer provides a range of logs which are written if problems with the Database Analyzer program occur.

DBAN.err: Error file
DBAN.inf: Runtime information for the latest Database Analyzer started
This file also contains information for identifying the database session (DBAN.sid file) and for identifying the processes (DBAN.pid file).

List of All Log Files

Database Analyzer: Log Files (All Database Types)
Log File	Description
`DBAN.err`	Error file
`DBAN.inf`	Current information on the latest Database Analyzer started
`DBAN.prt`	Records Database Analyzer messages, including analysis rules and current values that caused these messages
`DBAN_BACKUP.csv`	Number and duration of physical write and read operations during data and/or log backups
`DBAN_CACHES.csv`	Successful and unsuccessful accesses to caches, and also hit rates
`DBAN_CPU_UTILIZATION.csv`	Information about the system load: CPU usage in user and system mode, broken down by system, database and time in idle state.
`DBAN_FILLING.csv`	Fill level of the database (for example, the size of the data volumes, number of permanently and temporarily used pages)
`DBAN_IO.csv`	Read and write operations to cache pages and data pages
`DBAN_IOTHREADS.csv`	Number and duration of physical write and read operations (I/O threads)
`DBAN_LOAD.csv`	Accesses and selectivity of `SELECT`, `FETCH`, `INSERT`, `UPDATE`, and `DELETE` statements
`DBAN_LOGGING.csv`	Number of log pages written, fill level of the log queue and so on.
`DBAN_OVERVIEW.csv`	Overview of the most important information from the log files of Database Analyzer.
`DBAN_REGIONS.csv`	Information about accesses to critical sections
`DBAN_RW_LOCKS.csv`	Information about accesses to critical sections (reader-writer locks)
`DBAN_SHARED_SQL.csv`	Statistics about shared SQL (hit rates of the prepare cache, command cache, cleanup, unload)
`DBAN_SPINLOCKS.csv`	Information about accesses to critical sections (spinlocks)
`DBAN_STRATEGY_INDEX.csv`	Accesses and selectivity for index searches
`DBAN_STRATEGY_PRIMKEY.csv`	Accesses and selectivity for `PRIMARY KEY` searches
`DBAN_STRATEGY_SCANS.csv`	Accesses and selectivity for `INDEX SCAN` and `TABLE SCAN` searches
`DBAN_TASK_ACTIVITIES.csv`	Information on task activities (such as number of SQL statements, number of running user tasks, number of task changes)
`DBAN_TASK_IO.csv`	Number and duration of physical writes and reads from perspective of the log writer, the user task, and the pager
`DBAN_TASK_STATES.csv`	Number and execution duration of processed statements Number and wait duration of the task states `Vsuspend`, `Vwait`, `sleep`
`DBAN_TRANSACTIONS.csv`	Number of SQL statements and procedure calls, `PREPARE`, `EXECUTE`, `COMMIT`, and `ROLLBACK` statements, sub-transactions, `TIMEOUTS` caused by locks, and conversions of row locks to table locks (Lock List Escalations)

Database Analyzer: SAP liveCache-Specific Log Files
Log File	Description
`DBAN_CACHES_OCCUPANCY.csv`	Cache load and occupancy (proportion of OMS, SQL, and history pages in the data cache)
`DBAN_GC.csv`	Information about garbage collector task activities: how often were they active, the number of deleted and history objects, the number of physical I/O operations.
`DBAN_OMS.csv`	Number of calls by DB procedures, dereferences, deleted objects, history accesses
`DBAN_OMS_CONTAINER.csv`	Information on class containers (such as number of classes, occupancy, number of free pages)
`DBAN_OMS_HEAP.csv`	Information on the OMS heap (such as occupancy, current size, collisions)
`DBAN_OMS_VERSIONS.csv`	Information on OMS versions (such as number and age of versions used)