Log Files (SAP Library

Log Files

Definition

The analysis data collected by the Database Analyzer during the day, and any other logs from the Database Analyzer, are saved in a range of log files in the log file directory.

You can specify the log file directory as follows:

● When you call the Database Analyzer, you can use the option –o to specify the log file directory. The log files are saved in the subdirectories /YYYYMMDD.

● If you start the Database Analyzer on the computer on which the database instance is installed, you do not need to specify –o. The log files are saved in the subdirectory analyzer in the Structure link run directoryof the database instance.

Explanation of Some Log Files

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 during each measurement

The Database Analyzer weighs 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:

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 this file as soon as the Database Analyzer stops writing to it.

Log files of the Database Analyzer

The Database Analyzer provides a range of logs which are written, if problems with Database Analyzer tools occur.

● DBAN.err: Error file of Database Analyzer

● DBAN.inf: Current information on the most recently started Database Analyzer.
This file also contains information on identification of the database session (File DBAN.sid) and on identification of the processes (File DBAN.pid).

List of all Log Files

The following tables show you the information that you can find in the Database Analyzer.

Log Files for all Database Instance Types

DBAN.err	Error files of the Database Analyzer
DBAN.inf	Current information on the latest Database Analyzer started
DBAN.prt	Logs messages, including analysis rules and current values that caused the message
DBAN_BACKUP.csv	Number and duration of physical reads and writes during data and log backups
DBAN_CACHES.csv	Successful and unsuccessful accesses to the caches and hit rates
DBAN_CPU_UTILIZATION.csv	Information about the system load: CPU usage in user and system modes, displayed according to system and instance and time in the Idle state.
DBAN_FILLING.csv	Fill level of the database instance (for example, the size of the data volumes, number of permanently and temporarily used pages)
DBAN_IO.csv	Reads and writes to cache pages and data pages
DBAN_IOTHREADS.csv	Number and duration of physical reads and writes (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 the 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 on Shared SQL (hit rates for 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)

liveCache-Specific Log Files

DBAN_CACHES_OCCUPANCY.csv	Cache load and occupancy (proportion of OMS, SQL, and history pages in the data cache)
DBAN_GC.csv	Information about the activities of the garbage collector tasks: how often they were active, number of deleted objects and history objects, 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 OMS heap (such as occupancy, current size, collisions)
DBAN_OMS_VERSIONS.csv	Information on OMS versions (such as number and age of versions used)