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 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)